topic Re: [resolved] Jdbc paradox to export tables in Talend Studio

[resolved] Jdbc paradox to export tables

Anonymous — Sat, 16 Nov 2024 10:39:50 GMT

Hello everyone,
I have a problem, i can't export my tables from paradox to cassandra because i can't find a free jdbc driver to read and export from paradox server. Is a talend jdbc for paradox for that (or in current work ) or someone have a idea where i can find a free jdbc for paradox or an alternative to jdbc ? I take everything !
My current version of talend is 6.1.1 64 bits and the version of paradox is 7.x or 11.x. (Hope it's enough)
I find com.hxtt.sql.paradox.ParadoxDriver from "www.hxtt.com" but its not free ! (My wallet is in a galaxy, far far away !)
I can connect with that but i can't read or export tables from paradox...
Thanks for your time and your attention.
ps: sorry for my english.

Re: [resolved] Jdbc paradox to export tables

Anonymous — Thu, 05 May 2016 10:27:15 GMT

Hello
There are no special paradox components, but you can try the common JDBC component tJDBC... or ODBC components tDBxxx. Refer to this topic:
https://community.talend.com/t5/Design-and-Development/resolved-Lookup-non-fonctionnelle/td-p/69187
Regards
Shong

Re: [resolved] Jdbc paradox to export tables

Anonymous — Fri, 06 May 2016 12:49:52 GMT

i tried with the generic jdbc and for now i failed miserably. for the tdbinput componant its seem to not be in my talend did i have to download it ? and i found the old sun.jdbc.odbc.jdbcodbcdriver from rt.jar to put an odbc connection in a tjdbc but i failed too :s
can you explain me step by step how to do this i'm really lost here ! (for the odbc connexion)

i just found https://help.talend.com/search/all?query=Setting+up+a+database+connection&content-lang=en
"Also due to Java 8 limitations, you cannot create Generic ODBC or Microsoft SQL Server (ODBC) connections in Talend Studio 6.0 and onwards" so goodbye generic odbc solution i suppose or am i missing something ?

Re: [resolved] Jdbc paradox to export tables

Anonymous — Fri, 06 May 2016 16:06:49 GMT

i found a pdxjdbc.jar:
- in URL JDBC i put jdbc:bdea://localhost/<localfileadress>;SM=<session_user>
- in pilote i put PdxJdbc.jar
- in class name com.corel.pdx.driver.PdxJDBCDriver
- etc
i crash everytime when i put "SM=<session_manager>" in the url, and i can't establish a connection without, i'm pretty stuck here... i'm not sur what they mean by session manager

Re: [resolved] Jdbc paradox to export tables

Anonymous — Mon, 23 May 2016 09:12:06 GMT

buy the jdbc and everything perfect.

Re: [resolved] Jdbc paradox to export tables

Anonymous — Mon, 23 May 2016 09:19:40 GMT

buy the jdbc and everything perfect.

No way, sometimes you have to spend money.