Migrating from a protected password database hyperfile

One Star

Migrating from a protected password database hyperfile

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 ?
Moderator

Re: Migrating from a protected password database hyperfile

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Moderator

Re: Migrating from a protected password database hyperfile

Hi edidwh,
Would you mind having a try on this solution mentioned in document doc.pcsoft.fr/en-US/?9000059?
Password=MyFile1Smiley Tongueassword1;Password=MyFile2Smiley Tongueassword2
into "Additional ODBC Parameters" in "Advanced settings" in tDBInput
Feel free let us know if it is OK with you.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Migrating from a protected password database hyperfile

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=MyFile1Smiley Tongueassword1;Password=MyFile2Smiley Tongueassword2
into "Additional ODBC Parameters" in "Advanced settings" in tDBInput
Feel free let us know if it is OK with you.
Best regards
Sabrina