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?
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
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.
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 ?
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
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).
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
