I'm working with SAP / Informix and I want to be able to open an external informix database to get some data and process them in SAP with Native SQL.
Use ABAP EXEC SQL, to make the connection to your SQL database, and grab the information that way. To set this up will require working with your SAP Basis team to give SAP appropriate rights to your database. There are notes on what to do in OSS. Search for keyword DBCON in OSS.
Dig deeper on SAP Basis administration and NetWeaver administration
Related Q&A from Matthew Billingham
An SAP user needs information on how to change the password on several SAP user accounts from a central location.continue reading
An SAP user is trying to run a report in an SAP ALV Grid online and wants to know how to get the data in the report to appear along with the header.continue reading
An SAP user needs to transfer customer purchase order spreadsheet data to SAP VA01 to create a new sales order.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.