topic Re: how to create a sybase connection in Talend Studio

how to create a sybase connection

Anonymous — Sat, 16 Nov 2024 12:17:39 GMT

i have sybase dbf files in my local folder,i can use advantage data architect to connect to these files.
now i am trying to use talend studio to create a connection to sybase.
on the step 2 "New Database connection on repository" i can choose "Sybase(ASE and IQ)" from DB Type dropdownlist,
but how can i fill the other configurations.
there are login,password,server,port(default:5001),Database,Datasource,Additional parameters.
i can't pass the test connection.
can any one help?

Re: how to create a sybase connection

Anonymous — Wed, 16 May 2012 04:14:03 GMT

Hi
Welcome to Talend Community!
Login: Your username.
Password: Your password.
Server: If Sybase is installed at local machine, it is 'localhost'. Or use IP address.
Port: DB port.
Database: DB instance.
Regards,
Pedro

Re: how to create a sybase connection

Anonymous — Wed, 16 May 2012 05:27:28 GMT

Hi
Welcome to Talend Community!
Login: Your username.
Password: Your password.
Server: If Sybase is installed at local machine, it is 'localhost'. Or use IP address.
Port: DB port.
Database: DB instance.
Regards,
Pedro

i don't know which is DB instance, because i just create a folder and copy the .dbf files into the folder.

Re: how to create a sybase connection

Anonymous — Wed, 16 May 2012 05:38:34 GMT

Hi
Got you.
You'd better load dbf file into your Sybase. Talend can't read data directly from it.
Regards,
Pedro

Re: how to create a sybase connection

Anonymous — Wed, 16 May 2012 08:37:29 GMT

i have use advantage data architect 8.1 connected to my local files, it can load tables there,
how should i configure the database, i don't understand,
should i install Advantage JDBC Driver ?

Re: how to create a sybase connection

Anonymous — Wed, 16 May 2012 08:45:10 GMT

i don't install any advantage database server in my local machine, i just install architect 8.1 and copy some .dbf files into my folder.
it is a local server, what is the port for?
how should i configure

Re: how to create a sybase connection

Anonymous — Wed, 16 May 2012 08:48:52 GMT

Hi
Talend can only connect to Sybase DB Server to do ETL.
We can't extract data from the backup file dbf by JDBC...
Regards,
Pedro

Re: how to create a sybase connection

Anonymous — Wed, 16 May 2012 09:55:23 GMT

Hi
Talend can only connect to Sybase DB Server to do ETL.
We can't extract data from the backup file dbf...
Regards,
Pedro

i installed a advantage database server 10.1 plus architect in my local, and create a new data dictionary(is it a database like sql server?) and create some new tables.
in talend tool,i create connection in step2, i fill the following info:
DB Type: Sybase(ASE and IQ) selected from dropdownlist
login: adssys
password: ***
Server: localhost
port: 6262
DataBase: Test
Schema:
Additional parameters:
then i check, still failed, the error message:
Connection failure. You must change the Database Settings.
java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).

Re: how to create a sybase connection

Anonymous — Fri, 18 May 2012 06:05:38 GMT

Hi
According to the Sybase SQL Error Code description page, error JZ00L occurs as follows:
This error occurs if you enter an incorrect password and/or login ID in the Password and Login ID fields of the Database Profile.
Regards,
Pedro