Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
TauseefKhan
Creator III
Creator III

Streamlining SAP Data Integration with Qlik DataTransfer: A Step-by-Step Guide

Qlik Cloud does not have the direct plugin integration like the SAP Connector in QlikView, but you can still efficiently access SAP data through alternative methods:

To use Qlik DataTransfer with SAP ODBC Drivers and transfer your on-premises SAP data to Qlik Cloud, you'll need to follow these steps:

Step 1: Set up ODBC drivers for SAP on your local system:

  •   You can find detailed instructions on setting up ODBC drivers for SAP on the SAP Help Portal. This includes information on supported remote source databases, the .odbc.ini file, and ODBC driver installation locations.

https://help.sap.com/docs/SAP_HANA_PLATFORM/6b94445c94ae495c83a19646e7c3fd56/98cf2f660b214dbaa5c519f...


Step 2: Install Qlik DataTransfer on a local machine that has access to SAP:

  •   Ensure that your local machine meets the system requirements for Qlik DataTransfer, which include Windows Server 2016 or later, multi-core x64 compatible processors, and at least 8 GB of memory

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/QlikDataTransfer/install...

  •   Download the Qlik DataTransfer.exe file from the Qlik website and follow the installation instructions provided in the Qlik Cloud Help .

    Step 3: Configure Qlik DataTransfer to connect to SAP using the ODBC connection:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/QlikDataTransfer/install...

  •   After installing the Qlik Connector for SAP NetWeaver, copy the necessary connector folders to the Qlik DataTransfer connectors directory and restart the Qlik DataTransfer service

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/QlikDataTransfer/sap-qli...

https://community.qlik.com/t5/Connectivity-Data-Prep/DataTransfer-Connection-to-On-Premise-ODBC/td-p...


Step 4: Schedule regular data uploads from SAP to Qlik Cloud or trigger manual syncs as needed:

  •   Qlik DataTransfer allows you to upload data manually or schedule automatic data uploads to Qlik Cloud

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/QlikDataTransfer/qlik-da...

  •   For scheduling uploads, you can refer to the Qlik Community  for guidance on setting up scheduled uploads for "Data folders".

https://community.qlik.com/t5/Qlik-Cloud-Data-Integration/Scheduled-upload-of-quot-Data-folders-quot...

Remember, it's important to ensure that you have the necessary permissions and roles within your Qlik Cloud tenant to perform these operations. If you need further assistance, the Qlik Community forums are a great place to ask questions and get support from other Qlik users and experts.

Qlik DataTransfer Qlik SAP Connectors Qlik ODBC Connector Package Qlik Cloud 

0 Replies