how to use TM1 solution?
how to use TM1 solution?
Recellently, I will work on a TM1 project, we have identified that the data source is from relational database(operational database), the datasource is very messy. My question is that do we need to create a data warehouse(Data mart) as a data source for TM1 or TI is powerful enough to do the ETL work?
-
Alan Kirk
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: how to use TM1 solution?
TI is, by definition, an ETL tool.Sean wrote:Recellently, I will work on a TM1 project, we have identified that the data source is from relational database(operational database), the datasource is very messy. My question is that do we need to create a data warehouse(Data mart) as a data source for TM1 or TI is powerful enough to do the ETL work?
That having been said, I do recommend that you try to "unmess" the data source first and get as much done on the server side as possible to reduce your load times. I'd be looking at creating views, and using the views (as opposed to direct queries against the tables) as the data source via ODBC. If the relational database is really badly designed (meaning long query times), and you don't need real time interfaces, you may want to even look at doing an export from it to text files, and loading the files.
Cleaning up the database would of course be the optimal solution, but I'm assuming that that isn't an option.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Re: how to use TM1 solution?
Alan Kirk wrote:TI is, by definition, an ETL tool.Sean wrote:Recellently, I will work on a TM1 project, we have identified that the data source is from relational database(operational database), the datasource is very messy. My question is that do we need to create a data warehouse(Data mart) as a data source for TM1 or TI is powerful enough to do the ETL work?
That having been said, I do recommend that you try to "unmess" the data source first and get as much done on the server side as possible to reduce your load times. I'd be looking at creating views, and using the views (as opposed to direct queries against the tables) as the data source via ODBC. If the relational database is really badly designed (meaning long query times), and you don't need real time interfaces, you may want to even look at doing an export from it to text files, and loading the files.
Cleaning up the database would of course be the optimal solution, but I'm assuming that that isn't an option.
Many thanks for your suggestion, it is really helpful.