topic Re: problems with retrieving *.dbf schemas in Talend Studio

problems with retrieving *.dbf schemas

Anonymous — Thu, 17 May 2012 03:06:54 GMT

i have some *.dbf files(sybase table files) in my local folder, i use advantage database architect 8.1 to manage them,now i want to migrate these table data to sql server.
i am trying to use talend to do this.
first,i tried create Db connections by selecting Sybase(ASE and IQ) as DB Type,but can't configure correctly.
now i want to use General ODBC type, i create a odbc datasource in control panel( my os is windows 7) using 'driver to microsoft dBase(*.dbf)' driver,then i can successfully created connection in talend, but i got problems still,
some of the tables i can retrieve schema,but some table can't, the creation status is success,but column number is 0.
i have installed advantage odbc driver 10, but when i use advantage streamline odbc sql to create datasource, talend create connection is no problem,but can't read tables to schema repository, the name column has no names

can any one help?

Re: problems with retrieving *.dbf schemas

Anonymous — Thu, 17 May 2012 08:31:25 GMT

Hi
This 5606 may help you.
But we haven't tested it to read a Sybase dbf file.
Regards,
Pedro

Re: problems with retrieving *.dbf schemas

Anonymous — Thu, 17 May 2012 10:08:43 GMT

how to paste img? i

Re: problems with retrieving *.dbf schemas

Anonymous — Thu, 17 May 2012 10:11:24 GMT

Hi
Click on 'Post reply' as the following image.
Please notice limits: 20 images per post, each image must be less then 1024x768 pixels and 200 KB.
Usually people will connect to Sybase DB server instead of extracting data from dbf.

Regards,
Pedro

Re: problems with retrieving *.dbf schemas

Anonymous — Thu, 17 May 2012 10:36:52 GMT

i use advantage database architect create a datadictionary and create some tables stored in my local folder.
then i create odbc datasource(why i use odbc datasource is because i can't create connection in talend use sybase database server), create connection passed,but can't retrieve schema.

Re: problems with retrieving *.dbf schemas

Anonymous — Fri, 18 May 2012 04:59:59 GMT

seems nobody have such experience?