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
Showing results for 
Search instead for 
Did you mean: 

SQL connectivity from ABAP

Former Member
0 Kudos
498

Dear team,

In our enterprise, we are developing web applications using .NET framework with SQL server as a back-end. And also, we are in SAP ECC 6.0 for our ERP functionalities.

We develop some front-end applications in .NET and for the same, data fetching & updation will be happened at SAP ECC via RFC methodology.

Now, we have a plan to eliminate this RFC concept & switch over to other concepts to achieve the same.

Can we access SQL tables from SAP and vice-versa without an RFC? Is it possible to call BAPI directly from .NET visual studio environment to update values in SAP?

If the above mentioned queries are answerable, please provide the solution at the earliest. We also would like to know whether the recommended solution is practicable?

Thanks in advance.

Regards,

Nellaiappan N.P.

7 REPLIES 7

Former Member
0 Kudos
114

Hi Nellaiappan ,

Can we access SQL tables from SAP and vice-versa without an RFC?

A:  To Access SAP to SQL there is an ODBC conector that you sould install in SAP.  Here is an example


From SQL to SAP I think you can't, even if your SAP Database is SQL Server, or you shouldn't do that!


Is it possible to call BAPI directly from .NET visual studio environment to update values in SAP?

A: BAPI uses the RFC Protocol.


New concepts for this would be implement SAP Netweaver Gateway and create your own OData Services and you can do operations for CREATE, READ, UPDATE, DELETE. Because they are REST Services. This means that not only you can do .NET applications also Android, and IOS Apps, Web etc.. using the same services.


Another concept is to use Replication SLT of specific tables to your SQL Database.

I hope it helps.

Kind Regards,

Cesar

0 Kudos
114

Hi Cesar,

Thanks a lot for your valuable information shared with us.

I have a doubt that do I require any separate license for the same though ECC is being used.

Thanks & Regards,

Nellaiappan N.P.

0 Kudos
114

Hi Nellaiappan,

You need to talk to a SAP Partner in your region for the different concepts like SLT Replication.

For the SAP NW Gateway or SAP Fiori is Free License.

SAP Netweaver Gateway Licensing | SCN

Kind Regards,

César

note: please reward points if usefull.

rosenberg_eitan
Active Contributor
0 Kudos
114

Hi,

From SAP you can also use package SDB_ADBC clases

Have a look at

The program is using package SDB_ADBC clases

DATA: ob_sql_connection     TYPE REF TO cl_sql_connection .
DATA: ob_sql_statement      TYPE REF TO cl_sql_statement .
DATA: ob_sql_result_set     TYPE REF TO cl_sql_result_set .
DATA: ob_sql_exception      TYPE REF TO cx_sql_exception .

Note: I use this program mainly for testing purpose .

Also look at program ADBC_QUERY .

Regards .

0 Kudos
114

Dear Ceaser,

  Through ODBC connection you can connect the server.

Regards,

Balamurugan

0 Kudos
114

Balamurugan,

Of Course check first answer for Nellaiappan.

Connecting to External Database from SAP

Regards,

Cesar

0 Kudos
114

Dear Cesar,

My SAP server is running on Unix OS, in such case whether it is possible to connect external database from SAP via DBCO tansaction settings.

Regards,

Nellaiappan N.P.