Solver - Gateway Connector for Sage 500

Solver - Gateway Connector for Sage 500

Mapping and configuring the Sage 500 Gateway connector/integration to load financial dimensions and GL data

About this course

In this course, Jay Stewart from the Solver software development team, goes through the process of installing the Solver view scripts and configuring the Sage 500 integration using the Gateway connector. If you have not already done so, we suggest you view the Solver - Data Warehouse Overview  to become familiar with the Data Warehouse and terminology. 

The following topics are included:   

  • Sage 500 SQL Introduction
  • Creating SQL views using SQL Server Management Studio (SSMS)
  • Defining a Solver > Sage 500 SQL Integration for Account-based dimensions
  • Defining a Solver > Sage 500 SQL Integration for the General Ledger module

Posted 3/19, Revised 12/19

Curriculum~ 50 minutes

  • Overview and Documentation
  • Working with the Sage 500 Structure
  • Create View Scripts
  • Modifying View Scripts
  • Installing the Gateway Connector
  • Solver Data Warehouse Integration - Dimensions part 1
  • Solver Data Warehouse Integration - Dimensions part 2
  • Solver Data Warehouse Dimension Review
  • Solver Data Warehouse Integration - Module

About this course

In this course, Jay Stewart from the Solver software development team, goes through the process of installing the Solver view scripts and configuring the Sage 500 integration using the Gateway connector. If you have not already done so, we suggest you view the Solver - Data Warehouse Overview  to become familiar with the Data Warehouse and terminology. 

The following topics are included:   

  • Sage 500 SQL Introduction
  • Creating SQL views using SQL Server Management Studio (SSMS)
  • Defining a Solver > Sage 500 SQL Integration for Account-based dimensions
  • Defining a Solver > Sage 500 SQL Integration for the General Ledger module

Posted 3/19, Revised 12/19

Curriculum~ 50 minutes

  • Overview and Documentation
  • Working with the Sage 500 Structure
  • Create View Scripts
  • Modifying View Scripts
  • Installing the Gateway Connector
  • Solver Data Warehouse Integration - Dimensions part 1
  • Solver Data Warehouse Integration - Dimensions part 2
  • Solver Data Warehouse Dimension Review
  • Solver Data Warehouse Integration - Module