Page 1 of 2

TM1 Gateway for Power BI, Tableau, MicroStrategy, R, Qlik

Posted: Wed Sep 02, 2015 3:19 am
by kangkc
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!

For a quick TMVGate 2.0.1 demo, you can watch our presentation YouTube video at
https://www.youtube.com/watch?v=CpyTFFYEE1U

For demos on the various visualization tools with TMVGate, you can check out our YouTube Channel which has a comprehensive list of demos with various tools.
https://www.youtube.com/channel/UC95AcZ ... fWDCIWbWw

Please send us an email if you like to find out more regarding TMVGate 2.0.1 at

Email: info@itlink.com.sg

Re: New Product : TM1 Gateway - Visualize your TM1 data with market leading Visualization and BI tools

Posted: Thu Sep 03, 2015 1:56 am
by harrytm1
Sounds good! A question though. Does it mean that the customer will then need to purchase TM1, a BI software e.g. Qlikview and TM1 Gateway (your 3rd party tool)?

Apologies for not understanding this product well. What is the advantage of this set-up versus having a combination of TM1 and Cognos BI?

Re: New Product : TM1 Gateway - Visualize your TM1 data with market leading Visualization and BI tools

Posted: Thu Sep 03, 2015 7:11 am
by kangkc
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.

Do contact us if you need more information.

Re: New Product : TM1 Gateway - Visualize your TM1 data with market leading Visualization and BI tools

Posted: Wed Oct 14, 2015 6:27 am
by kangkc
Hi All,
An update to all who are interested with the TM1 Gateway. It is out of beta and we have officially released the product.
Please send your inquiry to info@itlinkbiz.com

BTW, We will be commencing a testing using the gateway with SAP BO BI with a customer soon.

Re: New Product : TM1 Gateway - Visualize your TM1 data with market leading Visualization and BI tools

Posted: Wed Oct 14, 2015 6:23 pm
by ambrus
This looks great! How do you plan to deal with security though?

Re: New Product : TM1 Gateway - Visualize your TM1 data with market leading Visualization and BI tools

Posted: Thu Oct 15, 2015 1:07 am
by kangkc
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.

Re: New Product : TM1 Gateway - Visualize your TM1 data with market leading Visualization and BI tools

Posted: Thu Oct 15, 2015 1:54 pm
by ambrus
So the credentials are passed and that's used to execute the view / request on TM1?

TM1 Gateway for Tableau, Qlik, PowerBI and BI tools

Posted: Thu Oct 15, 2015 3:34 pm
by kangkc
Yes.

Re: TM1 Gateway for Tableau, Qlik, PowerBI and BI tools

Posted: Mon Jan 04, 2016 5:30 am
by kangkc
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.

Please contact info@itlinkbiz.com for more details.

Re: TM1 Gateway now support Power BI Drill down

Posted: Tue Aug 09, 2016 1:53 am
by kangkc
We have just added the capability of drill down with our TM1 Gateway in Power BI using the In-line Hierarchy which is currently a Preview features in Power BI.
You can see it in action at

https://www.youtube.com/watch?v=I4fb57rpuBs

Re: TM1 Gateway support SSRS

Posted: Wed Aug 10, 2016 7:34 am
by kangkc
We have just validated the support for SQL Reporting Services (SSRS) with our TM1 Gateway.

See it in action on Youtube:

https://youtu.be/cDjpXU0M-ak

Re: TM1 Gateway for Power BI, Tableau, Qlik, SSRS and BI tools now support TM1 Dimension Hierarchy

Posted: Thu Sep 29, 2016 6:53 am
by kangkc
Check out our new Power BI Dashboard demo (done in 15 mins) with TM1 Gateway

https://www.youtube.com/watch?v=pi7-6UcxA4s

Re: TM1 (PA) Gateway for Power BI, Tableau, Qlik and BI tools now support Planning Analytics 2.0

Posted: Wed Feb 22, 2017 1:09 am
by kangkc
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.

Re: TM1 (PA) Gateway for Power BI, Tableau, Qlik and BI tools now support Planning Analytics 2.0

Posted: Tue May 23, 2017 3:36 am
by kangkc
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.

TM1 (PA) Gateway for Power BI using Natural Query

Posted: Wed Aug 16, 2017 8:18 am
by kangkc
We just uploaded a new business case of using TM1 (PA) gateway with Power BI natural query to analyze TM1 (PA) data using plain English.
See the demo youtube video:

https://youtu.be/LYuj-pFYBxM

Please contact us at info@itlink.com.sg for product enquiry.

Re: TM1 (PA) Gateway for Power BI, Tableau, MicroStrategy, Qlik

Posted: Tue Oct 10, 2017 1:33 am
by kangkc
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.

Please send us an email if you want to enquire about the product.

Email: info@itlinkbiz.com

Re: TM1 Gateway for Power BI, Tableau, MicroStrategy, R, Qlik

Posted: Mon Nov 06, 2017 4:35 am
by kangkc
Nov Update:
Validated R Studio integration with TMVGate

https://www.youtube.com/watch?v=428-zDU ... e=youtu.be

Re: TM1 Gateway for Power BI, Tableau, MicroStrategy, R, Qlik

Posted: Mon Dec 04, 2017 9:06 am
by kangkc
We have just released TMVGate Version 2.0.1

https://www.youtube.com/watch?v=CpyTFFYEE1U&t=8s

Re: TM1 Gateway for Power BI, Tableau, MicroStrategy, R, Qlik

Posted: Tue Feb 06, 2018 1:03 am
by kangkc
We have just released Version 2.1.0.

Highlights of the new release:

- New Cache Engine with more dynamic cache control
- Scalability and performance improvement to balance server resources and large data set request that goes beyond tens/hundreds of millions

Please send us an email for details about the product.

Email: info@itlinkbiz.com

Re: TM1 Gateway for Power BI, Tableau, MicroStrategy, R, Qlik

Posted: Wed Mar 28, 2018 1:04 am
by kangkc
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.

https://powerbi.microsoft.com/en-us/blo ... ive-years/