Skip to content
English
  • There are no suggestions because the search field is empty.

How to use the Sync Configuration feature

This article explains how our BI Connector and Database Integration users can suppress and enroll tables and columns in their data sync.

 

Controlling what data tables and columns you want syncing between your data source and Datawarehouse.io is easy with Sync Configuration.

Below are the steps to take to access and use the feature:

1. Log into your Datawarehouse.io account page at https://app.datawarehouse.io/


2. From the main dashboard, navigate to the My Apps section and click the button corresponding to your Connector or Database Sync app.


3. On the app details page, click on the label that corresponds to your subscription under the Sync Name column to open your user panel.


4. In your user panel, locate and click the Configure Sync button (see example below).

 

 


5. On the Sync Configuration page, you’ll see a list of all tables currently syncing into your dataset.

  • To suppress an entire table, check the box next to the table name.

  • Then click Enable, followed by Save, to apply the suppression.

 


 

 

 

6. To suppress specific fields/columns within a table:

  • Click the Edit Properties button next to the desired table.


  • You’ll then see a list of fields that are currently populated within that table.

  • Select the fields you’d like to suppress and follow the same Enable → Save process.

 


 

Once your changes are saved, they will take effect on the next scheduled resync. Disableing tables/fields will remove all of the tables/fields you have selected from your database and prevent them from syncing into your database. This can help clear up space in your database and making the sync more efficient, reducing usage of your databases resources.

If you ever need to reverse a suppression, simply return to the Sync Configuration page and follow the same procedure to re-enable the relevant tables or fields.

Please note that removing an active suppression will trigger a full resync for all affected tables. This means the app will perform a full resync for all data in the affected table that you add new fields to. The app performs this action to ensure data integrity and consistency. Full resyncs may take an extended period of time to complete depending on the volume of data in your database.