Solver - Gateway Connector for SAP Business One SQL

Solver - Gateway Connector for SAP Business One SQL

Mapping and configuring the SAP Business One (B1) 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 SAP Business One (B1) SQL 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:   

  • Data Warehouse Permissions
  • SAP B1 SQL Introduction
  • Creating SQL views using SQL Server Management Studio (SSMS)
  • Defining a Solver > SAP B1 SQL Integration for Account-based dimensions
  • Defining a Solver > SAP B1 SQL Integration for the General Ledger module

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

Posted 3/19, Revised 12/19

Curriculum~ 40 minutes

  • Data Warehouse Permissions
  • Overview and Documentation
  • SQL Create Views - Dimensions part 1
  • SQL Create Views - Dimensions part 2
  • SQL Create Views - Factsets
  • Installing the Gateway Connector
  • Solver Data Warehouse Integration - Dimensions part 1
  • Solver Data Warehouse Integration - Dimensions part 2
  • Solver Data Warehouse Integration - Module
  • Quiz - Gateway Connector for SAP Business One SQL

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 SAP Business One (B1) SQL 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:   

  • Data Warehouse Permissions
  • SAP B1 SQL Introduction
  • Creating SQL views using SQL Server Management Studio (SSMS)
  • Defining a Solver > SAP B1 SQL Integration for Account-based dimensions
  • Defining a Solver > SAP B1 SQL Integration for the General Ledger module

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

Posted 3/19, Revised 12/19

Curriculum~ 40 minutes

  • Data Warehouse Permissions
  • Overview and Documentation
  • SQL Create Views - Dimensions part 1
  • SQL Create Views - Dimensions part 2
  • SQL Create Views - Factsets
  • Installing the Gateway Connector
  • Solver Data Warehouse Integration - Dimensions part 1
  • Solver Data Warehouse Integration - Dimensions part 2
  • Solver Data Warehouse Integration - Module
  • Quiz - Gateway Connector for SAP Business One SQL