Solver - Gateway Connector for Microsoft Dynamics GP

Solver - Gateway Connector for Microsoft Dynamics GP

Using the Gateway Connector to load GP accounts and data to the Solver Cloud data warehouse

About this course

In this course Jay Stewart, from the Solver software development team, goes through the process of configuring GP Integration between the  TWO, Inc. on-premise database and the Solver Cloud data warehouse using the BI360 Gateway Connector.   Sample files are also available for download.

Lessons include:

  • Data Warehouse Permissions
  • Data Warehouse Overview
  • Installing  the Gateway Connector and creating a GP data source
  • Preparing a New Tenant Prior to Loading Dimensions and Data
  • Creating SQL Views on the GP Database
  • Dimension Integration: Accounts, Departments, Divisions, and Full-Account String
  • Data Integration: GL Summary and GL Detail - History, Open, and Work Detail

NOTE: Effective with the June 2020 Cloud release, Excel files are supported in the Gateway connector in addition to CSV and SQL. Please view the Excel Connectors course for additional details.

Posted 11/18, Revised 12/19

Curriculum~ 60 minutes

  • Solver - Data Warehouse Overview

    In this section, Toby Prince from the Solver consulting team, introduces the Data Warehouse concepts and components in BI360 Cloud/version 5. 

  • Data Warehouse Permissions
  • Part 1 - Data Warehouse Overview
  • Part 2 - Data Warehouse Concepts
  • Part 3 - Data Warehouse Components
  • Part 4 - Getting Started with Next Steps
  • Gateway Integration

    The lessons in this section relate specifically to connections between BI360 Cloud/version 5 and Microsoft Dynamics GP.

  • Installing the Gateway Connector
  • Preparing a New Tenant
  • Creating SQL Views on a GP Database
  • Dimension Integration: Accounts, Departments, Divisions and Full-Account String
  • Data Integration: GL Summary and GL Detail - History, Open, and Work Detail
  • Quiz - Gateway Connector for Dynamics GP

About this course

In this course Jay Stewart, from the Solver software development team, goes through the process of configuring GP Integration between the  TWO, Inc. on-premise database and the Solver Cloud data warehouse using the BI360 Gateway Connector.   Sample files are also available for download.

Lessons include:

  • Data Warehouse Permissions
  • Data Warehouse Overview
  • Installing  the Gateway Connector and creating a GP data source
  • Preparing a New Tenant Prior to Loading Dimensions and Data
  • Creating SQL Views on the GP Database
  • Dimension Integration: Accounts, Departments, Divisions, and Full-Account String
  • Data Integration: GL Summary and GL Detail - History, Open, and Work Detail

NOTE: Effective with the June 2020 Cloud release, Excel files are supported in the Gateway connector in addition to CSV and SQL. Please view the Excel Connectors course for additional details.

Posted 11/18, Revised 12/19

Curriculum~ 60 minutes

  • Solver - Data Warehouse Overview

    In this section, Toby Prince from the Solver consulting team, introduces the Data Warehouse concepts and components in BI360 Cloud/version 5. 

  • Data Warehouse Permissions
  • Part 1 - Data Warehouse Overview
  • Part 2 - Data Warehouse Concepts
  • Part 3 - Data Warehouse Components
  • Part 4 - Getting Started with Next Steps
  • Gateway Integration

    The lessons in this section relate specifically to connections between BI360 Cloud/version 5 and Microsoft Dynamics GP.

  • Installing the Gateway Connector
  • Preparing a New Tenant
  • Creating SQL Views on a GP Database
  • Dimension Integration: Accounts, Departments, Divisions and Full-Account String
  • Data Integration: GL Summary and GL Detail - History, Open, and Work Detail
  • Quiz - Gateway Connector for Dynamics GP