Integration with Databases
It is required to perform several preparatory actions to start the work with data from any database.
Step 1. Connection Creation
First, it is required to create corresponding Connection to work with the database to be connected with.
Step 2. Creation of the Connection Node in the Workflow
It is required to place the created connection into the workflow; for this purpose you are to create the node the output data of which will be parameters of connection with the data source.
The following actions are required to create the node:
- Open the workflow to be edited and expand the Connections panel that includes a list of all connections created in the package.
- Select the required connection in the panel and use one of the specified methods clicking on the right mouse button to open its context menu (refer to Figure 1):
Add reference to connection into Workflow — Reference node (1) for connection will be added to the workflow. It is also possible to create the reference node using the Drag-and-drop function by dragging the required connection to the area of the workflow creation.
Add Connection node to Workflow — derived node (2) inherited from the selected connection will be added to the workflow. The derived node will have the same settings as the selected connection. However, it is possible to redefine them using the Node Wizard (in this case, settings of the connection from which the node has been inherited will not be changed).- Go to connection — go to the window with the available connections.
Parameters of connection to the data source are used by the data import/export nodes. For this purpose, 
port data of the connection node are to be sent to the 
input port for which such connection of the import/export node is required (refer to Figure 2).
Step 3. Import Node Configuration
Separate Import from database node is used to receive data from the database. It allows for import of the database table or results of execution of the SQL query set by the user and view.