All Forums UDA
sweet_melody 10 posts Joined 07/09
17 Aug 2009
Oracle Reports connectiing to TERADATA

hi, i just wanted to know if it is possible for the Oracle Report builder to connect to Teradata. That means that the data to retrive by the Oracle Report will be from Teradata. Please tell me if it is possible. Thank you.If not, what are other tools that can be used? Thanks

datawarehousing 3 posts Joined 08/09
19 Aug 2009

To know more about your solution,then consult us asap,bcoz we are into it for more than 3 years.Thanks and regardsData warehousing

sweet_melody 10 posts Joined 07/09
28 Aug 2009

Hi, thanks for the reply.We have lots of oracle reports now but it is currently getting data from the Oracle Database. Since we have now the Teradata Datawarehouse, I wanted to know how I can connect the Oracle Reports Designer to Teradata, so i can get data to Teradata.Is it using the ODBC? How is it?

larry200 3 posts Joined 08/09
28 Aug 2009

Are you using Oracle BI tool? If yes, then you can connect to Teradata using ODBC connection.

sweet_melody 10 posts Joined 07/09
28 Aug 2009

Thanks.No it is not an Oracle BI Tool. It is (Oracle Report Builder) a reporting tool of Oracle. I think for Oracle BI Tool using ODBC will be just the same with the ORacle Report Builder. Can u help me please on how to set it up. - What are needed?- What are to modify?- What are to install?Thank You

datawarehousing 3 posts Joined 08/09
31 Aug 2009

Hi, I have been involved in the for more than 3 years,if u like to consult us,its a pleasure to help,we have got great technical experience in our ranks.

datawarehousing 3 posts Joined 08/09
31 Aug 2009

Data Warehousing is a big ocean,if u like to be a pro in data warehousing visit

Vador 36 posts Joined 08/07
03 Sep 2009

Did you tried to make a link between Oracle and Teradata by using Oracle Transparant gatway thru ODBC ?Then you are enable to map Teradata table in an Oracle instance and then, map the oracle report on linked tables.However, be carefull, by doing this, Oracle will retrieve the entire data from the linked table (teradata), this may be a big issue.

ramubindu 10 posts Joined 06/08
22 Jun 2010

i want to connect from oracle to teradata without useing oledb tool because i have some problem so can you please give me with example how to connect from oracle to teradata
because it is very importent to solve the problem within 7 hours time.

can you please help me
Thanks
Ram

CarlosAL 512 posts Joined 04/08
23 Jun 2010

You may take a look here:

http://carlosal.wordpress.com/2009/06/18/heterogeneous-services-sql-a-teradata-desde-oracle/

HTH

Cheers.

carlos.

ramubindu 10 posts Joined 06/08
23 Jun 2010

Hi Carlos,

i am not able to understand language which you have given the link so can you please proved the english language.
Thanks
Ram

CarlosAL 512 posts Joined 04/08
23 Jun 2010

It's spanish.

http://translate.google.com/

Cheers.

carlos.

Adeel Chaudhry 773 posts Joined 04/08
23 Jun 2010

@datawarehousing: Am sure you have been working with DWH for good 3 years, please don't flood the forum with similar messages no where near to a solution of a raised problem!

@CarlosAL: Nice link :)

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.