You are not logged in.

PALO ETL GenericDB /Odbc

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

ExcelcioPhm

Intermediate

  • "ExcelcioPhm" started this thread

Posts: 5

Date of registration: Jul 9th 2012

  • Send private message

1

Monday, July 9th 2012, 10:33am

PALO ETL GenericDB /Odbc

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

Sage

Posts: 762

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

2

Monday, July 9th 2012, 9:40pm

Hi,

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

Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

ExcelcioPhm

Intermediate

  • "ExcelcioPhm" started this thread

Posts: 5

Date of registration: Jul 9th 2012

  • Send private message

3

Tuesday, July 10th 2012, 2:53pm

Hi,

I want to extract several tables on multiple databases

Regards

konradmai

Master

  • "konradmai" is male

Posts: 54

Date of registration: Apr 18th 2007

  • Send private message

4

Wednesday, July 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

Intermediate

  • "ExcelcioPhm" started this thread

Posts: 5

Date of registration: Jul 9th 2012

  • Send private message

5

Wednesday, July 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

Master

  • "konradmai" is male

Posts: 54

Date of registration: Apr 18th 2007

  • Send private message

6

Wednesday, July 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

Intermediate

  • "ExcelcioPhm" started this thread

Posts: 5

Date of registration: Jul 9th 2012

  • Send private message

7

Wednesday, July 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

Master

  • "konradmai" is male

Posts: 54

Date of registration: Apr 18th 2007

  • Send private message

8

Wednesday, July 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

Intermediate

  • "ExcelcioPhm" started this thread

Posts: 5

Date of registration: Jul 9th 2012

  • Send private message

9

Thursday, July 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

Similar threads

Used tags

Dbase, ETL palo, GenericDB, JDBC, ODBC

Rate this thread