You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » tDBInput - No Connecton Type
#1 2008-03-14 12:38:24
- sandyt
- New member
- Registered: 2007-07-13
- Posts: 5
tDBInput - No Connecton Type
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.
Offline
#2 2008-03-17 08:15:23
Re: tDBInput - No Connecton Type
Hi
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?
Best regards
shong
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
#6 2008-03-18 07:17:20
Re: tDBInput - No Connecton Type
Hello sandyt
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.
Best regards
shong
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
#7 2008-03-18 20:42:00
- sandyt
- New member
- Registered: 2007-07-13
- Posts: 5
Re: tDBInput - No Connecton Type
Hi Shong
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.
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » tDBInput - No Connecton Type