OHDSI / WhiteRabbit

WhiteRabbit is a small application that can be used to analyse the structure and contents of a database as preparation for designing an ETL. It comes with RabbitInAHat, an application for interactive design of an ETL to the OMOP Common Data Model with the help of the the scan report generated by White Rabbit.
http://ohdsi.github.io/WhiteRabbit
Apache License 2.0
181 stars 90 forks source link

Error connecting to server #160

Open TianyeQi opened 5 years ago

TianyeQi commented 5 years ago

I attempted to use WhiteRabbit 0.8.1. I couldn't connect to my oracle database. There are two means by which I tried to connect to the oracle database, and I got two types of error

db

The "omop_d" is server name, but the application recognized it as a SID

db2

If I deleted the port and server name, the app couldn't establish the connection.

I am sure the location, username and password are correct because I can connect to the database using Datagrip.

MaximMoinat commented 5 years ago

Sorry for not responding earlier. @TianyeQi Have you been able to solve the issue on your own? If not, could you verify you are using the same conventions as described here: https://www.ohdsi.org/web/wiki/doku.php?id=documentation:software:whiterabbit#specifying_the_location_of_data