OLEDB
OLEDB ("Object Linking and Embedding Database") is supported as a universal technology for connecting to all database systems and other systems that provide a corresponding driver.
The name of the provider depends on the specific system. The other parameters may also vary in name. The following is therefore only an example of the main parameters for a connection to Microsoft SQL Server.
Key | Description |
|---|---|
Provider* | Value |
Data Source* | Name or IP address of the database server The name or IP address can be supplemented by an instance name separated by a |
Initial Catalog* | Name of the database |
User ID(*) Password(*) | User name and password for authentication |
Integrated Security | Value |
Specify the database command in standard SQL syntax. You can generally use a SELECT statement for this. Depending on the macro function, the provider also supports other SQL commands.