How to Extract SAP Table data using SSIS Into SQL

Question

question

rajeshwar.baddam asked Jun 28, '18

How to Extract SAP Table data using SSIS Into SQL

Dear Experts

Am using SSIS tool toconnect the SAP Systemusing SAP BW OLEDB Provider which connected successfully, am would liketouse this connection assourceto write a select query toget the SAP tabledatalike below

SELECT T001.BUKRS from T001

can any tells me what issql script toget the datafor T001 table

Thanks

RAj

ssis

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WRBI commented · Jun 29, 2018 at 07:44 AM

I've never queried SAP before for data, however, I did find this article (although it's part of BizTalk documentation I believe it still applies). It looks like the basic SQL syntax is the same. If a basic SELECT statement isn't working is it returning an error?

0 ·

Answer 1 · 2018-06-29T13:35:53Z

rajeshwar.baddam answered Jun 29, '18

Hi WRBI

The SELECT statement is not the same as we do generally with the SAP, i have already mentioned Original statement that is not working .

Thanks

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WRBI commented · Jul 02, 2018 at 10:23 AM

As I say I've never worked with querying SAP, just trying to help if I can.

Looks like I didn't include the link last time to the article. So, here's the link:

https://docs.microsoft.com/en-us/biztalk/adapters-and-accelerators/adapter-sap/syntax-for-a-select-statement-in-sap

However, in the article they appear to be querying the same table you are and they don't use a table alias on the start of the columns. Maybe drop the alias (I bet you've already tried that though!)

SELECT BUKRS from T001

-- Where as you've posted...
SELECT T001.BUKRS from T001

0 ·

Answer 2 · 2018-07-02T15:28:30Z

rajeshwar.baddam answered Jul 2, '18

I tried all the general statement as you mentioned but that wont work , i think you don't know about the SAP security layer and data browsing in R3 that works with predefined structured model like RFC method, am looking for SAP expert advise who already worked on it, not google browser, if you don't know don't advise for coments.

SELECT BUKRS from T001

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WRBI commented · Jul 03, 2018 at 08:54 AM

I said that I didn't know about SAP and that I was just trying to help however I could, so there's no need to be rude. You clearly don't appreciate someone trying to help you. Hope you find what you're looking for, have a good day.

0 ·

Answer 3 · 2018-07-18T21:31:27Z

rajeshwar.baddam answered Jul 18, '18

Am looking for EKPO SQL query like how it was written the below post....

http://agilebi.com/jjames/2011/05/25/how-to-extract-sap-data-in-ssis/

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question