You can create a pipeline that reads a data table in Oracle. The read pipeline imports the data from Oracle to Anaplan Data Orchestrator. It then uses the imported data to create or update a source dataset.

Prerequisites

You need a connection to Oracle to create a pipeline. Make sure you meet the prerequisites in these sections before you create a connection to Oracle and a read pipeline.

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.

Create a read pipeline

Use the Oracle connection you created to create the read pipeline. The read pipeline uses the connection to import data from a table in Oracle to a source dataset in Data Orchestrator.

To create a read pipeline:

  1. Select Data Orchestrator from the top-left navigation menu.
  2. Choose a dataspace from the list.
  3. Select Pipelines from the left-side panel.
  4. Select Create pipeline.
  5. Enter a Name for your pipeline and then select Create.
    You are taken to the pipeline designer view.
  6. Select the Source icon, and then complete these steps in the right-side panel:
    1. Select Oracle from the Connection type dropdown. 
    2. Select the Oracle connection you created from the Choose connection dropdown.
    3. Enter a new Label to change the source name that displays in the designer view.
    4. Select a Source location > Source, select a table from Oracle that you want to connect​ to, and then select Confirm. 
    5. Select Columns, choose which columns from the Oracle table you want to include, and then select Done.
      You can also optionally choose a cursor column.
  7. Optionally, select the add icon that appears between the Source and Sink nodes.
    You can add steps to your pipeline to process data.
  8. Select the Sink icon, and then complete these steps in the right-side panel:
    1. Select Anaplan from the Connection type dropdown.
    2. Select Datasets from the Choose connection dropdown.
    3. Enter a new Label to change the sink name that displays in the designer view.
    4. Select Target location > Table, and choose a dataset destination:
      • Choose existing dataset: If you choose this option, you will be asked to select an existing source dataset.
      • Create new dataset: If you choose this option, you will be asked to enter a Name and Description for the new dataset.
    5. Choose a write option for the dataset.
      If you chose Create a new dataset in the previous step, the write option only applies to later pipeline runs if you update the table in Oracle.
      • Upsert: Updates the existing rows and adds new rows if needed.
      • Append: Adds new data to the dataset without overwriting existing data.
      • Replace: Replaces all existing data with the new data being extracted, and overwrites any previous data.
    6. Review the source data from the Oracle table that’s being imported to the dataset, and then select Done.
  9. Select Publish, and then select Run to execute the data transfer.

The dataset displays in the Source datasets screen in Data Orchestrator. If you don't see the dataset, refresh the screen.

Run the pipeline with a Workflow

After you create the pipeline, optionally, you can choose to run the pipeline as part of an Anaplan Workflow. This enables you to automate data transfers based on a schedule, or trigger them manually as part of a larger sequence of tasks.