Hi All,
I don't know if such thing is even possible, but I'm raising this issue to find out if there something that can be done.
It's very frustrating that we can not build OLE DB connection into the TM1's server ( From PowerPivot, QlikView or any other solution ).
I'm using TM1 9.5.1, and as far as I searched in the web I didn't find any solution to connect non IBM software into the TM1 server.
If anyone did it, even through the API ( as an open connection as OLE DB works ), I I would appreciate it very much if he could write instructions how to do this.
Thanks,
Roei
OLE DB Connection
-
tomok
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: OLE DB Connection
No, there is no facility in TM1 to use an OLE DB connection and no hack that I am aware of. If you use the API I suppose it might be possible but then you'd have to custom write everything your TI is doing in API code. Why do you have to use OLE DB? I know it's slightly faster than ODBC but there is nothing connection-wise that would force you to use it. If you can make an OLE DB connection to a source I can guarantee you that you can make an ODBC connection. Some things you just have to accept at face value when you develop in TM1. Your time would be much better spent working on your TM1 model and/or good documentation (the universal thing that is lacking in almost all TM1 implementations I have seeen).
-
lotsaram
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: OLE DB Connection
My interpretation was that the OP wanted to connect TO TM1 as the DB server FROM another BI application using the Applix OLEDB provider ...tomok wrote:No, there is no facility in TM1 to use an OLE DB connection and no hack that I am aware of. If you use the API I suppose it might be possible but then you'd have to custom write everything your TI is doing in API code. Why do you have to use OLE DB? I know it's slightly faster than ODBC but there is nothing connection-wise that would force you to use it. If you can make an OLE DB connection to a source I can guarantee you that you can make an ODBC connection. Some things you just have to accept at face value when you develop in TM1. Your time would be much better spent working on your TM1 model and/or good documentation (the universal thing that is lacking in almost all TM1 implementations I have seeen).
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
roei61
- Posts: 41
- Joined: Wed Aug 22, 2012 5:44 am
- OLAP Product: PAX
- Version: 2.0.7
- Excel Version: 2016
- Location: Israel
Re: OLE DB Connection
First, thanks to you both of the quick answer.
second, Lotsaram you are right, this is exactly what I want to do, but as far as I undersatand the OLEDB provider is providing OLE DB in is not a solution for getting the DB from the TM1.
second, Lotsaram you are right, this is exactly what I want to do, but as far as I undersatand the OLEDB provider is providing OLE DB in is not a solution for getting the DB from the TM1.
-
David Usherwood
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: OLE DB Connection
@roe61, you should be looking for OLE DB for OLAP (ODBO) (http://en.wikipedia.org/wiki/OLE_DB_for_OLAP). TM1 supports ODBO. 'Normal' OLE DB is for relational engines and understands SQL. OLAP engines understand MDX. I've worked with ODBO a long time ago and it wasn't much fun. Unless the frontend vendor has spent some time and effort working with IBM to get it working, I doubt you'll get very far. But there are ETL type tools such as Cubeware's Importer which will move data and structures around, and it's not that hard to roll your own to push content from TM1 to tables or the filesystem for onward use.