-
>
>
TMVGateThe lightweight gateway bridging TM1 & Business Intelligence Tools
Current Situation
Many Planning Analytics/TM1 users currently use Excel spreadsheets for reporting and financial analysis. However, companies worldwide are transitioning to business intelligence tools such as PowerBI, Tableau and Qlik.
Problem
Planning Analytics/TM1 users have to find ways of loading data stored in Planning Analytics/TM1 into these business intelligence tools. This is presently done inefficiently by ‘manually’ exporting data from Planning Analytics/TM1 and importing them into these tools. The process can be tedious, time-consuming and resource-intensive.
Our Solution
TMVGate is a high performance Planning Analytics/TM1 gateway which transforms both Public and Private Cube Views into real time HTTP/HTTPS data feed. It is lightweight, easy-to-implement and has a strong support team to address any queries and concerns.
Demonstration of ease-of-use
Key Benefits of TMVGate
Works with TM1 Local & on Cloud
Supports all Security Modes 1 to 5
Efficiently supports large Cube Views (>500mb)
No need for ODBC/Additional Data Warehouse Layer
Real Time
- Provides Real-Time connectivity
Fast
- Lightweight implementation using HTTP/HTTPS protocol
Open Architecture
- Adopt Open Architecture supported by many BI or Visualization tools.
Offline Mode
- Supports offline mode in BI Visualization tools. Data can be refreshed as and when required.
Hear what our customers have to say
TMVGate is a quick, efficient & relatively easy solution that helped us to pull quality, structured data from Planning Analytics(powered by TM1) into Power BI. I would highly recommend it.
Jay and the team were there to help throughout the whole process and dealt with queries in a quick and professional manner, no matter how big or small the task.
- Cormac Roddy, Finance Systems Manager at Brewin Dolphin
Some of our TMVGate clients
Supports multi-format data
TMVGate lets users extract Planning Analytics/TM1 Cube View data easily via a simple HTTP request with selectable output formats such as TEXT, JSON and XML. These formats are well supported with Tableau ®, Qlik ®, Microsoft Power BI, Microsoft Power Query and Power View and other visualization tools that support Web API.
Remote users who rely on remote desktop solution now have an option to access Cube data, offline and with real time refresh, from their own desktop. Meanwhile, existing Planning Analytics/TM1 data security is preserved based on user’s credentials provided in the HTTP request.
