You can import data from Oracle to create source datasets in Anaplan Data Orchestrator (ADO). To import data, you need a connection to Oracle and either a pipeline or a connection extract.

You must first create a connection to Oracle with the Oracle connector in Data Orchestrator. Then use that connection to either create a pipeline or use a connection extract for data import.

Connectivity prerequisites

Before you can create a connection to Oracle, you need to meet these prerequisites.

ItemNotes
Oracle database (DB) instance

You need to have an Oracle DB instance hosted on a cloud platform, such as Amazon Web Services (AWS), Azure, Google Cloud Platform (GCP), or any other cloud provider.

The Oracle connector supports Oracle DB version 11g or above. Tested versions include: Oracle 11g, 12c, 18c, 19c, and 21c.

Certificate Authority (CA) certificate

You need an unencrypted CA certificate in Privacy-Enhanced Mail (PEM) format.

If you directly access the CA certificate from an AWS secret manager, you must decode the Base64-encoded CA certificate in the PEM format.

Oracle database userYou need to be a database user and have read permissions.

Create a connection to Oracle

You will need your Oracle credentials to connect the Oracle data with Data Orchestrator. See the Oracle documentation for more information.

To create a connection:

  1. Select Data Orchestrator from the top-left navigation menu.
  2. Choose a dataspace from the list.
  3. Select Connections on the left-side panel.
  4. Select Create connection.
  5. Select Oracle DB and then select Next.
    If you can't find the connector, enter a search term in the Find... field.
  6. Enter these details on the Connection details screen, and then select Next:
    • Name: Create a name for your connection. The name can contain alphanumeric characters and underscores.
    • Description: Enter a description about your connection.
  7. Enter your Oracle credentials on the Connection credentials screen, and then select Next:
    • Username: The Oracle user name required to authenticate.
    • Password: The Oracle password required to authenticate.
    • Host: The Oracle host domain. The host is provided by the administrator of your Oracle instance.
    • Port: The Oracle port number. The port number is provided by the administrator of your Oracle instance.
    • Service Name: The Oracle service name.
    • Schemas: The Oracle schema.
    • CA Certificate: The Oracle connector supports TLS/SSL encryption.
      TLS/SSL encryption enables you to establish a secure, encrypted connection to Oracle instances. It protects data in transit from being intercepted or read by unauthorized parties. The connection is secured using a digital certificate installed on the server. This provides an essential layer of data protection.
  8. After the connection test is complete, select Done.

Import data

You can import data from Oracle with a pipeline or a connection extract. Use the connection you created to configure the pipeline or connection extract.