Hi, I have an application with a specific driver *.jar. I use it in Netbean IDE without problem to connect. But I am not able to connect in Talend. I have tried to use General JDBC, but I have not xml file an returns failure (I think). I have added the module but this module does not appear in the list of modules. So my parametres are: URL: jdbc:BD://GEST_2015_6 BDL.jar BD.jdbc.LDriver plus USER & PWD I would like to know how to add a specific DRIVER for DB Connection.
Hi, Have you tried to use component tJDBCInput which reads any database using a JDBC API connection and extracts fields based on a query to see if it works? Please take a look at component reference TalendHelpCenter:tJDBCInput.
Hi, Thank you for your answer. I have just tested your solution. I have the same problem of connection failed. Message said that the datbase name is not valid, but it is the same value used in the Net Bean IDE.
Hi Sabrina Thank you for you answer. I am using Talend Data Integration 6.1 version Note:"I repeat I can connect to this database using Java IDE, but not using Talend" Best regards
Hi Sabrina,
Sorry, I forgot: I have not Subscription, my version is Open Source.
In fact I am testing Talend because I will need to have a tool that give me flexibility to do integration between Java Data Base, TX & CSV files, SQL Server, MySql, etc.
I think Talend is the tool, I have already connect Talend with MySQL, SQL Server Express (that not have DTS), but with my specific data base BD I am not able to reach!
For you information, I have done a lot of SQL DTSX Project.
Best regards
Jean Marc
[size=3][font=??]
Hi,[/font][/size]
[size=3][font=??]
[/font][/size]
[size=3][font=??]
Could you please also upload your tJDBCInput component setting screenshot into forum? What's your specific application you are trying to connect to?[/font][/size]
[size=3][font=??]
Feel free to create a workitem jira issue of DI project on Talend Bug Tracker.[/font][/size]
https://jira.talendforge.org/secure/Dashboard.jspa [size=3][font=??]
Best regards[/font][/size]
[size=3][font=??]
Sabrina[/font][/size]
Hi Sabrina, I have uploaded two screenshots tJDBCInput and my NetBean IDE (that works with this driver). My application is a local Accounting System that use JAVA, GESTION4. Best regards Jean Marc
Hi,
[size=2][font="Calibri",sans-serif]
Can you upload again the screenshots you wanted to show, please? For some reason it didn't make it to your post.[/font][/size]
