Onboarding Data from Sage 200

Creating a Sage 200 Source

For creating a Sage 200 source, see $link[page,316784,auto$]. Ensure that the Source Type selected is Sage 200.

To enable OAuth, see $link[page,316784,Enabling OAuth for CDATA Drivers,enabling-oauth-for-cdata-drivers].

Sage 200 Configurations

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

Configuring a Sage 200 Table

For configuring a Sage 200 table, see $link[page,316784,Configuring a Table,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.