MSSQL Data Export

MSSQL Data Export

The MSSQL Data Export Node allows users to export data directly to an MSSQL database from the Automated Flow module. Depending on the availability of SELECT permissions on the customer's SQL server, users can either select a schema/table from a dropdown or manually enter the table name. Afterward, a mapping interface is used to configure the data export process.

How to Access

1.Navigate to Campaign > Automated Flow > Data Export Node:

  • From the main menu, go to Automated Flow.
  • In the flow editor, first add and configure a Recurring Node, then select the Data Export Node.
  • Under Remote Target, choose MSSQL from the dropdown menu.

2.MS SQL Option in Data Export Node:

  • After selecting MSSQL, click Next to proceed to the schema/table selection screen.

How to Use

1: Select Permissions

The next screen will display different options depending on whether the system has SELECT permissions on the customer's SQL server:

Scenario 1: SELECT Permissions Exist

  • Select Schema and Table:
    • First, a Select Schema dropdown field will appear. Choose the schema from this dropdown. Once the schema is selected, a Select Table dropdown will appear. From this dropdown, select the table you want to export data to.
    • Click Next to proceed to the mapping interface.

Scenario 2: No SELECT Permissions

  • Manual Table Entry:
    • If the system does not have SELECT permissions, you will be prompted to manually enter the table name.
    • Input the table name in the provided field and click Next to continue.

2: Data Mapping Interface

  • Once the schema/table is selected (or manually entered), you will be presented with the mapping interface.
  • This interface mirrors the functionality found in the Data Space Update node, allowing you to map fields between the Dengage platform and the MS SQL database.
  • Complete the mapping by connecting the relevant Dengage platform fields to the corresponding MS SQL table columns.

    • Related Articles

    • Export

      This section explains the export part of CDP. It seamlessly extract and distribute data from any table, segment, or SQL query directly to FTP sites, key advertising platforms including Google Customer Match and Facebook Custom Audiences, and cloud ...

    • 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 ...

    • Automated Flow - Data Export to Google BigQuery for Segment/Table

      The Campaign Control Group Contacts log type is now available under Incremental Logs, allowing users to export detailed control group data used in campaigns. This enhancement supports transparency and auditability by providing direct access to ...

    • Adding ODBC as Remote Target to Data Export

      The ODBC Data Export feature allows users to export data directly to an ODBC database from the Automated Flow module. Depending on the availability of SELECT permissions on the customer’s ODBC server, users can either select a schema/table from a ...

    • Adding PostgreSQL as Remote Target to Data Export

      The PostgreSQL Data Export feature allows users to export data directly to a PostgreSQL database from the Automated Flow module. Depending on the availability of SELECT permissions on the customer’s PostgreSQL server, users can either select a ...