Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlik SAP Connector: Cannot load data from SAP in production database


Hi Team,

I'm facing issues in extracting data from SAP using Qlik SAP Conenctor in Production Database.
When I use the connection string to connect the DEV database my script loads the data WITHOUT PROBLEMS as you can see bellow. It closes automatically the window or enable the button [Close].

close.JPG

However, after changing the connection string to production database loads all data from the tables that I want but the load window don´t close or enable the button[Close]. The button [End Here] is still enabled and never stops.

Before this problem I couldn't even load a field from the database, the load script was starting but wasn't showing anything being load in the window. I discovered later that it was an access object right in SAP blocking.
After checking the access to these objects I started to extract data from SAP Production. I'm able now to extract data from MSEG from begin till the end in SAP Production.
However, in the script above it loads the data but does not finish. I'm waitng since one hour.
Can be an access right issue? What are the accesses required to use the SAP SQL Conenctor?
Could it be time-out issues?

Thank you in advance for any help in this.

Regards,


Catarina

0 Replies