topic Re: TAC Dashboard Connection to Oracle Service in Talend Studio

TAC Dashboard Connection to Oracle Service

_AnonymousUser — Thu, 18 Jul 2013 09:59:58 GMT

I am working with a client on behalf of Talend Prof Services in UK.

We are running Oracle 10g as a Service. The TAC db is successfully setup on this server. AMC in Studio is correctly configured and I can connect to the AMC perspective ok (although this can only be done by saving an incorrect connection then editing it as this allows you to override the complete jdbc entry).
On TAC however I cannot connect to it - I get "Cannot connect to database ( cause Io exception: The Network Adaptor could not establish the connection)". I have entered the HOST as @//{host} because if I don't I get a TNS error.
Any ideas?

Re: TAC Dashboard Connection to Oracle Service

Anonymous — Thu, 18 Jul 2013 10:36:33 GMT

Hi,
For this issue, "the Network Adaptor could not establish the connection".
1. Please check your IP(host) to see if it is correct, such as:jdbc racle:thin:@192.168.248.154:1521:test.
2. Check your firewall, If there is fire wall, which will cause the port shield. Try to reconnect, after you turn off the firewall.
3. The listener of DB is down
Is it success setting an oracle DB connection in studio?
Best regards
Sabrina

Re: TAC Dashboard Connection to Oracle Service

_AnonymousUser — Thu, 18 Jul 2013 14:53:04 GMT

Hi xdshi
Studio connects no problem and also TAC admin database ok too. The issue seems to be because it is a Service - there is no TNS set up for this instance.
The correct connection string for this server is jdbc racle:thin:@//oex0-scan:1521/CIU_P
This is constructed differently from the TNS version (the "@//" and also "/" not ":" after the port). As I said I can make it work in studio AMC perspective only by creating it first then editing it as this allows me to override the whole string. Likewise in the TAC db we can add the whole string but it appears not in TAC Dashboard connections
Thanks
Ian

Re: TAC Dashboard Connection to Oracle Service

Anonymous — Fri, 19 Jul 2013 04:16:34 GMT

Hi,
Could you please open a ticket on talend support portal, our colleagues from support team will schedule a webex with you to investigate your issue.
Best regards
Sabrina

Re: TAC Dashboard Connection to Oracle Service

Anonymous — Tue, 29 Oct 2013 14:48:47 GMT

Hello, I am seeing a similar issue trying to setup a sql server database connection for AMC. It does not appear to recognize the additional parameters field entry. The connection works fine in studio and the jobs are populating data in the log tables, but I can't get the connection to work in TAC due to a user login error. But I know it is just not using the domain=xxxxx setting I entered in the additional parameters. Is there a file that I can configure manually to pass that entry?
Thanks,
Tina