通过JDBC连接到Talend中的OpenEdge [英] Connecting via JDBC to OpenEdge in Talend

问题描述

在"Talend数据集成"中，我想使用JDBC创建到Progress OpenEdge数据库的连接.我对这种连接没有任何经验.

In "Talend Data Integration" I want to create a connection using JDBC to a Progress OpenEdge database. I have no experience whatsoever with this type of connection.

我到相同资源的ODBC连接工作正常，但是Talend需要JDBC连接才能正常运行.

My ODBC-connections to the same resources work fine, but Talend requires a JDBC connection to function properly.

我目前在Talend中的连接设置为:

The connection settings in Talend I have at the moment are:

• 数据库类型:常规JDBC
• JDBC URL:jdbc:sqlserver://db-name:port; databaseName = * *
• 驱动程序罐:??? (OpenEdge需要哪个jar文件?)
• 类名称:??? (OpenEdge我需要哪个类名?)
• 用户名: *
• 密码: *
• 模式:??? (不知道这意味着什么??)
• 映射文件:??? (Progress OpenEdge我需要哪个xml文件?)

• DB Type: General JDBC
• JDBC URL: jdbc:sqlserver://db-name:port;databaseName=**
• Driver jar: ??? (which jar-file do I need for OpenEdge?)
• Class name: ??? (which class name do I need for OpenEdge?)
• User name: *
• Password: *
• Schema: ??? (don't know what this means...?)
• Mapping file: ??? (which xml-file do I need for Progress OpenEdge?)

编辑:我正在64位计算机上使用Windows 7，并使用Talend Open Studio for Data Integration版本5.3.0.r101800.

I am using Windows 7 on a 64-bit machine, using Talend Open Studio for Data Integration version 5.3.0.r101800.

推荐答案

设置OpenEdge OBDC连接:

Setup OpenEdge OBDC connection:

new OdbcConnection("Driver={Progress OpenEdge 10.2B Driver}; HOST=" + host + "; PORT=" + portNumber + "; DB=" + databaseName + "; DefaultIsolationLevel=READ COMMITTED; UID=" + user + "; PWD=" + pasword + ";");

ODBC驱动程序不包含在OpenEdge中.必须下载并安装驱动程序！

ODBC driver is not included in OpenEdge. The driver must be downloaded and installed!

设置OpenEdge JDBC连接:

Setup OpenEdge JDBC connection:

String connectionString = "jdbc:datadirect:openedge://localhost:" + portNumber + ";databaseName=" + databaseName + ";user=" + user + ";password=" + pasword + "";
String cname = "com.ddtek.jdbc.openedge.OpenEdgeDriver";
Class.forName(cname);
connection = DriverManager.getConnection(connectionString);

将驱动程序包含在来自以下位置的类路径中:C:\ Progress \ OpenEdge \ java \ openedge.jar

Include driver in classpath from: C:\Progress\OpenEdge\java\openedge.jar

http://localhost:9090/fathom.htm中的设置:SQL配置Java类路径:@ {startup \ dlc} \ java \ openedge.jar; @ {startup \ dlc} \ java \ util.jar

Setup in http://localhost:9090/fathom.htm: SQL Configuration Java classpath to: @{startup\dlc}\java\openedge.jar;@{startup\dlc}\java\util.jar

更多信息:

• 为用户尝试"system"或"sysprogress"；
• 尝试使用"SYSTEM"或"PUB" 目录或架构；
• 某些工具会要求您提供要使用的外部目录名称，而不是从进度中获取.

• Try 'system' or 'sysprogress' for user;
• Try 'SYSTEM' or 'PUB' for catalog or schema;
• Some tools will ask you for an external catalog name that you wanth to use, not from progress.

这篇关于通过JDBC连接到Talend中的OpenEdge的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！