topic Re: SQL connectivity from ABAP in Application Development and Automation Discussions

SQL connectivity from ABAP

Former Member — Wed, 07 Oct 2015 12:42:25 GMT

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.

Re: SQL connectivity from ABAP

Former Member — Wed, 07 Oct 2015 13:02:30 GMT

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

Re: SQL connectivity from ABAP

Former Member — Thu, 08 Oct 2015 05:15:40 GMT

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.

Re: SQL connectivity from ABAP

rosenberg_eitan — Thu, 08 Oct 2015 06:24:06 GMT

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 .

Re: SQL connectivity from ABAP

Former Member — Thu, 08 Oct 2015 11:58:15 GMT

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.

Re: SQL connectivity from ABAP

former_member544616 — Thu, 08 Oct 2015 12:28:15 GMT

Dear Ceaser,

Through ODBC connection you can connect the server.

Regards,

Balamurugan

Re: SQL connectivity from ABAP

Former Member — Thu, 08 Oct 2015 12:32:48 GMT

Balamurugan,

Of Course check first answer for Nellaiappan.

Connecting to External Database from SAP

Regards,

Cesar

Re: SQL connectivity from ABAP

Former Member — Fri, 23 Oct 2015 06:16:01 GMT

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.