topic Re: Migrating from a protected password database hyperfile in Talend Studio

Migrating from a protected password database hyperfile

_AnonymousUser — Sat, 16 Nov 2024 11:41:04 GMT

As part of the implementation of a data warehouse, we have to import data from a database Hyperfile (Windev) in a SQL Server database.
The problem is that each database file Hyperfile requires entry of a password to access the data.
We create an ODBC connection to access the database in Talend. From this connection can be recovered Hyperfile tables and their structure but the job returns error at runtime :
Exception in component tDBInput_1
java.sql.SQLException: General error
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at test.test_hf_0_1.TEST_HF.tDBInput_1Process(TEST_HF.java:2484)
at test.test_hf_0_1.TEST_HF.runJobInTOS(TEST_HF.java:6203)
at test.test_hf_0_1.TEST_HF.main(TEST_HF.java:6068)
If the password for the migrated table is deleted, the job runs correctly.
We thought through an OLE DB connection (because you can set the password for each table), but Talend (V5.4.1) does not offer this "DB Type" in the creation of the connection...
Someone has an idea ?

Re: Migrating from a protected password database hyperfile

Anonymous — Tue, 15 Apr 2014 04:19:47 GMT

Hi,
Could you please open a work item jira issue of DI project on TalendBug Tracker, our developer will check it to see if it is possible to achieve that.
Best regards
Sabrina

Re: Migrating from a protected password database hyperfile

Anonymous — Fri, 25 Apr 2014 03:04:47 GMT

Hi edidwh,
Would you mind having a try on this solution mentioned in document doc.pcsoft.fr/en-US/?9000059?
Password=MyFile1 assword1;Password=MyFile2 assword2
into "Additional ODBC Parameters" in "Advanced settings" in tDBInput
Feel free let us know if it is OK with you.
Best regards
Sabrina

Re: Migrating from a protected password database hyperfile

_AnonymousUser — Tue, 27 May 2014 15:04:59 GMT

I have been able to find the advance setting interface but i was wondering if you could explain what myfile1 is.

Hi edidwh,
Would you mind having a try on this solution mentioned in document doc.pcsoft.fr/en-US/?9000059?
Password=MyFile1assword1;Password=MyFile2assword2
into "Additional ODBC Parameters" in "Advanced settings" in tDBInput
Feel free let us know if it is OK with you.
Best regards
Sabrina