4

i just installed GeoKettle and am trying to do some first steps in this. Can anyone help me with the data input step to an Oracle DB?

I tried the OGR Input: enter image description here

But i seem to be unable to find the right syntax for the connection. Can anyone help me with the Data Source (maybe giving an exampl)? And what exactly do i have to fill in at "Layer Name"? The table name in my database? (i integrated the table , A37_SIREN_UTM in my data source in my example, but putting it in as the layer name didnt work too.)

Another option would be the Table Input: enter image description here

The ODBC connection geodaten is defined on my computer. But here too i am unable to connect to the DB.

Improve this question
4
  • I guess you have to provide the host-computer where the db is located on DNS source name. Before chosing a layer test the connection.
    – MakePeaceGreatAgain
    Feb 19, 2016 at 8:47
  • Ok, i solved it. I queried my database with: SELECT SYS_CONTEXT('USERENV','SERVER_HOST') FROM dual;
    – Patrick M.
    Feb 26, 2016 at 8:40
  • Ok, i solved it. I queried my database with: SELECT SYS_CONTEXT('USERENV','SERVER_HOST') FROM dual; and SELECT SYS_CONTEXT('USERENV','DB_NAME') FROM dual; and filled in the results for "ODBC DSN Source Name" and "Tablespace for Data", respectively (using the Table Input step). Of course i needed to enter user and password too.
    – Patrick M.
    Feb 26, 2016 at 8:47
  • You may answer your own question so that future reads quickly will find it if they have the same problem.
    – MakePeaceGreatAgain
    Feb 26, 2016 at 9:20

1 Answer 1

Reset to default
1

As you have said in comments, the answer here is first to obtain the relevant information by running two SQL queries directly on the database:

SELECT SYS_CONTEXT('USERENV','SERVER_HOST') FROM dual;
/* Gives you "ODBC DSN Source Name" */

SELECT SYS_CONTEXT('USERENV','DB_NAME') FROM dual;
/* Gives you "Tablespace for Data" */

Then use this information in the GeoKettle Database Connection form together with the User Name and Password

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.