topic Re: External DB real time data in Application Development and Automation Discussions

External DB real time data

Former Member — Wed, 02 Mar 2011 05:16:20 GMT

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

Re: External DB real time data

mithun_shetty4 — Wed, 02 Mar 2011 05:23:02 GMT

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.

Re: External DB real time data

Former Member — Wed, 02 Mar 2011 06:27:50 GMT

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

Re: External DB real time data

SuhaSaha — Wed, 02 Mar 2011 06:44:24 GMT


> 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

Re: External DB real time data

Former Member — Wed, 02 Mar 2011 11:22:41 GMT

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

Re: External DB real time data

SuhaSaha — Wed, 02 Mar 2011 11:55:11 GMT

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

Re: External DB real time data

Former Member — Wed, 02 Mar 2011 12:01:19 GMT

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

-Muktar