(Optional - if using Eclipse)Teradata Plug-in for Eclipse
Many of these components can be found in the Teradata Developer's Exchange Downloads section. Starting with Teradata 12 they have reset the version numbers in an attempt to address the confusion with the different development life cycles of each component contained within their Tools and Utilities. Tools for Teradata 13.x should be compatible with Teradata 12 and Teradata 14. However, certain features specific to a given database release may not be available unless you are using a version of the client that is equal to or greater than the database version.
For ETL Development, then you will be relying upon the BTEQ, FastLoad, FastExport, MultiLoad combined with the Teradata CLI to connect to Teradata.
If you are working on new database and ( if you have license to use ), you can have a look at Teradata parallel transporter. It provides extract-load capabilities with configurable scripts.
发布评论
评论(3)
最终用户/开发人员从每个环境提交临时查询的典型基本工具集:
Windows (TTU 13.10 客户端安装 - 400MB)
Linux/UNIX/Mac OS X
其中许多组件可以在 Teradata Developer 的 Exchange 下载 部分找到。从 Teradata 12 开始,他们重置了版本号,试图解决其工具和实用程序中包含的每个组件的不同开发生命周期带来的混乱。 Teradata 13.x 的工具应与 Teradata 12 和 Teradata 14 兼容。但是,除非您使用的客户端版本等于或高于数据库版本,否则特定于给定数据库版本的某些功能可能不可用。
对于 ETL 开发,您将依靠 BTEQ、FastLoad、FastExport、MultiLoad 与 Teradata CLI 相结合来连接到 Teradata。
Typical base toolset for end users/developers submitting ad hoc queries from each environment:
Windows (TTU 13.10 Client Install - 400MB)
Linux/UNIX/Mac OS X
Many of these components can be found in the Teradata Developer's Exchange Downloads section. Starting with Teradata 12 they have reset the version numbers in an attempt to address the confusion with the different development life cycles of each component contained within their Tools and Utilities. Tools for Teradata 13.x should be compatible with Teradata 12 and Teradata 14. However, certain features specific to a given database release may not be available unless you are using a version of the client that is equal to or greater than the database version.
For ETL Development, then you will be relying upon the BTEQ, FastLoad, FastExport, MultiLoad combined with the Teradata CLI to connect to Teradata.
此答案仅适用于Windows。
要针对 Teradata 数据库运行查询,您需要以下各项:
要了解您的系统是否有 Teradata ODBC 驱动程序,请转至“控制面板”、“管理工具”->“管理工具”。数据源->添加并查看 Teradata 是否已列出。
下面的示例屏幕截图:
This answer is for Windows only.
To run queries against a Teradata database, you need the following:
To know, if your system has Teradata ODBC Driver, goto Control Panel, Administrative Tools -> Data Sources -> Add and see if Teradata is listed.
Sample screenshot below:
如果您正在开发新数据库并且(如果您有使用许可),您可以查看 Teradata 并行传输器。它通过可配置脚本提供提取加载功能。
If you are working on new database and ( if you have license to use ), you can have a look at Teradata parallel transporter. It provides extract-load capabilities with configurable scripts.