Adding Remote Data Sources

You can use your data located in Google BigQuery or Amazon Redshift from the dEngage platform. Please follow the instructions below in order to create and use your data located in remote sources.

Prerequisites

• Create a Remote Source from the Web UI to configure and connect your Google BigQuery or Amazon Redshift account with D.engage.
• Create an Automated Data Job to import data from a remote data source by building an SQL query.
  

Adding Google BigQuery as a Remote Data Source

1. Go to Settings > Remote Sources
2. Click Add and Select Google BigQuery
3. Paste your Key Json to the text editor
   

Adding Amazon Redshift as a Remote Data Source

1. Go to Settings > Remote Sources
2. Click Add and Select Amazon Redshift
3. Fill out the form and enter your Amazon Redshift credentials
   

Importing Data from your Remote Data Sources

Once you have created and configured Google BigQuery or Amazon Redshift to your account, you can use Automated Jobs from the web UI in order to import your data from these remote sources.

1. Go to Data Space > Automated Jobs 
2. Click Add to create a new job
3. Drag and drop the "Audience Builder" or "Data Builder" node to import your data
4. Select the "Create from Remote Source" option
5. Import data from the selected Remote Source by building an SQL query
6. Click "Validate and Preview" once you have built your query
   

• Related Articles

• Adding Remote Filters

  You can add filters to your data located in Google BigQuery or Amazon Redshift from the dEngage platform. Please follow the instructions below in order to create and use the remote filters. Prerequisites Create a Remote Source from the Web UI to ...

• Event Data Integration

  There are two options to send Event Data to D·engage: 1. Send event data via D·engage SDK First, you need to create a website application to use the dEngage Web SDK. Go to D·engage Event SDK page for detailed instructions to 'create an ...

• June 05, 2020

  New Features Available with this Release: Importing and Using Data from Amazon Redshift and Google Big Query Sending Push Notifications to Huawei Devices Using Reply-To Address in Email We're happy to announce that you you can use the "Remote ...

• CDMP Data Import

  Data imports enables you to import new records (or) update existing data through a CSV file. This is particularly useful when migrating from other platforms to D·engage, or performing mass updates to a large chunks od records. The process is quite ...

• March 2021

  w features available with this release: Campaign Approval Process (Maker/Checker) Emergency Panic Button App uninstall tracking Remote Segment with variables Campaign Approval Process (Maker/Checker) Campaign approval allows Marketing teams to ...