topic Re: Database Connection DB Type GUPTA SQLBase in Talend Studio

Database Connection DB Type GUPTA SQLBase

Anonymous — Sat, 16 Nov 2024 14:19:54 GMT

Any idea to define a JDBC connection to a GUPTA SQLBase (not in the list of generic databases)?
What shoud be the "String of Connection"?
That works from a java application.
jdbc.gupta.sqlbase.SqlbaseDriver / jdbc:sqlbase://localhost:2155/dbname
Is there any one that has already done such kind of connection within TOS?
GUPTA belongs to UNIFY and was also named CENTURA.

Re: Database Connection DB Type GUPTA SQLBase

Anonymous — Fri, 20 Jun 2008 07:01:20 GMT

Hello
Using the tJDBCxxx component to connect to database, you need to type in the JDBC url, class name manually and load the driver jar. Here the JDBC url is the 'String of Connection'
See 2071.
Best regards

shong

Re: Database Connection DB Type GUPTA SQLBase

Anonymous — Fri, 20 Jun 2008 09:44:15 GMT

Hi,
thank you for your help.
I managed to do a job with a tJDBCConnection. OnSubJobOk, I set a tJDBCInput with a tLogRow to check my data querry. It works!
I wander how I could retreive schema as I do with a db connection in Metadata? How can I define metadata that use this kind of JDBC connection?
kind regards.

Re: Database Connection DB Type GUPTA SQLBase

Anonymous — Fri, 20 Jun 2008 09:58:27 GMT

Hello

I wander how I could retreive schema as I do with a db connection in Metadata? How can I define metadata that use this kind of JDBC connection?

Unfortunately, you can't retreive the schema on tJDBCConnection as doing it in Metadata. You need to define the schema manually.
Best regards
shong