Is it possible to export the SAC data to MS SQL server

[former_member935833]

I want to send the data from SAC to MS SQL server. I need to schedule the export of a report from SAC to .CSV file format by using a dynamic filter option. I got to know that dynamic filter is available only for Story (and not in model). So I need to know if it is possible to export the SAC story to .CSV file format.

[avsalynin]

anish.mb

you cannot export the whole story to csv, only tables.

But you can set up uploading to several data sources (list below), including to a file from the data management workspace in models.

Available export options:

1. OData Service
2. Model data as file
3. SAP BPC
4. SAP IBP
5. SAP S/4HANA (ACDOCP)

Export data (SAC)

[former_member935833]

Hi Aleksey,

Thank you for your response.

Could you also please let me know if there is any other way to schedule the export of SAC data to MS SQL server with dynamic filter.

Regards,

Anish