Skip to Content
0
Former Member
Mar 19, 2009 at 07:33 AM

Can I connect to SAP database directly with ODBC?

28 Views

I need to read data from SAP and write them into ms sqlserver. I wrote a RFC in SAP and used VB.NET to call RFC. I wonder that the RFC efficency is very slow while reading a great lot data. RFC also cannot support complex condition string, and it cannot fetch my data flexibly.

I found that the user who was included in a user group "db adm" could connect to db2 udb with ODBC in VB6.0 or VB.NET. I also can use the SQL sentence to get data flexibly.

Please tell me whether I can use this user to read (just using select sentense) data from DB2 UDB directly, or whether I can use the newly created user to get data. Will this method cause any problem ?