Export data real-time from SAP Design Studio Dashboard to SQL Server?

[MustafaBensan]

Is there a way to export data from a dashboard to a SQL Server real-time?
Planning application only allows me to send data to SAP BW and not to other data sources.
I have thought about using ABAP DataBase Connector or DB Multiconnect but I can't execute them through the dashboard.

[MustafaBensan]

Such functionality is not supported in Design Studio. Can you explain your business use case for exporting to SQL Server from Design Studio?

[Former Member]

My usecase is basically storing selected values from design studio dashboard to SQL server for audit purposes.

[MustafaBensan · Accepted solution]

Hi Ankit,

I would recommend that you carefully evaluate the true business value of such a use case because implementing it will result in a high complexity, high maintenance solution. If you must implement it then a straw man approach could be as follows:

1. Create the SDK component as a Technical Component;

2. Define properties to connect the component to OData services for updating a backend SQL Server database;

3. Define a script API to allow the application to interact with the SDK component and pass values to be updated to the SQL Server database.

Regards,

Mustafa.

[Former Member · Accepted solution]

Hi Mustafa,

Thanks for giving me a solution.

Regards,

Ankit

[MustafaBensan · Accepted solution]

No problems. I’ll be interested to know how you go.

Regards,

Mustafa.