on 08-10-2009 5:14 PM
Hi,
Right now we are calling sql statements in SQL server to connect SAP table data.
We have data in one Ztable , we need to dump that data into sql server with out writing sql statements in sql server.
Because of performance we need to avoid to access sap ztable directly from SQL server.
Is anyone know how to send data from SAP to SQL server?
Thanks
> Because of performance we need to avoid to access sap ztable directly from SQL server.
> Is anyone know how to send data from SAP to SQL server?
You can use:
- RFC
- a webservice
- an ABAP creating a .CSV file that is then be imported
- depending on which database your SAP system runs you could use R3load and/or R3trans
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Marcus,
You can use:
- RFC
- a webservice
- an ABAP creating a .CSV file that is then be imported
- depending on which database your SAP system runs you could use R3load and/or R3trans
How can i use RFC, a web service , .CSV file ???
My external data bse is SQL server...Can you give me sample code for each one please?
Thanks
Silpa
What is you business case?
- one time or permanent data transfer?
- size of the table?
- you need changes in that table?
- you plan to create transactions/reports based on that table
etc. etc. etc.
The "clean" way would be to create the table in SE11 and use transaction LSMW to transfer the data.
It also depends on your skills (ABAP? Java?)
Markus
I asked in my last but one post:
What is you business case?
- one time or permanent data transfer?
- size of the table?
- you need changes in that table?
- you plan to create transactions/reports based on that table
etc. etc. etc.
The "clean" way would be to create the table in SE11 and use transaction LSMW to transfer the data.
It also depends on your skills (ABAP? Java?)
Markus
-- one time or permanent data transfer? Answer : Need to send data every day
- size of the table? -- everyday 500 records
- you need changes in that table?
- you plan to create transactions/reports based on that table
Let me explain my scanario :
I had written one abpa report program to send data to z-table , now we need send from z-table data to sql server.
In sql server we don't want to write any sql statements as its very low performance.
Do you have any idea how to dump z-table data to sql server table.
i would appreciate your help Markus
> -- one time or permanent data transfer? Answer : Need to send data every day
> - size of the table? -- everyday 500 records
> - you need changes in that table?
> - you plan to create transactions/reports based on that table
> I had written one abpa report program to send data to z-table , now we need send from z-table data to sql server.
> In sql server we don't want to write any sql statements as its very low performance.
Well - you will need to "write an SQL statement" in ANY way you choose since you need to read the data. SQL is used to read the data.
> Do you have any idea how to dump z-table data to sql server table.
That "z-table" - is it on a different server? I'm a bit confused - sorry...
Markus
Sorry for bothering again, see i have wrote a code like this but i don't know how to call sql server.
con = '+DBO+0060'. "DB Connection in DBCO above
EXEC SQL.
CONNECT TO :con
ENDEXEC.
WRITE sy-subrc. "---> The result it's 4
EXEC SQL.
GET CONNECTION :con
ENDEXEC.
WRITE : con. "--> The result it's DEFAULT
EXEC SQL.
SET CONNECTION DEFAULT
ENDEXEC.
write : con. "--> The result it's DEFAULT .... Please give me with more details please
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.