Database connections

Connections stores properties like Server name, User/Password etc. necessary to connect to a given database.

Connectors to ERP/CRM and Databases

*A connection can be referenced from multiple Components and user/password can include parameters.

In SQL statements the keyword USING [<<my db connection>>] defines what database to access for a given SQL statement.

*Retrieving external metadata to a file that is being transferred to SharePoint.
The bind-variable [<File name>] is automatically populated for each file being processed.
SELECT my_metadata FROM mytable
WHERE my_filename = [<File name>] USING [<<my ms sql>>]

See this example on how to copy data from database to database