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.

If 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.