Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is it possible to connect SAP R3 tables without SAP connector?

Hello everybody,

I'd like to be able to connect to Oracle SAP R3 tables and I need to know if I can do it without the need of a SAP connector.

It is just for accessing tables/views using a normal ODBC connection.

Many thanks for your reply.

João

9 Replies
suniljain
Master
Master

Yes,

You can extract data from SAP R/3 Without SAP Connector.

Lars_Wahlstedt
Employee
Employee

Hi,

in most cases you are breaking the license agreement with SAP if you use ODBC. It is also not possible to download Cluster and Pool tables, like for example BSEG.

Regards, Lars Wahlstedt

suniljain
Master
Master

Without ODBC, SAP Connector you can also extract data from SAP R/3.

I alredy know some client who implemented this scenario.

Not applicable
Author

Hi:

Please more details about this.

I have a customer with SAP 4.6c.

Thanks in advance.

César.

suniljain
Master
Master

Dear Cesar,

Process is like this

1) Write abap program which create csv file of sap table.

2) Same that CSV file in common location between SAP server and Qlikview Server

3) Qlikview can load that csv in application or you can save QVD of that data.

I know some SAP customer who implemented this scenario and it work fine for them.

still if you have any query pls reply me.

Not applicable
Author

Right!!. How i was thought in BI SAP Business Warahouse...complicate my life

But,

1. Program ABAP Extractor.

2. Run in Background in programmed way ( for day o for hours ).

3. Save in shared directory in server.

next, execute Qlikview scripts .

Well, is clear.

Thanks very much Sunil.

suniljain
Master
Master

Dear Ceasar,

Process is same like SAP QV Connector. But in this case you can save cost.

Not applicable
Author

Sunil jain's advice is correct. instead of connecting to sap over and over you can store the selected table(s) in a qvd file and load those fields from the qvd files to qlikview. if you have changes on those tables(e.g updated some fields or added new data) you can use incremental load so that you don't have to load all the data all over again instead you will load only those modified data or new data. with this process the extraction of data from SAP is faster.

suniljain
Master
Master

Dear Mongkz,

You are absolutely true. Otherwise to manage complex data warehouse is not possible.

Regards

Sunil Jain