Oracle

Setting up the Oracle connector

No	Item	Required	Example	Notes
1	Host	Yes		Hostname of the database.
2	Port	Yes		Port of the database.

Oracle Corporations recommends the following port numbers: 1521 - Default listening port for client connections to the listener. 2484 - Recommended and officially registered listening port for client connections to the listener using TCP/IP with SSL | | 3 | Connect by | Yes | | Connect data that will be used for DB connection
Refer to the documentation in the form while using the connector
Service name
System ID (SID)
| | 4 | User | Yes | | The username which is used to access the database. | | 5 | Password | No | | The password associated with the username. | | 6 | Schemas | No | | The list of schemas to sync from. Defaults to user. Case sensitive. | | 7 | JDBC URL Params | No | | Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3). | | 8 | Encryption | Yes | | The encryption method with is used when communicating with the database.
Refer to the documentation in the form while using the connector
Unencrypted
Native Network Encryption (NNE)
TLS Encrypted (verify certificate)
|

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.