The AccTech Intelligence Connector
With AccTech Enterprise Analytics the intelligence connector for Sage ERP X3, Sage 300cloud 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