Thanks Erland for your answer. Could you please explain the difference of this two frameworks ODBC and OLE DB. They are different, just like Windows and Macintosh are different. Both serve the same purpose, but the APIs work very differently. ODBC is limited to true database sources, whereas there are OLE DB providers for non-relational sources like text files or Active Directory. ![]() When I installed the ODBC driver for Oracle the installation created a provider also. Why is TeraData different on this? You will have to ask Teradata about that. Erland Sommarskog, SQL Server MVP, [email protected]. SELECT * FROM OPENROWSET('MSDASQL','10.0.0.0';'user';'pass', 'select from tbl') That is not going to work out. You must specify the ODBC driver, so you need to use the form with the provider string: SELECT * FROM OPENROWSET('MSDASQL','Driver=Teradata;Server=thatserver;User=username;Password=pwd') But of course the exact syntax, including the driver name, depends on the Teradata ODBC driver, of which I am completely unfamiliar. Www.connectionstrings.com may be of help. Erland Sommarskog, SQL Server MVP, [email protected]. A variety of open source projects have been integrated, tested and combined as part of the Hortonworks Data Platform (HDP). The platform components comprising the Hortonworks Data Platform (HDP) are released under the Apache 2.0 License. HDP is also commonly used with 3rd-Party Components (ex. The latest software available for download here is Teradata Warehouse Miner 05.04.04 Express Edition.This is a complete version of the Teradata Warehouse Miner product set, without an evaluation time limit, however, it is limited in use to up to 40 GB of 'connected' data. Download the SSIS Connectors v3.0 for Oracle and Teradata that provide additional value for SQL Server Integration Services (SSIS) 2014. Oracle’s JDK – Java Platform) and Optional Add-Ons (ex. Hive ODBC Driver). When you choose to use those components, it is recommended you read and understand the licensing terms specific to each of those components.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2018
Categories |