MySQL

concept brazil Updated Sep 10, 2026 1 min read mysql-zcc.md
Raw file servicenow.com

The MySQL connector enables access to relational database data from your MySQL instance without moving or copying data.

Connection admins set up connections to MySQL 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 MySQL. Users can then access MySQL data through the table list view or GlideRecord scripts. For details, see Managing data fabric tables.

Important: The MySQL primary connector is in preview. A primary connector in preview is developed and supported by ServiceNow, but is still being enhanced to include all planned functionality. While in preview, a connector may have limitations in platform support or available features.

A primary connector in preview is fully functional for its documented scope and receives the same ServiceNow support as other primary connectors. For details on specific functionality limitations, see Workflow Data Fabric - Primary Connectors Limitations [KBB0010487].

The connector supports pushdown for the following Glide queries and list view operations, allowing most queries to execute at the data source:

  • Sort
  • Limit
  • Offset
  • Filter
  • GroupBy
  • avg()
  • count()
  • max()
  • min()
  • sum()
  • References

Supported data types

The following table lists supported MySQL data types and the default matching data types in a data fabric table.

MySQL Data fabric table
tinyint unsigned Integer
smallint unsigned Integer
int unsigned Long
bigint unsigned Decimal
json Not supported
enum String
datetime Basic Date/Time
bit(1) True/False
tinyint Long
smallint Integer
int/integer Integer
bigint Long
float (Real) Floating Point Number
DOUBLE Floating Point Number
decimal/numeric Decimal
char(n) Char (fixed-length character field)
varchar/nvarchar/longvarchar/longvarchar String (variable-length character field)
date Date
time Basic Time
timestamp Date/Time
binary/varbinary/longvarbinary Varbinary

MySQL data types not included in the table aren't supported for data mapping in Zero Copy Connector Hub.

Related topics

Create a MySQL connection

Keywords MySQL connectorzero-copy connectorJDBC connectorrelational databasedata fabric
Search documentation
Search document titles and file paths on the brazil branch