Data transfer from SAP R/3 to SQL Server

[Former Member]

How Can I push the data from SAP R/3 system to SQL Server ?

Please suggest me all posiible ways .

[Former Member]

HI,

Just read this: .

Regards,

[Former Member]

You can directly fetch data from SAP to SQL server 2005. There is a new feature available in SQL server 2005.

If you are using lower version then you can use SAP .Net connector as an interface between SAP and SQL Server.

1. Write RFCs in SAP as per your requirement.

2. Create dot net code with SAP .NET connector proxy.

3. Get the data to .NET object.

4. Establise connection from .NET code to SQL server.

5. Push data based on that.

Let me know if you need any clarifications.

Thanks & Regards,

Govind.

[Former Member]

Hi ,

I will explain the scenario. Whenver there is a change in HR master data in SAP R/3 , for example if a new personnel number is added or deleted or if there is a change in cost center , the SQL server should get updated with that data immediately. Can you help me on this.

Best Regards,

Bhagat.

[Former Member]

Hi,

We had the same scenario here also. You can call .NET code from ABAP program using SAP .Net connector.

The data can be downloaded to SQL server based on periodic job wise (every Half an hour or 1 Hour) .

1. Write an ABAP report to get new personnal numbers from HR master tables based on created date.

2. Create a RFC to pass employees details.

3. You can create a proxy in .NET server stub code based on the above RFC.

4. Write code to get data .NET object and establise a connection to SQL server.

5. Write code to push data into SQL server tables.

6. After you complete the .NET code, when you generate this code will create an exe file.

7. You have to execute that exe with few command line arguments.

8. The command line arguments need to setup in RFC destination (SM59).

9. In that ABAP report call this RFC with RFC destination as you defined.

.NET code can be done by .NET person.

Let me know if you have any clarifications.

Thanks & Regards,

Govind.

[Former Member]

Hi Govind,

Thanks a lot for your reply.

Can you elaborate on 3,4,5 and 7th point.

In the 5'th point you suggested me to write code to push data into sql sever tables.

Can you explain how it can be done ??

I will explain my requirement.

Whenever there is a change in HR Master Data like insertion of new personnel number or deletion of personnel number the changes should immediately get reflected SQL Server.

Can it be done programatically ?

Pls suggest me how to go about this ASAP.

Best regards

Bhagat.

[Former Member]

It is not possible to push employees from SAP to SQL server using SAP .NET connector when employee created or deleted.

You can write a report and execute it by every half an hour and find out who are all joined or deleted. Based on this report, these records can be inserted/deleted from SQL server.

Do you have an idea about SAP .NET connector and .NET frame work knowledge?

Thanks & Regards,

Govind.

[Former Member]

Hi Govind,

I don't have knowledge about .Net connector .

Regards

Bhagat.

[Former Member]

Can you get help from .NET person to do this?

Kindly go through SAP .NET connector related documents for your understanding.

Thanks & Regards,

Govind.

[vishwas_kudlinagaraja]

Hi Govindaraju,

Can we have synchronous connection to .Net application through .Net connector which is triggered by SAP (i.e. Abap program sends some data to .Net application and waits for output form it to say success/failure?)

Can you please share some links or documents you have for this?

If synchronous connection is not possible can you please give details of sending and receiving data? (Idocs or flat files or bapis etc....)

If you want any details please reply back,

Thanks in advance,

Vishwas

[Former Member]

hi

good

go through these links

http://www.microsoft.com/technet/itshowcase/content/sql2005sap.mspx

thanks

mrutyun^