Details about this thread
  • State Verified Answer
  • Replies 4 replies
  • Subscribers 308 subscribers
  • Views 1027 views
  • Users 0 members are here
Related content from around SugarClub

SQL read only access on Sugar Sell

Omar Conte

Hi,

my question here comes from a particular need.

We use a BI tool to analyse data from CRM. With the on-prem version we created SQL views on the db, and were extracting data with an ETL tool, towards the data warehouse system.

With Sell we understood we need to use API calls.

This is generating a lot of calls and taking long time to complete, since we have to extract all records from more than 15 modules.

So my question is if there is a possibility to connect in read only mode to the db to extract the data faster, or if you guys have any other suggestion for us.

Calling dedicate reports with API doesn't work since:

1. we only get data of the main module, not the related ones (true or not?)

2. we get labels of items and not keys (true or not?)

3. we cannot connect to Advanced Reports (true or not?)

Thanks for your feedback.

Omar

Parents
  • 0

    hi

    I work on site so our DWH does direct DB queries to pull incremental updates, but I was thinking about your question and how I would get around the lack of direct DB access.

    Have you considered a push instead of a pull? I assume you could call your own APIs from Sugar.

    You could create one or more custom Schedulers that retrieve the records that changed since the last run, and pushes them to your warehouse.

    Again, I am not familiar with the Cloud environment for Sugar, so maybe these are not viable solutions for you, I just thought I'd offer some ideas.


    Francesca

Reply
  • 0

    hi

    I work on site so our DWH does direct DB queries to pull incremental updates, but I was thinking about your question and how I would get around the lack of direct DB access.

    Have you considered a push instead of a pull? I assume you could call your own APIs from Sugar.

    You could create one or more custom Schedulers that retrieve the records that changed since the last run, and pushes them to your warehouse.

    Again, I am not familiar with the Cloud environment for Sugar, so maybe these are not viable solutions for you, I just thought I'd offer some ideas.


    Francesca

Children