Create a connection in Anaplan Data Orchestrator to import data from PostgreSQL. Then use the connection to extract data and create a source dataset.
Create a connection with 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:
- Select Data Orchestrator from the top-left navigation menu.
- Select Connections on the left-side panel.
- Select Create connection.
- Select PostgreSQL and then select Next.
If you can't find the connector, enter a search term in the Find... field. - 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.
- On the Connection credentials page, enter your PostgreSQL credentials and then select Next:
- Username
- Password
- Host
- Port
- Database
- Schemas
- After the connection test is complete, select Done.
Extract data from the PostgreSQL connection
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:
- Select Data Orchestrator from the top-left navigation menu.
- Select Source data from the left-side panel.
- Select Add data > From connection.
- On the Dataset details page, enter these details and select Next:
- Connection
- Dataset name
- Description
- Namespace
- Path name
- On the Choose an upload type page, enter these details and select Next:
Notes:
- The
_ab
fields are added by Data Orchestrator and aren't user data. - If you selected Incremental as the load type (partial replace):
- Select a Primary key checkbox. You can select more than one checkbox.
- Data Orchestrator uses the
_ab
fields as cursor keys to identify what's changed. The values aren't used for a Full replace. - The Cursor Field is preselected.
- If you selected Append as the load type (partial replace):
- Data Orchestrator uses the
_ab
fields as cursor keys to identify what's changed. The values aren't used for a Full replace. - The Cursor Field is preselected.
- Data Orchestrator uses the
- Select Create in the confirmation dialog.