| Author |
Message
|
| next |
 Posted: Wed Dec 14, 2011 4:29 am Post subject: Connecting to teradata from WMB |
 |
|
Voyager
Joined: 02 May 2010
Posts: 75
|
Hi,
We have a requirement to connect to Teradata view and read records from there.
I see we dont have the ODBC drivers to connect to teradata in WMB. Learnt we should use JDBC type 4 connection to connect.
We have installed Teradata client on the WMB server.
Could anyone kindly share your thoughts if you had similar experience?
Thanks,
Suresh. |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Wed Dec 14, 2011 5:25 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
|
| Back to top |
|
|
| kotagiriaashish |
| Posted: Wed Dec 14, 2011 6:24 am Post subject: |
|
|
Disciple
Joined: 06 Aug 2011
Posts: 165
|
I d suggest you connect using a Java program first... and then switch to the Broker later.... so that you will have a clear view of the details and Jars...im just sayin..  |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Dec 14, 2011 6:31 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| kotagiriaashish wrote: |
| I d suggest you connect using a Java program first... and then switch to the Broker later.... so that you will have a clear view of the details and Jars...im just sayin.. |
Except that this leads to the temptation to configure the JDBC configurable service incorrectly. |
|
| Back to top |
|
|
| kotagiriaashish |
| Posted: Wed Dec 14, 2011 6:40 am Post subject: |
|
|
Disciple
Joined: 06 Aug 2011
Posts: 165
|
| mqjeff wrote: |
| kotagiriaashish wrote: |
| I d suggest you connect using a Java program first... and then switch to the Broker later.... so that you will have a clear view of the details and Jars...im just sayin.. |
Except that this leads to the temptation to configure the JDBC configurable service incorrectly. |
 Really? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Dec 14, 2011 6:43 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| kotagiriaashish wrote: |
| mqjeff wrote: |
| kotagiriaashish wrote: |
| I d suggest you connect using a Java program first... and then switch to the Broker later.... so that you will have a clear view of the details and Jars...im just sayin.. |
Except that this leads to the temptation to configure the JDBC configurable service incorrectly. |
Really? |
Yes. Because you immediately want to put the fully qualfiied connection URL string into the connectionURLFormat, instead of leaving it alone or making sure that it is a valid pattern.
At least, this is the only reason I can figure that this is the most common problem with jdbc configurable services. That either the broker admin has copy/pasted from a working config, or been told "this is the string to use" without knowing anything about JDBC. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Dec 14, 2011 6:53 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
Except that this leads to the temptation to configure the JDBC configurable service incorrectly.
Really? |
Really. Have a look through the number of posts we've had in here for JDBC problems which have been directly attributible to using the URL as a string not a pattern.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| kotagiriaashish |
| Posted: Wed Dec 14, 2011 7:10 am Post subject: |
|
|
Disciple
Joined: 06 Aug 2011
Posts: 165
|
I Went through the same Problem once... |
|
| Back to top |
|
|
|
|
