SQL connectivity from ABAP

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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]

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 .

[former_member544616]

Dear Ceaser,

  Through ODBC connection you can connect the server.

Regards,

Balamurugan

[Former Member]

Balamurugan,

Of Course check first answer for Nellaiappan.

Connecting to External Database from SAP

Regards,

Cesar

[Former Member]

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.