Onboarding Data from Sage 200

Creating a Sage 200 Source

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

To enable OAuth, see Enabling OAuth for CDATA Drivers.

Sage 200 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 200 Table

For configuring a Sage 200 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.

Type to search, ESC to discard
Type to search, ESC to discard
Type to search, ESC to discard
Next to read:
Onboarding Data from Sage 300

For more details, refer to our Knowledge Base and Best Practices!

For help, contact our support team!

© UNIPHORE TECHNOLOGIES 2025 | Confidential

On This Page
Onboarding Data from Sage 200Creating a Sage 200 SourceConfiguring a Sage 200 TableEstablishing a ConnectionData ModelJDBC Connection ParametersSage 200 Configurations