Create a Heroku PostgreSQL Data Stream

Start the flow of data by creating a data stream for your Heroku PostgreSQL data source. The data stream creates a data lake object (DLO) in Data Cloud that you can map to the Customer 360 Data Model to use across Data Cloud.

User Permissions Needed 
To create a connection:Data Cloud admin OR Data Cloud Marketing admin

Before you begin:

  • Make sure that the required Heroku PostgreSQL connection is set up.

  1. In Data Cloud, on the Data Streams tab, click New.

    You can also use App Launcher to find and select Data Streams.

  2. Under Other Sources, select the Heroku PostgreSQL connection source, and click Next.

  3. Select from the available Heroku PostgreSQL connections.

  4. Select the object that you want to import, and click Next.

    You can select one new object on the Available Objects tab or an existing object on the In Use Objects tab.

  5. Under Object Details, for category, identify the type of data in the data stream.

  6. For primary key, select a unique field to identify a source record.

    If a composite key is required or a key doesn’t exist, you can create one using a formula field. See Create a Formula Field or Use Case 2: Create a Primary Key.

  7. (Optional) Select a record modified field.

    If data is received out of order, the record modified field provides a reference point to determine whether to update the record. The record with the most up-to-date timestamp is loaded.

  8. (Optional) To identify the data lineage of a record’s business unit, add the organization unit identifier.

  9. Click Next.

  10. For Data Space, if the default data space isn’t selected, assign the data stream to the appropriate data space.

  11. Click Deploy.

When the Last Run Status displays success, you can see how many records were processed and the total number of records that were loaded.

You can now map the created DLO to the data model to use the data in segments, calculated insights, and other use cases.