SQL External
External SQL performs a pure import. Unlike an import performed through the task Query, import via External SQL does not automatically identify the name of the columns and their type (String, Int, Float, etc.), and it is up to the user to provide this information.
The main advantage of this task is the ability to execute complex queries in the syntax of the source database, allowing the user to take advantage of existing work, or specific functionalities present in other technologies such as: functions, procedures, and triggers.
Release
To be able to import through the External SQL task, the source registration must have the flag "Allow to execute pure SQL in the source".
Before clicking save, you need to re-enter your Data Source username and password.
See more in Management > Sources
Settings
Give the task a name (optional)
Choose the data source
Insert the query
Check to enable import
Insertion mode: **
Give the import result table a name
Add the desired number of columns
Specify the type of columns
Enter the name of the columns (necessarily needs to be the same as the data source)
Maximize the screen
Save and run the task.
Last updated
