The Database Query Transporter data feed allows you to pull data directly from a database by query and insert the data in its raw or manipulated state into a Archer instance.
The numerous types of supported database connections are Odbc, OleDb, Oracle, SQL, and many others. As long as the connection string is configured successfully and the client driver is installed on the system, Archer can integrate regardless of the database type.
A Database Query Transporter data feed can be configured as a standard or transport data feed type.
It is recommended that the external database from which you are capturing data is located within your corporate network and that data transmission occurs over an encrypted communications channel. It is recommended that the credentials you use to retrieve the data have read-only permissions.
Use the following tasks to add a database query data feed:
