Set up tasks for the Openflow Connector for Oracle¶
Note
This connector is subject to the Snowflake Connector Terms.
Note
The Openflow Connector for Oracle is also subject to additional terms of service beyond the standard connector terms of service. For more information, see the Openflow Connector for Oracle Addendum.
This topic describes the overall tasks required to set up, configure, and run the Openflow Connector for Oracle.
Prerequisites¶
Before you set up the Openflow Connector for Oracle, verify that the following prerequisites are met:
-
Ensure that you have reviewed About Openflow Connector for Oracle.
-
Ensure that you have set up an Openflow deployment:
-
Ensure that you add only one connector instance per runtime.
Tasks¶
Perform the following tasks to set up, configure, and run the Openflow Connector for Oracle.
| Order | Task | Description | Persona |
|---|---|---|---|
| 1 | Review Prerequisites | Review and confirm all required prerequisites. | Snowflake account administrator |
| 2 | Enable the connector | Accept the Oracle XStream terms to make the connector visible in the list of available connectors. | Organization administrator (ORGADMIN) |
| 3 | Configure the Oracle database | Configure the Oracle database for Openflow Connector for Oracle including replication settings and credentials. | Oracle database administrator |
| 4 | Set up Snowflake | Create the destination database, service user, role, warehouse, and key pair authentication for the Openflow Connector for Oracle. | Snowflake account administrator |
| 5 | Configure the connector | Install, configure, and run the Openflow Connector for Oracle connector. | Snowflake account administrator |
| 6 | Set up licensing | Configure your licensing model after the connector detects your source database inventory. | Organization administrator (ORGADMIN) |
Next steps¶
- Monitor the flow.
- Maintenance for reinstalling the connector or changing the XStream position.