You are not logged in.
I am trying to use tDBInput to access a database through ODBC. I can do this without any problems using a connection that has been defined in the repository. However if I try the 'Built In' approach there is no 'Connection Type' box despite the documentation for 2.3.1 saying there should be. I get a database connection error "Must specify port after : in connection string" and I suspect that is because I am unable to define the 'Connection Type' as ODBC and it is taking a default value that is some other connection type. Is there a problem with tDBInput when using the 'Built-In' option? If not can someone please tell me how to use it as 'Built-In' with ODBC.
However if I try the 'Built In' approach there is no 'Connection Type' box despite the documentation for 2.3.1 saying there should be.
Which OS are you working on?
I have tested that it works fine in 'Built-in' option . There is only a 'Generic ODBC' option in the 'Connection Type' list.
Can you upload a screenshot of tDBInput?
I have tested tDBInput in Perl version and the job works fine.(see the screenshot)
In fact, the tDBInput component connecte to database in ODBC by default.
In your case, try to define the shema, type in the table name and click on 'Guess Query' button to generate query statement, then run the job again.
The job runs if I do as you suggest ie manually enter the schema and the table name. Thanks!
I still get the error if I use any of the buttons with ... on them. It would be nice if you could give the ODBC connection and have Talend read the database catalog and list the tables and after selecting one be able to select the table fields that you want.