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

  1. Ensure that you have reviewed About Openflow Connector for Oracle.

  2. Ensure that you have set up an Openflow deployment:

  3. 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