Oracle · SN Doc Reader

Oracle

concept australia Updated Sep 10, 2026 1 min read oracle-zcc.md

The Oracle connector provides read-only access to data and metadata from an Oracle database.

A connection admin can set up a connection to Oracle in the Zero Copy Connector Hub and grant data stewards access to this connection. Data stewards can then use the established connection to create a data fabric table and map data from Oracle. This allows users to access Oracle data through the table list view or by using GlideRecord scripts. For details on creating data fabric tables and mapping data, see Managing data fabric tables.

The connector has been enhanced to improve the performance of the following Glide queries and list view operations. These improvements allow the majority of queries to be executed at the data source.

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

Supported data types

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

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

Oracle	Data fabric table
number	Decimal
binary_float	Floating Point Number
binary_double	Floating Point Number
char	String
varchar2	String
nchar	String
nvarchar2	String
date	Basic Date/Time
timestamp	Basic Date/Time
timestamptz	Date/Time
bool_sim	String
FLOAT[(p)]	Floating Point Number
TIMESTAMP(p) WITH TIME ZONE	Date/Time

Related topics

Create an Oracle connection

59 lines · 2.3 KB Wrap lines

---
title: Oracle
description: The Oracle connector provides read-only access to data and metadata from an Oracle database.
locale: en-US
canonical_url: https://www.servicenow.com/docs/r/australia/integrate-applications/oracle-zcc.html
release: australia
topic_type: concept
last_updated: "2026-09-10"
reading_time_minutes: 1
breadcrumb: [Primary connectors, Manage zero copy connections, Zero Copy Connectors, Workflow Data Fabric]
---

# Oracle

The Oracle connector provides read-only access to data and metadata from an Oracle database.

A connection admin can set up a connection to Oracle in the Zero Copy Connector Hub and grant data stewards access to this connection. Data stewards can then use the established connection to create a data fabric table and map data from Oracle. This allows users to access Oracle data through the table list view or by using GlideRecord scripts. For details on creating data fabric tables and mapping data, see [Managing data fabric tables](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/managing-data-fabric-tables-zcc.md).

The connector has been enhanced to improve the performance of the following Glide queries and list view operations. These improvements allow the majority of queries to be executed at the data source.

-   Sort
-   Limit
-   Filter
-   GroupBy
-   avg\(\)
-   count\(\)
-   max\(\)
-   min\(\)
-   sum\(\)
-   References

## Supported data types

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

**Important:** Oracle data types not included in the table aren't supported for data mapping in Zero Copy Connector Hub.

|Oracle|Data fabric table|
|------|-----------------|
|number|Decimal|
|binary\_float|Floating Point Number|
|binary\_double|Floating Point Number|
|char|String|
|varchar2|String|
|nchar|String|
|nvarchar2|String|
|date|Basic Date/Time|
|timestamp|Basic Date/Time|
|timestamptz|Date/Time|
|bool\_sim|String|
|FLOAT\[\(p\)\]|Floating Point Number|
|TIMESTAMP\(p\) WITH TIME ZONE|Date/Time|

**Related topics**  


[Create an Oracle connection](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/create-oracle-connection-zcc.md)