External DB real time data

[Former Member]

Hello,

I would like to import data in SAP from an external MS SQL database(DB connection is already setup) on real time basis.

Scenario: 3rd party system dumps data in MS SQL, this data should be imported to SAP with no time gap(real time).

Thanks,

Muktar

[mithun_shetty4]

Write an remotely enabled RFC in SAP and use native SQL statements to pull data.when the legacy system wants to push the data ask them to call ur remote RFC.

[Former Member]

Thanks for the quick response. When SQL sends data using RFC, how do I receive that data and post in SAP?

Do we have any other method to diretly access SQL from SAP ?

Thanks,

Muktar

[SuhaSaha]

>

> Scenario: 3rd party system dumps data in MS SQL, this data should be imported to SAP with no time gap(real time).

I don't approve of this design. You should rather ask the 3rd party application to call a custom RFC (which you need to develope) to post the data directly into R3 tables.

I don't see the point of them posting data into MSSQL & R3 trying to read the data from MSSQL.

Cheers,

Suhas

[Former Member]

I totally agree with you Suhas... but the business wants to have MS SQL as a central system.

Let me give a clear picture of this requirement, my client wants to have a 3rd party time recording system which would connect to MS SQL . AS 400 and SAP will have to read this data from MS SQL. AS 400 runs interface for every 8 mins but in SAP we want to have data immediately. The DB connection and the table field names are available, we will have to access those tables and read the data(MS SQL will not send any data to SAP).

This sounds little complicated, hope someone can help me with this.

Thanks much!

Muktar

[SuhaSaha]

Hello,

Reading data from external DBs is not that complicated Need to use ADBC classes(check the program ADBC_DEMO) to achieve this.

You have to think how to trigger the ABAP code on a real time basis! Discuss with the 3rd party system what are the options they are open to viz., calling an ABAP RFM to schedule a BG job etc.

Hope this is of some help!

BR,

Suhas

[Former Member]

Thanks much Suhas.. Let me try this in test system....

-Muktar