topic Re: Insert bulk data to external sql database from SAP(using sybase) in Application Development and Automation Discussions

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

Former Member — Tue, 02 Dec 2014 13:38:20 GMT

Hi all,

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

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

Former Member — Tue, 02 Dec 2014 14:29:52 GMT

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

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

RaymondGiuseppi — Tue, 02 Dec 2014 14:36:38 GMT

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

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

Former Member — Tue, 02 Dec 2014 17:09:12 GMT

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.

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

Former Member — Tue, 02 Dec 2014 17:27:01 GMT

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

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

Former Member — Tue, 02 Dec 2014 20:08:43 GMT

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

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

Former Member — Wed, 03 Dec 2014 09:43:23 GMT

I guess Raymond means ABAP Keyword Documentation

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

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

RaymondGiuseppi — Wed, 03 Dec 2014 13:55:59 GMT

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

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

Former Member — Wed, 03 Dec 2014 14:17:36 GMT

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

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

RaymondGiuseppi — Wed, 03 Dec 2014 15:43:50 GMT

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

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

Former Member — Thu, 11 Dec 2014 04:31:58 GMT

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

Regards,

Neelambika P Battur.