Import data from PostgreSQL

You need your PostgreSQL credentials to connect the PostgreSQL data with Data Orchestrator. See the PostgreSQL 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 PostgreSQL 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 PostgreSQL credentials and then select Next:
   • Username
   • Password
   • Host
   • Port
   • Database
   • Schemas
7. After the connection test is complete, select Done.

You can extract data from the PostgreSQL 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.
      • Append: Adds the new data to the end of the current table.
      • Incremental: Takes the data and incrementally updates what was previously loaded.
   2. Select the columns to import.
6. Select Create in the confirmation dialog.