Database connect

This tool helps in configuring certain settings in the databases (like selecting Datasource, adding SQL statement etc) without the use of scripting. It is only available if you have licensed the Database module.

Drag and drop the Database Connect to the workspace.

Keywords

If you enter one of the following keywords in the Search field at the top of the Flow elements pane, the Database Connect element will be shown in the list:

SQL
database
metadata
xml
export
select
insert
update
delete

Connections

Database Connect needs at least one incoming connection.

Property

Property	Description
Name	Provide a name for the flow element. This name is displayed in the workspace.
Description	A description of the flow element displayed in the canvas. This description is also shown in the tooltip that appears when moving your cursor over the flow element
Select data source	Select a data source from the list of predefined data sources. Note: If the list is empty, you should first set up a data source. Refer to the ODBC data sources option in the User preferences dialog (See Setting up an ODBC database connection).
SQL statement	Specify SQL statements using any one of the following three options: Edit multi-line text Define multi-line text with variables Define script expression Note: Please pay special attention when using other variables and make sure that the result of the multi-line text is a valid SQL statement.
Log name	Specify the name of the log where the result of the statement should be written by using one of the following three options: Inline value Define single-line text with variables Define script expression
Binary data in opaque dataset	If the result of the SELECT statement returns binary data (for example: video form), select Yes. Otherwise, select No and configure the subordinate properties.
Log type	Only available if Binary data in opaque dataset is set to No. Format of the log (where the result of the statement will be written). Options: CSV XML
Encode binary data	Only available if Binary data in opaque dataset is set to No. Defines the way binary data is converted. Encode with Base64: default Keep as is: Use this option if the ODBC driver returns binary table fields. This is for example the case when you're using FileMaker in combination with Switch. Note: Be careful with this option; it may lead to a corrupted logfile.

At present there is no SQL editor available. Therefore, copying statements generated by the variables, multi line text with variables, database group and build SQL statement dialog box may result in errors.

Note: Refer this site for an SQL Tutorial.