Data load editor

The data load script connects an app to a data source and loads data from the data source into the app. When you have loaded the data it is available to the app for analysis. When you want to create, edit and run a data load script you use the data load editor.

A script can be typed manually, or generated automatically. Complex script statements must, at least partially, be entered manually.

The toolbar contains the navigation menu, the global menu and other useful commands.

”	Navigation menu with options App overview, Data manager, Data model viewer and Open hub.
¨	Global menu with options Help and About.
Save	Save the script.
]	Click the info icon to show or hide the app details.
u	Debug the script.
°	Run the script to load data. The app is automatically saved before loading.
h	Open and close the Data connections panel.

App overview

Data model viewer

Adding and managing data with the Data manager

Debug the data load script

Run the script to load data

In Data connections you create and save shortcuts to the data sources (databases or remote files) you commonly use.

Connect to data sources

The text editor is where you edit the script code. Each script line is numbered and the script is color coded by syntax components.

The text editor toolbar contains the following commands:

F	Search and replace text in the script.
…	Comment/uncomment.
À	Indent code.
Ã	Outdent code.
D	Activate syntax help mode. In help mode you can click on a syntax keyword (marked in blue) in the editor to access detailed syntax help.
B	Undo the latest change (multiple step undo is possible).
C	Redo the latest undo.

Edit the data load script

You can divide your script into sections to make it easier to read and maintain. The sections are executed from top to bottom.

P	Create a new script section.
E	Delete a section.

Organizing the script code

Output displays all messages that are generated during data load.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here