import data from SAP CRM to SQL server

[Former Member]

Hi Data guys.

We have a lot fo reporting going on and for now we import the data as excel and update the dashboards

we want to make this process automated

so we are looking into option to import data from SAP CRM to on premise SQL server

the end result is the sql server get refreshed every hour with the SAP data

how can i achieve this