Create a Demandbase Data Stream Manually
After you set up a Demandbase connection, you can create a data stream to start the flow of data from your Demandbase source to Data Cloud. Using the Demandbase Data Kit to configure the data stream is recommended, but not required.
Before creating a data stream, make sure that an SFTP connection is set up. See Set Up an SFTP Connection.
- In Data Cloud, on the Data Streams tab, click New.
You can also use App Launcher to find and select Data Streams. - Select Demandbase, and click Next.
- Choose from the available Demandbase connections.
- Enter the file details.
| Field | Description |
|---|---|
| Import from Directory | Remaining folder path under the parent directory that points to a file’s specific location. |
| File Name | To retrieve all the CSV files, select *.csv as the file name. The file name supports wildcards and CSV file formats. For example, you can use abc.csv to retrieve all file names containing “abc.” Each time the stream runs, all files that match the name, including wildcards, are imported. |
| Source | The external system where data is sourced. Multiple data streams can have the same source. |
- Click Next.
- Create a data lake object (DLO), or use an existing DLO.
If you’re creating a DLO, see Data Lake Object Naming Standards. If you’re using an existing DLO, see Using an Existing Data Lake Object to Create a Data Stream. - If you’re creating a DLO, edit the fields identified in the table.
| Field | Description |
|---|---|
| Category | Identify the type of data in the data stream. If you’re creating a company or contact data stream, select Profile. If you’re creating an intent data stream, select Engagement. In the Event Time Field, select start_date. If you’re creating any other data stream, select Other. |
| Primary Key | To identify a record, select record_id. |
| Record Modified Field | If data is received out of order, the system uses the record modified field as a reference point to decide whether to update the record. The record with the most up-to-date timestamp is loaded. |
| Organization Unit Identifier | Select the business unit to use for a record’s data lineage. |
- Enter a DLO label, API name, and object details.
- (Optional) Add formula fields.
- Click Next.
- Select Full Refresh as the Refresh Mode.
- Enter the deployment details, and click Deploy.