Infoworks 6.1.3
Onboard Data
Additional Connectors

Onboarding Data from Sage 50 UK

Creating a Sage 50 UK Source

For creating a Sage 50 UK source, see Configuring Additional Connectors. Ensure that the Source Type selected is Sage 50 UK.

Sage 50 UK Configurations

FieldDescription
Fetch Data UsingThe mechanism through which Infoworks fetches data from the database.
Connection URLThe connection URL through which Infoworks connects to the database.
UsernameThe username for the connection to the database.
PasswordThe password for the username provided.
Source SchemaThe schema in the database to be crawled. The schema value is case sensitive.

Once the settings are saved, you can test the connection.

Configuring a Sage 50 UK Table

For configuring a Sage 50 UK table, see Configuring a Table.

Establishing a Connection

To create a JDBC URL, see Establishing a Connection.

Data Model

The tables and views supported by the source are described in the Data Model.

JDBC Connection Parameters

For the list of JDBC connection parameters, see Connection Parameters.