Database Connection DB Type GUPTA SQLBase

One Star

Database Connection DB Type GUPTA SQLBase

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.
Community Manager

Re: Database Connection DB Type GUPTA SQLBase

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Database Connection DB Type GUPTA SQLBase

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.
Community Manager

Re: Database Connection DB Type GUPTA SQLBase

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
----------------------------------------------------------
Talend | Data Agility for Modern Business