PALO ETL GenericDB /Odbc

ExcelcioPhm · Jul 9th 2012, 10:33am

Hello,
I try to import tables BDASE depending parameter (directory, database name ....)
I use the GenericDB with the following parameters

Type : GenericDB
URL:jdbc:odbc:dbase
Class :sun.jdbc.odbc.JdbcOdbcDriver

How to set the connection string for GenericDB to be only one ODBC link?
thank's

tish1 · Jul 9th 2012, 9:40pm

Hi,

do you want to extract data from the database or load data to it?

Regards.

ExcelcioPhm · Jul 10th 2012, 2:53pm

Hi,

I want to extract several tables on multiple databases

Regards

konradmai · Jul 11th 2012, 8:46am

Hi,

you have the URL and you have the driver class. So you can setup your connection. And where is the problem now?

BR,
Konrad

ExcelcioPhm · Jul 11th 2012, 9:59am

Hi,

The directory contains multiple databases (C: ... / YYYY / .... dbf)
I need to import data per year per company (multiple databases);
The ODBC connector is configured on a directory .... (I do not want multiple ODBC connection)
I would like to variables based on the year and the company

BR

Philippe

konradmai · Jul 11th 2012, 10:34am

You could use a variable as URL-string. So you can set different databases. And for the import of different databases you could run the ETL job using the command line client (etlclient). There you can also set the content of the variable. Maybe a small BAT-file containing the different import statements would do the job. Have a look at the ETL manual (chapter 4).

BR,
Konrad

ExcelcioPhm · Jul 11th 2012, 12:09pm

Thank you for this response.
But I tried to skip the path of the database in the URL:
jdbc: odbc: dbase: c: \ sources \ 2012 \ EC0786.DBF
But the connection test me return an error
Make a bat file, why not, but I wished to do this directly in the connection string ..

BR

Philippe

konradmai · Jul 11th 2012, 1:46pm

I don't know the syntax of the dBase URL for the JDBC-ODBC bridge, but isn't it possible to do something like this:

URL: ${varURL}

And then in the commandline:

etlclient.bat -s localhost -p project -j job -c varURL="jdbc:odbc:Driver={Microsoft dBase Driver(*.dbf)};DBQ=c:/dbasefolder"

BR,
Konrad

ExcelcioPhm · Jul 12th 2012, 11:32am

Hi

a big thank you for your answer, it works fine ...
I use the variables directly in the url:
odbc:palo_dbase;DBQ=${vREP}${vYear}

BR

Philippe

PALO ETL GenericDB /Odbc

PALO ETL GenericDB /Odbc

Share

Users Online 1

Tags