Connection Type reference

This topic gives reference material on the different data source connection Type available, but starts with explaining the distinction between Data Engine and HubCapp connections.

Data Engine and HubCapp connections

Data Engine connections are sources on the same server as the Compliance Engine being used by the Transtream instance. This is why Instance Database and Instance Rest Service are only available under Data Engine.

HubCapp connections are sources accessed through a HubCapp server connection. So they can be anywhere that has a HubCapp Data Agent installed. Hence, all HubCapp connections include settings for the HubCapp server that it will use.

Note

You may have additional connection types available to you that are not covered below. Every connection type only has the settings it requires.

Instance Database

The Transtream instance's Compliance Engine database. This will be Logistics Server. An instance's Compliance Engine is set in Transtream Setup. As this will exist, the connection is made as soon as Type is set.

Instance Rest Service

Transtream REST end point in the instance database.

Microsoft SQL Server

Microsoft SQL Server instance. Server Name is the SQL Server instance. Once connected to the instance, you can select the database.

MySQL

MySQL database instance.

.NET Connector

A .NET application connector created to provide connectivity with a third party data source. Such connectors must be created using the toolkit provided by Pierbridge.

Composer 6

This was known as a PDE Connector in the previous version.

Microsoft Excel

Microsoft Excel file. File is the path to the spreadsheet, for example C:\MyData\DayBook.xlsx. Once connected, tables equate to named sheets in the spreadsheet. Note that only xlsx file formats are supported.

OData

An OData end point.

Url

A URL. There is no test connection.

Article last edited 2 October 2020