Java API for Informatica

Question

我正在尝试使用Java API来连接informatica。我尝试在使用com.informatica.powercenter.sdk.mapfwk.core.*库的C:\Program Files\Informatica\PowerCenter8.6.1\MappingSDK\samples\src\com\informatica\powercenter\sdk\mapfwk\samples位置运行示例。

当我尝试运行CreateConnectionSample.java(到存储库的简单连接)时，我得到了异常。

代码：

CachedRepositoryConnectionManager rpMgr = new CachedRepositoryConnectionManager(
            new PmrepRepositoryConnectionManager());
    Repository rep = new Repository();
    RepoProperties repoProp = new RepoProperties();

    repoProp.setProperty(RepoPropsConstant.PC_CLIENT_INSTALL_PATH,
            "C:\\Program Files\\Informatica\\PowerCenter8.6.1\\client\\bin");
    repoProp.setProperty(RepoPropsConstant.TARGET_REPO_NAME, "EDW_DEV_REPO");
    repoProp.setProperty(RepoPropsConstant.REPO_SERVER_DOMAIN_NAME, "DOM_GWM_DEV01");
    repoProp.setProperty(RepoPropsConstant.SECURITY_DOMAIN, "MSSB_INFA_DVLPR_DEV");
    repoProp.setProperty(RepoPropsConstant.ADMIN_USERNAME, "Username");
    repoProp.setProperty(RepoPropsConstant.ADMIN_PASSWORD, "Password");
    repoProp.setProperty(RepoPropsConstant.TARGET_FOLDER_NAME,"CORE");
    rep.setProperties(repoProp);
    rep.setRepositoryConnectionManager(rpMgr);
    ConnectionObject connObj = new ConnectionObject("Con", ConnectionAttributes.CONN_TYPE_RELATION);
    rep.createConnection(connObj);

我得到了异常

com.informatica.powercenter.sdk.mapfwk.exceptions.ConnectionFailedException: Failed to list connections in PowerCenter Repository

之前有没有人这么做过？有人能帮我设置Java API吗？

Answer 1

好吧，这真的很老了，希望您最终能使用SDK进行连接。这是我用来连接和查询工作流的一些最新代码。

    public static void main(String[] args) throws Exception {
    if(System.getenv("INFA_DOMAINS_FILE") == null)                  // make sure .infa file exists
        throw new Exception("INFA_DOMAINS_FILE path not set in environment variables.");

    Repository rep = new Repository();
    RepoConnectionInfo rci = new RepoConnectionInfo();
    rci.setRepoServerHost("your host DNS name");                    // set host URI     
    rci.setRepoServerPort("your host port number");                                 // host port
    rci.setRepoServerDomainName("your-domain-name");                    // repository domain name
    rci.setTargetRepoName("your-repository");                           // repository
    rci.setSecurityDomain("e-directory");                           // security type
    rci.setAdminUsername("your-credentials");                               // uid
    rci.setAdminPassword(getPassword());                            // pwd (stored in environment variable -- encoded so it's not cleartext)
    rci.setPmrepCacheFolder("c:\\users\\your-credentials\\Informatica\\");  // some cache folder that must be set  
    rci.setPcClientInstallPath("C:\\Informatica\\9.0.1\\clients\\PowerCenterClient\\client\\bin\\");
    rep.setRepoConnectionInfo(rci);                                                 // provide connection info to rep object
    RepositoryConnectionManager repmgr = new PmrepRepositoryConnectionManager();    // set up repository connection manager
    rep.setRepositoryConnectionManager(repmgr);                                     // tell repository to use connection manager

    System.out.println("Folders:");
    System.out.println("===========================================================================");
    List<Folder> folders = rep.getFolders();
    for(Folder f: folders) {  System.out.println(f);}
}