Data visualization has become the de facto standard for modern business intelligence. The successes of the three leading vendors in the BI space, Power BI, Tableau and Qlik, which heavily emphasize visualization, has moved other vendors toward a more visual approach in their software. Virtually all BI software has strong data visualization functionality.

TMVGate Version 2.0.1 is a purpose-built gateway and a cost-effective solution. It allows you to unlock your data in TM1 and Planning Analytics to the world of data visualization and advance data analytics.

Driven with an open format design concept, TMVGate is capable of bridging TM1 and Planning Analytics data to market leading visualization tools such as Power BI, Tableau, Qlikview, Qlik Sense, Power Query, Power View, SSRS, MicroStrategy, R Studio and many more.

With a lightweight server based architecture, TMVGate does not require any software or driver on the client workstation, making it ideal for widespread deployment.

TMVGate returns Cube view (private or public) and Dimension Hierarchies data in real time streaming in either the JSON, XML, HTML or CSV (TXT or Pipe) format via a simple HTTP or HTTPS call.
The various data streaming formats have been validated with the visualization tools mentioned, without the need for any additional scripting.

The cost-effective TMVGate has helped customers in Australia, New Zealand, US, UK, Canada, Germany to deliver dashboards and visual rich reports.
Customers were impressed with the extreme ease of implementation with existing TM1 and Planning Analytics cubes and hierarchies. It just works out of the box!

I don't think I will want to compare Cognos BI and the rest of the tools such as Tableau, Qlikview, QlikSense. There is a reason why Tableau and Qlik is well accepted in the Analyics and Visualization market segment.

You can download a non-commercial version of Qlikview and Qliksense to do some evaluation on your own. For Tableau, you can download a trial copy.

For those currently using Excel 2013, you can explore using Power Query, Power View, Power Pivot which is a powerful Analytics/Visualization tools and it is free. Microsoft PowerBI is another new free tools that you can tap to.

All these tools work well with our gateway.

Now back to the gateway product, it is developed to bridge TM1 data to an open data format which is well accepted by these Visualization products. With these open data format, you are no longer bound by specific drivers or Reporting/Analytics/BI/Visualization products.

As this is developed specifically for TM1, yes you do need a valid TM1 license. To be specific, as we are using TM1 API, existing TM1 named user license is sufficient and you do not need to purchase additional licenses.

The gateway can be further extended to act as a server to server interface bridge and a sample setup is provided for such requirements.

Security is based on existing CAM or TM1 security.
We have also tested it with TM1 Cloud and you can have the option to install the gateway on premise and access TM1 on the cloud.
This will provide customers who are using cloud with another option instead of TM1Web and Cafe.

For those who are interested with our TM1 Gateway product, we have some good news!

We have just added the capability to retrieve dimension hierarchy with TMVGate. This new release of TMVGate is able to extract balance and ragged dimension structure in TM1 with the various fill gap options.

With the release of Planning Analytics 2.0 in mid-December 2016, we are glad to announce that our TM1 (or PA) Gateway products support the new Planning Analytics.
Please contact us at info@itlink.com.sg for product enquiry.

New Update for May 2017:
We have successfully tested our gateway with CData JSON ODBC driver. With this integration, customer now have a choice to utilize any products/tools with ODBC to consume TM1 cube data via our gateway.
To expand it even further, we managed to link up two remote TM1 servers using TI with ODBC driver. TM1 data replication or exchange can now be done in real time; scheduled or adhoc.
We will be releasing a new release in Jun/Jul which support MDX query which is required for PA Multiple Hierarchy support. Stay tuned.

We have just released TMVGate version 2.0 which officially support PA 2.0 virtual hierarchies. Along with the new release comes with other enhancement such as caching, standalone URL generator, MDX support.

Microsoft power BI is the leader in analytics and BI platform based on latest Gartner report.
Contact us to learn more about how you can leverage both Power BI and TM1/Planning Analytics to advance your businesses using this leading analytics technology with a lower TCO.