Configure Data Delivery System

The Data Delivery Service (DDS) application enables companies to extract massive amounts of data and send it to a cloud storage location.

To access the Data Delivery Service configuration, go to Company > Admin > Subscriptions > Data Delivery Service > Configure.

Prerequisites

Data Delivery Service (DDS) works with your cloud storage system. In order for DDS to export the files to the cloud storage, you must have a cloud storage system and configure it to work with your company. For details on configuring cloud storage for use with DDS, see Cloud Storage for reports.

About Data Delivery Service

Data Delivery Service (DDS) is a way to export massive amounts of data. The data extracted through DDS is uploaded to your cloud storage service. Data delivery can be scheduled or run on demand.

Intacct designed DDS to export all the data of a certain type, such as General Ledger data suppliers, employees, inventory, AR records, and more. Its primary goal is to export all the records for each object you select so that you can slice and dice that data for your needs.

For each object, you get all the records for that object or only the records that were changed since the last export. For multiple objects, you get all the records for selected objects, each in its own file. DDS delivers each object as a separate .csv file.

Configure file naming enhancement (existing configurations only)

When sending data, DDS includes multiple .csv files in the export. To make it easier to see what changes have been made to the content without having to open it, the file name is appended with _cr (created), _upd (updated), or _del (deleted).

When you first subscribe to DDS, the enhanced file naming option is on by default. For existing configurations, you can enable the feature from the Configuration page. To turn off the feature, disable it.

1. Go to Company > Admin > Subscriptions.
2. In the list of available subscriptions, select Data Delivery Service, then select Configure.
3. Enable Include the type of change in the file name.
4. Select Save.

To return to the standard file naming convention, enable Use the same naming for all file types.

Configure GL account balance and resolve ID

DDS uses alphanumeric IDs for GL account balance (GLAccountBalance object) and GL resolve (GLResolve object) during post-processing to generate numeric IDs. Using the alphanumeric IDs reduces the post-process time significantly.

When you first subscribe to DDS, the GL account balance and resolve ID configuration is set to Use the alphanumeric record ID. This helps DDS jobs finish faster. For existing configurations, you can enable another option by selecting it and saving your changes.

Why enable the alphanumeric ID?

GL account balance calculation is complex. The amount of data being processed depends on multiple elements, such as how much data is stored in the General Ledger since inception, if, you're using standard and custom dimensions and how many you're using, and the number of currencies used in transactions.

When changing to an alphanumeric ID number from a numeric number, the only changes you'll see is that instead of the numeric record number you'll see the alphanumeric RECORDID field. The work is done behind the scenes.

You can change the setting at any time.

1. Go to Company > Admin > Subscriptions.
2. In the list of available subscriptions, select Data Delivery Service, then select Configure.
3. Scroll down to GL account balance and resolve ID configuration.
4. Select to enable another option.
   By default the GL account balance and resolve ID configuration is set to Use the alphanumeric record ID. This will help DDS jobs finish faster.
5. Select Save.

How does the switch to alphanumeric affect your use of DDS?

Depending on your use of DDS jobs, you might need to make some minor changes to the way you do things.

For example, if you typically extract GL account balance and resolve object record numbers and import them into your database, you might need to make changes to your workflow. You might need to run an historical extraction to get the records with the new alphanumeric format.

Contact your Intacct representative if you need assistance adjusting your DDS workflow.