Call a BAPI In SAP BI from MS SQL

[Former Member]

BI Experts,

Can you call a BAPI in SAP BI using a SQL Code in MS SQL?

Thanks

Ashwin

[Former Member · Accepted solution]

Hi,

not really....

but what should this bapi do? is it to transfer data? or just to start some process in BI without data exchange?

let us know...

Olivier.

[Former Member · Accepted solution]

It is to transfer data.

[Former Member · Accepted solution]

You should probably use the Microsoft .NET provider for SAP inside a .NET stored procedure (SQLServer 2005) or Microsoft Biztalk Server.

As Olivier said more details would be useful.

[Former Member]

Well What I am trying to to is pull data from BI into a SQL Server. the load and teh data set selection should be intiated from there. I know there is a bapi BAPI_ODSO_READ_DATA_UC which can read data from and ODS. But can i call this with a SQL statement, pass selection parameters to BI and pull data?