Create a connection in Anaplan Data Orchestrator to import data from Oracle. Then use the connection to extract data and create a source dataset.

Prerequisites

Before you create a connection, you need:

  • Either Oracle on-premise, or an Oracle instance hosted on a cloud platform, such as Amazon Web Services (AWS), Azure, Google Cloud Platform (GCP), or any other cloud provider.
  • An unencrypted Certificate Authority (CA) certificate in Privacy-Enhanced Mail (PEM) format.
  • A database user with a password that has at least read permission.

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. Select Connections on the left-side panel.
  3. Select Create connection.
  4. Select Oracle DB and then select Next.
    If you can't find the connector, enter a search term in the Find... field.
  5. On the Connection details page, enter these details and select Next:
    • Name: Create a name for your connection. The name can contain alphanumeric characters and underscores.
    • Description: Enter a description about your connection.
  6. On the Connection credentials page, enter your Oracle credentials 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: Then 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.

      For the connector to use the CA certificate, you must first decode the Base64-encoded CA certificate in the PEM format.
  7. After the connection test is complete, select Done.

Extract data from the Oracle connection

You can extract data from the Oracle connection to add source data to Data Orchestrator. The data extract creates a source dataset.

To extract data:

  1. Select Data Orchestrator from the top-left navigation menu.
  2. Select Source data from the left-side panel.
  3. Select Add data > From connection.
  4. On the Dataset details page, enter these details and select Next:
    • Connection
    • Dataset name
    • Description
    • Namespace
    • Path name
  5. On the Choose an upload type page, enter these details and select Next:
    1. Select the Load type:
      • Full replace: Completely replaces the current loaded data with the new data.
      • Incremental: Takes the data and incrementally updates what was previously loaded.
    2. Select the columns to import.
  6. Select Create in the confirmation dialog.