Insert bulk data to external sql database from SAP(using sybase)

[Former Member]

Hi all,

     We have requirement to transfer bulk of sap table data to external SQL database table on daily basis, kindly suggest the procedure.

[Former Member]

Hello,

An easy procedure would be a manually or report-generated Excel- or csv-file.

Another more sophisticated procedure might be a web service generated from a custom written function module.

Best regards,

Thomas Wagner

[Former Member]

Hi,

Thanks for your response, but report generated Excel uploading will not be that convenient I hope because, our requirement is to pull data from SAP to SQL database on daily basis not once in a while. please suggest some thing with which mentioned requirement can be achieved.

[Former Member]

Well, you could run a program which generates the Excel by batch on a daily Basis, store the file somewhere automatically and import it then.

If you don't like it then the web service option with a custom function module might be good.

Thomas

[RaymondGiuseppi]

Which one(s) have you already considerer ?

• Flat file (from csv to not so flat file as xml) thru FTP or similar tool
• IDoc (if other system accept)
• Web Service (not too big volumn)
• DB connect
• etc.

Regards,

Raymond

[Former Member]

Thanks for your response. Can you elaborate DB Connect method.

[Former Member]

I guess Raymond means ABAP Keyword Documentation

If he doesn't, well that's a good option

[RaymondGiuseppi]

This ADBC - ABAP Database Connectivity  is a tool/an interface to execute SQL statement (OO substitute of native SQL statements), but first you need to actually connect database.

For Information on DB connect, look at DB Connect Architecture and reference note 323151 - Several DB connections with Native SQL. Not that Basis will be required to install some component to access a database type distinct from current one (An other manufacturer, e.g. access MS SQL if SAP running on Oracle)

NB: You could also perform some search on UD Connect (uses Application Server J2EE connectivity)

Regards,

Raymond

[Former Member]

Well, is a tool and using this tool you can archive what the OP ask for, right? I never used DB connect, that's why I said "I guess" and "If he doesn't". Anyway thanks for the clarification

[RaymondGiuseppi]

Just look at class CL_SQL_CONNECTION, this one will get information of table DBCON, so you must have previously define you db connexion. So first use DB connect, then use ADBC or native SQL to access data.

Regards,

Raymond

[Former Member]

Thanks to all three of you.......

Regards,

Neelambika P Battur.