Data synchronization

Solution design

Flow steps

  • Upon installation, the following four data tables will be created in the customer's Snowflake instance to mirror Anduin’s data schema:
    • ANDUIN_IDM_INTEGRATION_CLIENTS
    • ANDUIN_IDM_INTEGRATION_INVESTMENTS
    • ANDUIN_IDM_INTEGRATION_PROFILES
    • ANDUIN_IDM_INTEGRATION_DOCUMENTS
  • All existing Anduin data will then be pushed to the corresponding Snowflake tables.
  • Moving forward, any updates made in Anduin will automatically trigger the corresponding updates in Snowflake

Configuration

Find the right solution

  • Navigate to Browse tab
  • Look for Snowflake integration
  • Initiate the installation

Install and Configure

  1. Introduction
  • This is supposed to be a introductory screen. You can name the integration your way and skip to the next step.
  1. Authentication
  • You need to enter your Snowflake credentials here to proceed.
  1. Select Anduin and Snowflake object
  • You can specify Anduin IDM firm as the source of data by inputting the Anduin IDM firm ID
  • You also need to select the specific warehouse and database in your Snowflake so we know the correct destination to push data into