---
sourceDocument: Brazil Workflow Data Fabric
sourceDocumentLink: https://www.servicenow.com/docs/r/integrate-applications

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil Workflow Data Fabric

ft:clusterId :

    - crint

bundleId :

    - crint

workflow :

    - Creator


---

# Microsoft SQL Server

# Microsoft SQL Server {#ariaid-title1}

Release version: Brazil  
Updated September 30, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
The Microsoft SQL Server connector enables access to relational database data from your Microsoft SQL Server instance without moving or copying data.

Connection admins set up connections to Microsoft SQL Server in the Zero Copy Connector Hub and grant data stewards access. Data stewards use the connection to create data fabric tables and map data from Microsoft SQL Server. Users can then access Microsoft SQL Server data through the table list
view or GlideRecord scripts. For details, see [Managing data fabric tables](https://www.servicenow.com/docs/LoGgZ20y7DmSjp0sb8uhug "Access data virtually from an external source or a local table on your instance using data fabric tables.").{#sqlserver-zcc__sqlserver-zcc-para-1}

When you configure the connection with an access token, you can choose whether the connection authenticates using a shared, system-level OAuth entity profile or personal authentication.{#sqlserver-zcc__sqlserver-zcc-para-pauth}  
Note:  
With personal authentication, each user's access to Microsoft SQL Server data is authenticated and audited against their own credentials, not a shared account. This supports stricter access control and clearer audit trails.

The connector supports pushdown for the following Glide queries and list view operations, allowing most queries to execute at the data source:{#sqlserver-zcc__sqlserver-zcc-para-4}

* Sort
* Limit
* Offset
* Join (inner, left, right, full, and cross)

{#sqlserver-zcc__ul_sqlserver_pushdowns}

The connector also supports pushdown for cast expressions, string functions such as `LOWER` and `UPPER`, and date-part extraction, for example extracting the year from a date column. Unsupported
expressions fall back to Trino with correct results.

The connector also supports the following aggregate pushdowns: `avg()`, `count()`, `max()`, `min()`, `sum()`,
`STDDEV_SAMP`, `STDDEV_POP`, `VARIANCE_SAMP`, `VARIANCE_POP`, `COVAR_SAMP`, `COVAR_POP`, `CORR`, `REGR_INTERCEPT`,
and `REGR_SLOPE`. The connector also supports complex-expression pushdown, including arithmetic operations, `CAST`, `AND`/`OR`, `IN`, and
`LIKE`.{#sqlserver-zcc__sqlserver-zcc-para-5}

For known limitations, see the Knowledge Base article [Workflow Data Fabric - Primary Connectors Limitations \[KBB0010487\]](https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KBB0010487).{#sqlserver-zcc__sqlserver-zcc-para-2}

## Supported data types {#sqlserver-zcc__section_data_types}

The following table lists supported Microsoft SQL Server data types and the default matching data types in a data fabric table.  
Note:  
Microsoft SQL Server data types not included in the table aren't supported for data mapping in Zero Copy Connector Hub.  
{#sqlserver-zcc__table_sqlserver_datatypes__entry__2}

| Microsoft SQL Server | Data fabric table |
|-|-|
| BIT | True/False |
| TINYINT | Integer |
| SMALLINT | Integer |
| INT | Integer |
| BIGINT | Long |
| DECIMAL(p, s) | Decimal |
| NUMERIC(p, s) | Decimal |
| FLOAT(n) | Floating Point Number |
| REAL | Floating Point Number |
| DATE | Date |
| TIME(n) | Basic Time |
| DATETIME2(n) | Basic Date/Time |
| SMALLDATETIME | Basic Date/Time |
| DATETIMEOFFSET(n) | Date/Time |
| CHAR(n) | Char |
| VARCHAR(n) | String |
| TEXT | String |
| NCHAR(n) | Char |
| NVARCHAR(n) | String |
| NTEXT | String |
| VARBINARY(n) | String |
[Table 1. Data type mapping]

{#sqlserver-zcc__table_sqlserver_datatypes}
**Related tasks**   

* [Create a Microsoft SQL Server connection](https://www.servicenow.com/docs/kmzhcUaLRsOSnEjzIfym9Q "Create a zero-copy connection to Microsoft SQL Server to access relational database data in Zero Copy Connector Hub without moving or duplicating data.")