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
Step 3: Select Source Table
Follow the instructions in the image below to select and preview your source table
Step 4: Select/Create Destination Table
Select your destination data source and schema name. Then enter your destination table name.
Step 5: Validate input and destination table structure
Follow the steps below:
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