Hello community,
We are now considering our internal data warehouse construction for reporting purposes and needing a capability to export large amounts of data from Creatio in a fully automated way.
Is there an option to connect directly to Creatio db using some ETL tools like MS SSIS or Azure Data Factory?
If no, what type of API could be recommended for such a purpose? Are there some recommendations or best practices based on vendor's or partners' experience?
Like
Hello,
colleagues from Creatio, could you please, share your thoghts?
We use Starfish for this (Starfish ETL | Creatio Marketplace) as there is not direct way other then the API to get data out. I have asked many times to be able to Sync the DB directly, but there is no Option. Starfish works well
Hello,
Currently, you have two options accessing the DB:
1) Using marketplace apps like Starfish
2) Writing direct SQL commands in your code
https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platfor…