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
The lessons in this section relate specifically to connections between BI360 Cloud/version 5 and Microsoft Dynamics GP.
Getting Started & Documentation
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
Solver - Gateway Connector for Microsoft Dynamics GP
Using the Gateway Connector to load GP accounts and data to the Solver Cloud data warehouse
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.
NOTE: This course is based on demo data and does not include any customizations that may be included in the real world process.
- 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 Solver - Gateway Connector for Excel course for additional details.
Posted 11/18, Revised 12/19