Home > Healthcare Integration > Rhapsody MS SQL Server SSO

Rhapsody MS SQL Server SSO

Here are the steps to follow to initially setup a Rhapsody server. No need to make a change on the IDE side.
– Download the jtds-1.3.1-dist.zip.

-Unpack the downloaded zip.

– Copy jtds-1.3.1-dist\x64\SSO\ntlmauth.dll in the unpacked zip and paste it in <RhapsodyInstallDirectory>\jre\bin folder. (e.g. C:\Program Files\Orion Health\Rhapsody\jre\bin).

– Restart Rhapsody for the .dll file to be picked up.
Here are the steps to follow when setting up a database communication point or filter.
On the Properties screen -> Configuration tab set Database = Manual Setting.

Then click on Edit Configuration.

Add a Database Connection in the database configuration editor.

With the Connection Editor set the following properties:

Driver Class Name = SQL Server (jTDS driver).

JDBC URL = jdbc:jtds:sqlserver://DBHostName:Port/DatabaseName;useNTLMv2=true;domain=DomainName or parameterize the URL with Rhapsody variables like this: jdbc:jtds:sqlserver://$(DB_Orion_Server)/$(DB_Orion_Database);useNTLMv2=true;Domain=$(DB_Rhapsody_Domain)

User Name = $( DB_Rhapsody_Acct_Name)

Password = $(DB_Rhapsody_Acct_Password)

Add other standard stuff like SQL and Refresh Rate etc. See the help or DOKI for more options.

Close the connection editor by clicking on OK.

Configure the communication point or filter to use the appropriate SQL or stored procedure.

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: