how to create a sybase connection

One Star

how to create a sybase connection

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?
One Star

Re: how to create a sybase connection

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
One Star

Re: how to create a sybase connection

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.
One Star

Re: how to create a sybase connection

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

Re: how to create a sybase connection

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 ?
One Star

Re: how to create a sybase connection

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
One Star

Re: how to create a sybase connection

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
One Star

Re: how to create a sybase connection

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).
One Star

Re: how to create a sybase connection

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog