Import Database Table

Import Database Table is a feature that allows admins and analysts to import data from a database table to another. Admins/analysts can also specify the frequency of import to allow the table to be kept in sync with the source. The destination table then can be used in reports/dashboards like a normal table.

Following the steps below to set up Database table import

Step 1: Set up a data source to allow data import

Set up your database to allow write access for a given data source. Setting up separate schema that allows write access is recommended. Please have a look at our docs on how to connect your database to Holistics.

Step 2: Create a new data import

Click Add new data import in Manage -> Data Imports

Add new data import

Step 3: Select Source Table

Follow the instructions in the image below to select and preview your source table

Setup Source

Step 4: Select/Create Destination Table

Select your destination data source and schema name. Then enter your destination table name.

Setup Destination

Step 5: Validate input and destination table structure

Follow the steps below:

Validate input and destination table structure

1) Choose import mode for this import.

2) Setup destination columns' name and type

7) Schedules for current data import can be modified under Schedules header on the left side panel. Optionally, data import can be executed manually by clicking on 'Execute' link for that import from the list.

8) Once you've completed step 4) to Validate Sync Config and fill data import's name, you can Save it.

Step 6: View, edit and execute your data import

Once saved, your data import can be found at Data Imports Listing

New Data Import