Importing Data from a Database
To load datasets coming from databases you can set a connection using the Import from Database task.
Through this task you can create connections to databases in the Custom Source panel: the connections created will become resources in the current Environment.
If the Flow Filter is switched off, you can visualize the database and filesystem connections made not only through the Factory, but also through the Control Tower.
Tables can be imported from the following databases:
IBM DB2 AS400
Azure Synapse Analytics
OpenText Gupta SQLBase
Generic ODBC Connection
Rulex's technical documentation does not and cannot provide comprehensive guidelines on the use of third-party software, beyond how Rulex integrates with this software. Please consult the technical documentation of the third-party software itself for up to date information.
It is now possible to configure Azure Active Directory as the authentication type for this task. After having configured the ODBC drivers and having saved the DNS on your machine, you can easily configure the SQL Server database type by inserting the required information and adding the DNS in the Additional Options panel.
You must have created a flow.
You must have installed the ODBC drivers (64-bit) corresponding to the database you want to import from.
Drag an Import from Database task onto the stage.
Double click on the task.
Select from the drop down list the database type.
Click on the pencil button to add the database path and optional information (only if you are using a Custom source).
Select the tables to import and configure the general options in the table below.
Save and compute the task.
You can decide to import more than one file or folder of files by clicking on the other ones to import while pressing
ctrl on your keyboard.
Choose if you want to use a Saved or a Custom source.
Then, choose the database type from the ones that are listed above.
Unicode is also supported, if its corresponding driver is installed.
Bulk size for prefetch
Retrieves blocks of data of the size specified.
If selected, the search operation will be performed in case sensitive mode.
Select to remove spaces from strings. For example, the string ” age ” is then imported as “age”.
Use old computation data if the source table is not available
Select to use data from the previous computation if the source table is not available.
Repeat query execution every
Select to repeat the query until the required number of records are retrieved (checkdata).
Subsequently set the frequency in seconds (sleeptime) with which the query must be performed and the number of records (nres) that must be retrieved.
The preview of the imported table. You can choose how many rows to display in the Number of records to preview section.
The left-hand list displays all the available attributes, which can be used to filter results. These attributes can be ordered in the corresponding option below to narrow down the list when there are many attributes. It is also possible to search for specific attributes.
Drag and drop the attributes you want to use to filter the imported results onto this pane from the Available Attributes list on the left.
The attribute names in Rulex must perfectly correspond to the attribute names in the resulting query.
Drag and drop the attributes you want to import onto this pane from the Available Attributes list on the left.
If no attributes are specified, all attributes will be imported.