Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Send/receive a huge amount of data with Web services or better .net connector?

Former Member

‎06-28-2012 2:50 PM

0 Kudos

Hi,

we have an interface between SQL Server and SAP, which is sending and reading data via files.

Now we wanted to change that to a direct connection via .Net Connector or Web Services.

The data volume, we are talking about, could be easily 8 mio. of records per table.

I have written a c# application, which is using the .net connector to call a bapi and each call is of course running very long.

So i thought to split the data in 10000 line-packages, or something like that.

what do you think about using web services instead?

Please let me know your suggestions!

Thank you very much!

Michael

1 REPLY 1

manuelhildemaro_ramossanc
Active Participant

‎07-17-2012 7:45 PM

0 Kudos

Hi Michael.

Did you try with native SQL ? Take a look to the program "ADBC_DEMO".

Check this link

Note 178949 - MSSQL: Database MultiConnect with EXEC SQL

Regards,

Manuel H.