Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Tools for EMR Database Query, Browse Tables Views, Stored Procs (oracle and SQL Server)

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

9 Posts

8 Users

0 Reactions

92 Views

RSS

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

Topic starter

I am interested in finding out what tools you like to use for doing database queries. It is important to test queries before building Crystal Reports, and handy to have a database tool to do that with.

I am currently on Centricity 9.5 and CPS 10 ( ORACLE ) but will be migrating soon to CPS 12 (SQL Server). So I want to hear from you on both databases.

I have used TOAD for Oracle in the past, and liked it very much - but it's pricey.

Please post here - database gurus 🙂 and anyone else - what database tools you like using.

Thank you !

Beverly Blackman

Posted : November 7, 2014 6:48 am

acantu

(@acantu)

Posts: 722

Prominent Member

Been using SQL Developer for Oracle, not much to it. Just gives you what you need to test your queries. Also use SQL Server Management Studio for MS SQL.

Posted : November 7, 2014 6:50 am

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

For MSSQL we use Microsoft SQL Server Management Studio. It has Intellisense (auto complete) built in, which makes creating your queries really simple.

Posted : November 7, 2014 8:29 am

Jim Lawhon

(@jlawhon)

Posts: 39

Trusted Member

I am not a database guru or even a programmer. I use Microsoft Access and have for a lot of years. I am on the Oracle product

Posted : November 7, 2014 8:33 am

jamesedward

(@jamesedward)

Posts: 257

Reputable Member

Thumbs up for Oracle SQL Developer -- easy enough to use and cannot beat the price!

Posted : November 10, 2014 3:26 pm

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

Topic starter

James, I downloaded and installed Oracle SQL Developer. Now trying to make a connection string to my EMR 9.5 database. There is no connection type for ODBC in Oracle SQL Developer. What can I use as a connection string ? Can you give me an example ?

- Beverly

Posted : November 11, 2014 1:24 pm

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Use Connection Type Basic, Role is default unless you want to connect as SYS. Put your database server name in Hostname, Port should be 1521 and the SID should be the same as the XXXX value in your TNSNAMES.ORA file on this line:

(SERVICE_NAME = XXXX)

SERVICE_NAME could also be SID....

Posted : January 6, 2015 7:47 am

aaltotsky

(@aaltotsky)

Posts: 129

Estimable Member

Personally, I like devart Oracle driver. It's much simpler to use and can connect to Oracle directly (without ORA-files) See: devart.com

Posted : January 15, 2015 9:40 pm

mwilliams

(@mwilliams)

Posts: 3

New Member

I like to use navicat, it allows for multiple different SQL languages and systematic way to store queries.

There is also a free version of toad that is for MSSQL.

Posted : January 28, 2015 8:22 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0