Reltio Connect

 View Only

  • 1.  Reltio Integration Hub - Snowflake connector

    Reltio Partner
    Posted 12-16-2021 13:00
    Can Reltio Integration hub fetch data from Snowflake source and load into Reltio? Please share the detailed steps how to do that

    ------------------------------
    Abhijit Auddy
    Cognizant
    ------------------------------


  • 2.  RE: Reltio Integration Hub - Snowflake connector

    Reltio Employee
    Posted 12-20-2021 04:31
    Hi,

    Thanks for reaching out and asking your question on community. It would be good to know in some detail what is the use case of such integration. What kind of data load are we talking about and how much data? Answers to some of these questions would help to advise a suitable solution. 

    As for Reltio Integration Hub, it provides a Snowflake connector using which you can build a recipe to replicate data to Reltio. You can build a recipe that is schedule for example on a daily basis that reads batch of rows from Snowflake and replicates that data into Reltio.

    While creating the connection to Snowflake, you need to provide the account, warehouse, database and schema details along with the credentials (user/password or oAuth 2.0 credentials).

    Regards
    Gaurav

    ------------------------------
    Gaurav Gera
    ------------------------------

    Original Message


  • 3.  RE: Reltio Integration Hub - Snowflake connector

    Reltio Partner
    Posted 12-20-2021 04:44
    Thanks for your reply.
    Snowflake will be treated as one of source of Customer data. Other sources are CRM and legacy file system. Snowflake will have information of master & transaction data also. The total volume of Customer master is ~5 Million and most of the information will come from Snowflake. We have to build interfaces for initial data load (batch), incremental batch load and near real time interface. We need to fetch the data, transform and load into Reltio .

    ------------------------------
    Abhijit Auddy
    Cognizant
    ------------------------------

    Original Message