HomeGuides :: Worldox AutofilerInstallation and Set UpDatabase Connection Set up

1.2. Database Connection Set up

Assemblage often utilizes a firm's existing SQL Databases to collate various pieces of content.  Trumpet establishes those connections via Windows authenticated connections. 

This configuration is available from the main Assemblage application, Tools->Preferences, Database connections:

You can have multiple Database connections

To add a database connection, select "Add"



When the "Add..." window opens, provide a Connection name (typically the name of the software):



The Connection URL field should be completed as follows:

jdbc:jtds:sqlserver://<servername>/<databasename>;instance=<instancename>

Where you replace the "<servername>" with the actual server name, <databasename> with the actual database name and <instancename> with the actual instance name

e.g. jdbc:jtds:sqlserver://SRV2014/JUNXURE;instance=JUNXURE

e.g. jdbc:jtds:sqlserver://SRV2014/PC;instance=PORTFOLIOCENTER


Encryption

If your SQL server requires SSL encryption, you will need to add ssl=required to the end of your Connection URL. 


e.g. jdbc:jtds:sqlserver://SRV2014/JUNXURE;instance=JUNXURE;ssl=required

e.g. jdbc:jtds:sqlserver://SRV2014/PC;instance=PORTFOLIOCENTER;ssl=required


Testing

To ensure that you have access to the appropriate database, select "Test Connection"



If your connection is set properly, you will see the a green check, along with the dialog that says "Successful connection made!"


This page was: Helpful | Not Helpful

© 2012 Trumpet, Inc., All Rights Reserved