How to Call Teradata Stored Procedure In TM1
-
SRao
- Posts: 2
- Joined: Wed Sep 18, 2013 7:47 am
- OLAP Product: Cognos TM1
- Version: 10.2
- Excel Version: 2010
How to Call Teradata Stored Procedure In TM1
Hello Team, We have to call the Teradata Stored Procedure in TI. Can you please let me know it will support for same in TI or not. If 'Yes' Please let me know process for calling the Stored Procedure.
-
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: How to Call Teradata Stored Procedure In TM1
Calling a stored procedure for any database in a TI process is done the same way as running SELECT query. You simply specify the text command need invoke the stored procedure in the "Query" box in the Data Source tab of your TI process. As long as you have the Teradata drivers installed on your TM1 server, a DSN pointing to your Teradata server, and valid security credentials in the boxes in TI then then the stored procedure will run.