The data load script connects an app to a data source and loads data from the data source into the app.
This section gives you examples on how to create apps, connect to data sources, create your data load script, and load your data in the app.
Create apps
Apps can be created from an empty structure, by copying an existing app or by importing an app.
This section provides you with examples of how you can create apps, migrate apps, delete apps, and list the apps.
Objects in an app can be replaced by other ones. An example on how to replace an app is also given.
Connect to data sources
Data connections provide a way to save shortcuts to the data sources you commonly use: databases, local files or remote files.
The following types of connections exist:
- ODBC database connections.
- OLEDB database connections.
- Folder connections that define a path for local or network file folders.
- Internet connections used to select data from files located on a web URL.
- Custom connections.
Custom developed connectors for data sources are not directly supported by Qlik Sense. Custom connectors are developed using the QVX SDK or supplied by Qlik or third-party developers.
This section provides you with examples on how to create a connection, update a connection, and list the connections.
View the data to load
This section provides you with examples on how to view the data from your data sources before loading them.
Edit the data load script
The script must be written using the Qlik Sense script syntax. There are a number of script functions that are available.
This section provides you with examples on how to create a script, and add some breakpoints in the script. Examples on how to list the Qlik Sense script functions and the breakpoints are also provided.
Load data
You can run the script in order to load data in your app. You can get the progress of the load process and cancel the loading if necessary.
This section provides you with examples on how to run the data load script, get the progress of the script or cancel the loading (if for example, it takes too much time).