Reltio Connect

 View Only
  • 1.  Export Data located in Reltio to report and analyze on Power BI

    Reltio Partner
    Posted 10-06-2023 06:16

    Hi Team! It's Álvaro, from Spain.

    My team is getting started in Reltio, we are currently certifying ourselves and learning through the Reltio Learning Platform.

    However, we are preparing a proposal for a client and he is asking if it is possible to show the data located in Reltio on Power BI, for analytics and reporting matter. Is it possible? How should it be done? Any help is welcomed.

    Thanks in advance!



    ------------------------------
    Alvaro.
    ------------------------------


  • 2.  RE: Export Data located in Reltio to report and analyze on Power BI

    Reltio Employee
    Posted 10-09-2023 10:12

    Hi Alvaro,

    PowerBI would be your presentation layer, but where is the data warehouse?  Is it Snowflake or Google Big Query?  Reltio has connectors that stream the data from Reltio to those warehouses.  If it is an other warehouse, then the Reltio export can be used to build a pipeline between the warehouse and Reltio.



    ------------------------------
    Gino Fortunato
    Senior Solution Engineer
    Reltio
    ------------------------------



  • 3.  RE: Export Data located in Reltio to report and analyze on Power BI

    Reltio Employee
    Posted 10-09-2023 16:35

    I agree with Gino's comments above.

    If you need a quick solution / demo for the proposal, you can export the Reltio data as a CSV file and import it into the Power BI app. However, keep in mind that this would be just for demonstration purposes. This approach will not be scalable.

    As Gino has informed, the customer needs to bring their own data warehouse to integrate with Power BI.  Below is the documenation on the Snowflake and GBQ connectors available today.

    https://docs.reltio.com/en/integrate/export-data-from-reltio-in-bulk/export-data-from-reltio-to-business-intelligence-tools/reltio-snowflake-connector

    https://docs.reltio.com/en/integrate/export-data-from-reltio-in-bulk/export-data-from-reltio-to-business-intelligence-tools/reltio-google-bigquery-gbq-connector



    ------------------------------
    Bryant Barrenechea
    Solution Architect | Professional Services
    ------------------------------



  • 4.  RE: Export Data located in Reltio to report and analyze on Power BI

    Reltio Partner
    Posted 10-13-2023 07:25

    Thank you both Bryant and Gino! 



    ------------------------------
    Alvaro Loureiro
    ------------------------------