SQL Connector

Configuration of new SQL Connector

Datasource

The JDBC Driver of the supported database: MySQL, Sybase, Oracle, PostgreSQL, SQLite, HANA, Microsoft SQL, IBM DB2 and IBM DB2 for AS-400 systems.

Connection-String

The connection string specifies information about a data source and the means of connecting to it. It is generated automatically, depending on your previous selections.

Result Type

The result type is a Monadic type holding a returned value or an error code. Choose between Multiple Results (e.g. Array), Single Result and No Result.

The Result Type is deprecated. For new Connectors, the Result Type is fixed to ‘Mulitple Results’ and cannot be changed. The same applies to all Connectors theirs result type is already ‘Multiple Results’.

When you deactivate the feature in the ‘New Features‘ settings, the result type ‘Mulitple Results’ will be used for all SQL Connectors. Please check your Connectors. To get a list of all Connectors that use other result types than ‘Mulitple Results’, press the ‘Show usage’ button in the ‘New Features‘ settings.

As soon as we delete the result type, all Connectors will use the result type ‘Multiple Results’.

f you have created an SQL connector with the SQLite data source, files are created for a special directory for SQLite data files. The connector creates an SQLite database on the Simplifier server in the connector properties if it’s not available. When changing the connector, a backup of the file is created.

Attention: Deleting the connector also deletes the data file.

Take a look at the SQL Connector Calls.