SQL read only access on Sugar Sell

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