Reltio is always looking for new ways to improve their product to make it even more user friendly and beneficial for business. We have learned that many businesses using Reltio also use Snowflake, a data warehouse. We recently developed a product, Reltio Connected Data for Snowflake, that allows both systems to work together for improved business decisions.
In our last article, Reltio Connected Data for Snowflake: A Business Solution, we covered how Reltio and Snowflake now work together through Reltio Connected Data for Snowflake. We also touched on how to set up this product on the business end, and how the final product may solve some common issues businesses may face. In this blog, we will cover the features of Reltio Connected Data for Snowflake, and begin to go over some demonstrations within the Reltio platform.
Reltio Connected Data for Snowflake brings various business benefits to the table.
Note: Data transformation happens between Reltio and Snowflake in about thirty minutes. Although not real time, the data will be available quickly. This is another aspect that Reltio may develop if businesses need it.
Finally, any business or organization must focus on deriving business value, and spend less time working through mounds of data and worrying about how it has been delivered into Snowflake. The Reltio platform will manage the pipeline, taking this process even further off the shoulders of the business.
With Reltio Connected Data for Snowflake, you will be able to create a pipeline. Reltio will provide simple APIs to connect your Snowflake account with Reltio MDM, creating and scheduling pipeline definitions according to all of the available operations.
Then, Reltio takes care of delivering the data to Snowflake, taking this task away from users.
This self-service onboarding process uses APIs to drive tasks. Once this process has started, users will be able to monitor the status of the job that they are currently running, including the phase of the job and any important details. These details include how many objects have already been moved to Snowflake, how many are left to go, what objects failed to transfer, and more.
The data will be delivered via one of two ways. One is a JSON, which will have the entire source, or the crosswalk data. The other is the relational view, which could be an operational view where we have exploded the JSON into the standard tables where it is then consumed. If you’re a business user, you can connect a BI tool to one of these relational views, and if you are a data scientist, you can use the JSON format if you prefer.
Reltio considers security one of its most important features. Thus, we have ensured that Reltio Connected Data for Snowflake complies with Snowflake’s best practices, giving users a completely secure connector, absolutely encrypted from end to end.
There is a license fee for Reltio Connected Data for Snowflake. This fee is an annual subscription. If you are already an existing customer, just reach out to a customer success manager to find out specifics. If you are a new customer, reach out to an account executive.
While there are limitations to what Reltio Connected Data for Snowflake can do right now, it is by no means a stagnant product that will never change. In fact, internally, Reltio has many plans to further improve this product for organizations. For instance, it is possible to get historical information into Snowflake, though not in the current release. However, this will be available down the road, as well as the ability to move activity log data into Snowflake.
Likewise, Reference data RDM will not be synced through this product with Snowflake. Many objects are available to be moved to Snowflake, like entities, relations, and match and merge. However, based upon customer feedback, Reltio can develop the product to allow for delivery of RDM, if this is a common need moving forward.
Before diving into a full demonstration of Reltio Connected Data for Snowflake, be sure you understand the following definitions.
In our third and final blog, we will apply these terms and go over a full demonstration, as well as an architecture overview of Reltio Connected Data for Snowflake.
Relevant Content: Reltio Connected Data for Snowflake: A Business SolutionReltio Academy now offers a detailed course on Snowflake! The course provides you with an overview of how you can use Reltio and Snowflake together to better solve business problems. It outlines the steps required to integrate Reltio and Snowflake in order to seamlessly export data from Reltio to Snowflake and provides some best practices to manage and export data for Snowflake. You will also learn about the various options available to export quality data from Reltio to Snowflake and how to execute queries in Snowflake to access the exported data.Partners can access the course here.Customers can access the course here.
Please keep in mind: everything covered here, and in connected blogs and webinars, is intended for informational purposes only. If you or your business choose to purchase, we recommend that you do not base your decision solely on this presented information. All of Reltio’s products, and their counterparts, remain the property of Reltio.
100 Marine Pkwy #275, Redwood City, CA 94065
+1 (855) 360-DATA+1 (855) 360-3282
© 2022 Reltio. All Rights Reserved
Site by eConverse MediaAlso of Interest: Master Data Management (MDM) Reltio Community Reltio Integration Hub Community, Data Management Community Matching, Merge, Survivorship Reltio Workflow Master Data Management (MDM)