Given your extensive investment in Qlik and the need to integrate it with data from Creatio, we recommend using Creatio’s REST API over OData for this integration.
While both options are available, the REST API offers several key advantages:
1) Better performance: REST is more efficient and lightweight, especially when handling large datasets.
2) Greater flexibility: you can define exactly what data is needed and apply filtering or transformations before it's sent to Qlik.
3) While OData comes with various preconfigured options, REST allows you to easily customize the requests
OData can be used for basic, read-only access, but it's generally more rigid and less performant — especially when dealing with high-volume analytics scenarios like yours.
We have heavily invested in Qlik as our BI tool (and have hundreds of users). Our task is to connect finance data with the sales data we have in Creatio. We have an IT team that can set up the connection so I assume they are familiar with connectors like REST API, but would you recommend using ODate over REST API ?
Given your extensive investment in Qlik and the need to integrate it with data from Creatio, we recommend using Creatio’s REST API over OData for this integration.
While both options are available, the REST API offers several key advantages:
1) Better performance: REST is more efficient and lightweight, especially when handling large datasets.
2) Greater flexibility: you can define exactly what data is needed and apply filtering or transformations before it's sent to Qlik.
3) While OData comes with various preconfigured options, REST allows you to easily customize the requests
OData can be used for basic, read-only access, but it's generally more rigid and less performant — especially when dealing with high-volume analytics scenarios like yours.
(I'm not the dev that's going to do this, but ...)
If we create an OData connection with Qlik, are there already some methods in place so that Qlik automatically sees all data and tables in Creatio? Or do we need to build out methods to see specific data?
Or, perhaps it's worth buying a Creatio OData connector that has all this built out already? (If there is such a thing)
Actually, the better question around how the BI (in my case Qlik) works with the data --
When we build out the OData datasource that Qlik will connect to, we need to specify each table that should be "available" to Qlik, true? (There is no "include all tables" I assume.) Ideally, we want all data from all tables, then in Qlik we will do the filtering of which data is needed on each report.
