Saltar al contenido principal

Domo University Videos

Domo

Connecting to Sage 300 Data in Domo

Important: When referencing this page outside of Knowledge Base, use this link: http://knowledge.domo.com?cid=sage300

Sage 300 (formally Timberline) uses a database that is accessed via a Sage ODBC driver. To connect to Sage data, you must use SQL to query and process the data via Workbench, which then sends it to Domo.

You can access Sage 300 by doing either of the following:

  • Connecting directly to the database using the ODBC driver (which has been reported as slow). You can learn more about the ODBC connector in Workbench here: Connecting to ODBC data.

  • Using a product called Anterra Data Center, which basically copies the Sage data over to a SQL-based database. You can then connect to that database using Workbench. Most users prefer Anterra, as it is provides a much faster means of accessing Sage data.

To get access to the Sage 300 ODBC driver, contact your Sage rep. To use the Anterra Data Center method instead, you can reach out to Anterra here:  http://www.constructionsa.com/anterra-datacenter.html