QLIK SAP SQL Connector

[Alexander_Austria]

I am new to Qlik Sense. My company recently bought Qlik SAP SQL Connector and we were able to successfully install it and use it on  a number of developed apps. However we want to expand its use and make it a common data source for all Qlik apps requiring data from SAP. We also want to destress the HANA database from excessive connector adhoc query and connection. We are thinking of creating an app that will run in background as a scheduled job. This scheduled background executed app will have script program lines that will establish the connection to SAP production server, fetch the SAP table data and save these on QVD files. Here are some questions I want to know if possible:

1. Is it possible to execute the SAP SQL connection thru the SQL connector as a script program on an app that will be scheduled and executed in background? Is there a sample script that will show how to script the connection stream and how to pass the necessary connector parameters?

2. Can an app be scheduled as a background job and be triggered on non busy time like when there are no manufacturing shifts?

[fosuzuki]

Hi,

Your questions aren't really exclusive to SAP, you can search for general tutorials and trainings regarding data loading and task scheduling.

For data loading, you can check this one: https://www.youtube.com/watch?v=JjtiujIaURg

And for scheduling: https://www.youtube.com/watch?v=smCXRprs-YU

[Alexander_Austria]

Hi Fosuzuki,

Thank you for your reply regarding exploring tutorials on data loading and task scheduling. Thank you for your video suggestions. Although the data loading video is not in English. 

The one thing I'm really desperate to have answer on is if its possible for the SAP SQL connector log-in connection to be programmatically scripted in an app that will be executed as a scheduled job without manual intervention. The end to end solution should not have somebody manually keying in the login parameters in the pop-up screen during the app execution. 

[fosuzuki · Accepted solution]

Hello Alexander,

yes, one of Qlik Sense's core concepts is to be able to automate the ETL, including connecting to the database (SAP or any other) and reading the data.

There are mainly 3 steps:

1. Create data connection to SAP, defining the connection parameters

2. Add SQL queries into app script

3. Schedule a reload task in the server

Oh, by the way, you're using Qlik Sense Desktop or one of the server editions? On Desktop you can't.

[Alexander_Austria]

My company has the server edition.

Thank you and appreciate so much your reply specially when you had it enumerated in steps.