The AccTech Intelligence Connector

With AccTech Enterprise Analytics the intelligence connector for Sage ERP X3, Sage 300 ERP(previously referred to as Accpac) and various related third party solutions are pre-built in the solution. This gives you the ability to have immediate information available from your ERP system for reporting, analysis and dashboards. Some third party solutions such as VIP Payroll and Assetware can also be catered for with the intelligence connector.

The connector is designed in such a way that any type of analysis is possible relating to the information within the ERP or related system or systems residing completely outside the ERP system. Other disparate databases in the organization can be added to the connector to bring the information required for any further analysis from system databases, data warehouses, data marts or any other form of data source.

Any Data in Your Enterprise

MicroStrategy’s next-generation SQL engine provides fast, seamless access to petabytes of data, optimized for all leading database vendors.

Joining Data from Different Sources

MicroStrategy’s MultiSource technology allows users to seamlessly report, analyze, and monitor data across multiple sources through a single business model. Architects can build a build a single multidimensional model spanning multiple data sources including data warehouses, data marts, operational databases, and departmental databases – which is completely transparent to end users.

Web Services

MicroStrategy’s dynamic data access engine is designed to access multi-dimensional databases (MDDBs or MDX sources) such as those from SAP Business Information Warehouse (SAP BW). MicroStrategy’s Dynamic MDX Engine generates optimized MDX syntax that is fully certified with SAP BW using SAP’s high performance BAPI interfaces.

MicroStrategy connects to a range of different database versions and flavours.

MicroStrategy Mobile connects to your existing databases. Read from and write to any database with SQL connectivity, including:

Asterdata

Composite

EXASolution

Gleenplum

Hadoop

HP Neoview

IMB DB2

Infobright

Informix

Kognitio

MS Access

MS Excel

MS SQL Server

MySQL

Netezza

Oracle

ParAccel

PostgreSQL

Red Brick

SAND

Sybase

Teradata

Text Files

Vertica

 

MicroStrategy’s MDX is dynamically generated using the multidimensional models implicit in SAP InfoCubes, QueryCubes, and ODS objects. MicroStrategy can also join data across SAP BW Infocubes QueryCubes and SQL data sources, and simultaneously access multiple MDX instances, including:

  • Microsoft Analysis Services
  • SAP BW / SAP BI
  • Oracle Essbase
  • Hyperion Essbase