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

Advertisements, add-ons and other commercial information
Post Reply
kangkc
Community Contributor
Posts: 166
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1
Version: 9.x
Excel Version: 200x
Location: Singapore

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

Post by kangkc » Wed Sep 02, 2015 3:19 am

Introduce a TM1 (PA) gateway product TMVGate which is capable of bridging TM1 data to market leading visualization tools such as Qlikview, Qlik Sense, Microsoft Power BI, Power Query, Power View, Tableau 10, SSRS, MicroStrategy and many more.

TMVGate returns Cube view (private or public) data in real time streaming in either JSON, XML, HTML or CSV (TXT or Pipe) format via a simple HTTP or HTTPS call. The data stream can be readily consumed by the visualization and BI tools with minimum setup effort. Refreshing of data from these tools happened in real time.

User do not need to install any driver or software at the client workstation which make it a true zero footprint implementation.

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

Email: info@itlinkbiz.com

In the Email please state whether you are an end user who is interested with the product or a reseller/consultant who is keen to resell the product.

You can view the video on YouTube demonstrating the gateway in action with the mentioned BI Tools:

https://www.youtube.com/channel/UC95AcZ ... MfWDCIWbWw

New Update for Oct 2017:
We have released version 2.0 which officially support PA 2.0.x multiple hierarchies. Along with version 2.0 are new enhancements such as caching, standalone URL generator, MDX support.
We have also validated MicroStrategy Desktop version 10 (Free) which works with TMVGate out of the box.

If you have an existing BI/Visualization tools and would like to explore bridging to TM1 or PA, feel free to contact us for further exploration.
Last edited by kangkc on Tue Oct 10, 2017 1:29 am, edited 11 times in total.

harrytm1
Regular Participant
Posts: 225
Joined: Thu Apr 02, 2009 2:51 pm
OLAP Product: TM1, PA, CX, Controller
Version: Latest version
Excel Version: 2003 to 2016

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

Post by harrytm1 » Thu Sep 03, 2015 1:56 am

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?
TM1 Version 9.4.1 to latest version

kangkc
Community Contributor
Posts: 166
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1
Version: 9.x
Excel Version: 200x
Location: Singapore

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

Post by kangkc » Thu Sep 03, 2015 7:11 am

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.

kangkc
Community Contributor
Posts: 166
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1
Version: 9.x
Excel Version: 200x
Location: Singapore

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

Post by kangkc » Wed Oct 14, 2015 6:27 am

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.

ambrus
Posts: 10
Joined: Thu Nov 19, 2009 1:13 pm
OLAP Product: Manny's TM1
Version: 10.2.2
Excel Version: 2010
Contact:

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

Post by ambrus » Wed Oct 14, 2015 6:23 pm

This looks great! How do you plan to deal with security though?
Rest API addict, creator of http://cubeac.com || Blog http://cubeac.com/blog/

kangkc
Community Contributor
Posts: 166
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1
Version: 9.x
Excel Version: 200x
Location: Singapore

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

Post by kangkc » Thu Oct 15, 2015 1:07 am

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.

ambrus
Posts: 10
Joined: Thu Nov 19, 2009 1:13 pm
OLAP Product: Manny's TM1
Version: 10.2.2
Excel Version: 2010
Contact:

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

Post by ambrus » Thu Oct 15, 2015 1:54 pm

So the credentials are passed and that's used to execute the view / request on TM1?
Rest API addict, creator of http://cubeac.com || Blog http://cubeac.com/blog/

kangkc
Community Contributor
Posts: 166
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1
Version: 9.x
Excel Version: 200x
Location: Singapore

TM1 Gateway for Tableau, Qlik, PowerBI and BI tools

Post by kangkc » Thu Oct 15, 2015 3:34 pm

Yes.

kangkc
Community Contributor
Posts: 166
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1
Version: 9.x
Excel Version: 200x
Location: Singapore

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

Post by kangkc » Mon Jan 04, 2016 5:30 am

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.

kangkc
Community Contributor
Posts: 166
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1
Version: 9.x
Excel Version: 200x
Location: Singapore

Re: TM1 Gateway now support Power BI Drill down

Post by kangkc » Tue Aug 09, 2016 1:53 am

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

kangkc
Community Contributor
Posts: 166
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1
Version: 9.x
Excel Version: 200x
Location: Singapore

Re: TM1 Gateway support SSRS

Post by kangkc » Wed Aug 10, 2016 7:34 am

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

kangkc
Community Contributor
Posts: 166
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1
Version: 9.x
Excel Version: 200x
Location: Singapore

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

Post by kangkc » Thu Sep 29, 2016 6:53 am

Check out our new Power BI Dashboard demo (done in 15 mins) with TM1 Gateway

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

kangkc
Community Contributor
Posts: 166
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1
Version: 9.x
Excel Version: 200x
Location: Singapore

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

Post by kangkc » Wed Feb 22, 2017 1:09 am

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.

kangkc
Community Contributor
Posts: 166
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1
Version: 9.x
Excel Version: 200x
Location: Singapore

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

Post by kangkc » Tue May 23, 2017 3:36 am

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.

kangkc
Community Contributor
Posts: 166
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1
Version: 9.x
Excel Version: 200x
Location: Singapore

TM1 (PA) Gateway for Power BI using Natural Query

Post by kangkc » Wed Aug 16, 2017 8:18 am

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.

kangkc
Community Contributor
Posts: 166
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1
Version: 9.x
Excel Version: 200x
Location: Singapore

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

Post by kangkc » Tue Oct 10, 2017 1:33 am

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

Post Reply