BI360 Cloud - Gateway Connector for Sage X3

BI360 Cloud - Gateway Connector for Sage X3

Mapping and configuring the Sage X3 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 BI360 view scripts and configuring the Sage X3 integration using the Gateway connector. If you have not already done so, we suggest you view the BI360 Cloud - Data Warehouse Overview  to become familiar with the Data Warehouse and terminology. 

The following topics are included:   

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

Posted 4/19

Curriculum~ 60 minutes

  • Overview and Documentation
  • Working with SQL View Scripts
  • Create View Scripts - Dimensions Part 1
  • Create View Scripts - Dimensions Part 2
  • Create View Scripts - Factset
  • Installing the Gateway Connector
  • BI360 Data Warehouse Integration - Dimensions part 1
  • BI360 Data Warehouse Integration - Dimensions part 2
  • BI360 Data Warehouse Integration - Module part 1
  • BI360 Data Warehouse Integration - Module part 2

About this course

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

The following topics are included:   

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

Posted 4/19

Curriculum~ 60 minutes

  • Overview and Documentation
  • Working with SQL View Scripts
  • Create View Scripts - Dimensions Part 1
  • Create View Scripts - Dimensions Part 2
  • Create View Scripts - Factset
  • Installing the Gateway Connector
  • BI360 Data Warehouse Integration - Dimensions part 1
  • BI360 Data Warehouse Integration - Dimensions part 2
  • BI360 Data Warehouse Integration - Module part 1
  • BI360 Data Warehouse Integration - Module part 2