Prerequisites

Before starting, ensure you have an active Daton and Capillary Martjack account.

Task 2: Integrate Capillary with Daton

• Signin to Daton 
• Select Capillary from the list of Integrations 
• Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later.
• Provide Capillary database hostname, port, username, password, and merchant id. 
• Post successful authentication, you will be prompted to choose from the list of available database schemas
• Select required tables from the list for each database schema
• Then select required fields for each table. 
• Select replication field for each table. 'Select None' will lead to full table replication. Selection of any primary keys or dates will load data in incremental manner.
• Submit the integration.

Important Note

• Integrations would begin in the Pending state and change to the Active state once the first job successfully loaded data into the configured warehouse.
• Users can check job status and process logs from the integration details page by clicking on the integration name in the active list.
• Users can Re-Authenticate, Edit, Clone, Pause, or Delete the integration at any moment by clicking on settings. You can also adjust the frequency and history of the integration.
• On the Sources page, click Integration to access each table in your integration. The page also shows the state of each table, the last replicated time, and the Reload access buttons.