search

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
178 stars 88 forks source link

Allow SQL Server connection strings or ODBC #356

Open paulschwenn opened 1 year ago

paulschwenn commented 1 year ago

I need to connect to a specific SQL Server instance on a specific port, but this does not seem possible in White Rabbit.

It would be great if a full SQL Server connection string could be passed for the server location when SQL Server is selected.

e.g. Entering www.theserver.com,1432 in the server location field would pass port 1432 as the non-standard instance port.

janblom commented 1 year ago

Have you tried to connect using the information in the WhiteRabbit documentation (http://ohdsi.github.io/WhiteRabbit/WhiteRabbit.html , section "SQL Server")? Let me know if this works.