SmartConnect 2018

Using Multiple Databases

The SmartConnect install gives the option to connect it to multiple databases.  This can be very useful in a scenario where a Production and Test instance is desired.

 

 

To install SmartConnect with multiple databases:

a.During the initial install of SmartConnect the first database and SmartConnect user will be created.  Once the install has completed you will be set to use SmartConnect with the primary database. On the SmartConnect Login screen you will be able to see in the dropdown the database that was created during the installation (server – Database Name).
b.To add a second database we need to create a new database and user on the SQL server manually.
a.Create a new Login on the SQL server first that will be used for the SmartConnect user on the second database. If there already is a SQL user setup that is to be used, this step can be skipped.

Create SQL Login

 

b.Create a new database that will be used for the second SmartConnect database. Be sure to make the new login that was just created the Owner of this database.

Create SQL Database

 

c.SmartConnect now needs to be configured to use the new database. Navigate to C:\Program Files (x86)\eOne Solutions\SmartConnect and launch eOne.SmartConnect.Config as an administrator.  This is the SmartConnect Configuration which will allow us to setup SmartConnect to have access to both databases.
d.On the Production tab enter the Server, Database, User, and Password for the database that was setup during the SmartConnect installation and then click the Test Connection button.
e.Once successfully connected, choose the location of the WCF Web Config and Web Service Web Config. All the other settings will be automatically setup. By default the WCF Web Config path is C:\Program Files (x86)\eOne Solutions\wcf\web.config and the Web Service Web Config path is C:\Program Files (x86)\eOne Solutions\www\web.config.

ProdConfiguration

 

f.On the Test tab enter the information for the database that was manually setup on the server and click the Test Connection button to verify the credentials.

Test Configuration

 

g.Click the Save Changes button to finish setting up SmartConnect to connect to two databases. When SmartConnect is launched at this point there will be the option to select which database to connect to

SmartConnnect databases Login

 

h.Each database will need to be logged into, registered and have system maintenance run. Once you have registered SmartConnect, it should prompt to run the System Maintenance.  If it does not automatically prompt, the System Maintenance can be run by going to the Setup tab and selecting System Maintenance.
i.At this point, each setup will be ready for use.

 

Notes:

•The SQL databases for the Production and Test instances do not need to reside on the same SQL Server.  Installing SmartConnect in this manner just allows you to manage multiple instances from one SmartConnect program installation.
•Anything done in one database will not be available in the second database unless you export it out and then import it back in.
•One limitation is the web services will only work for one database at a time. This is controlled by the Use Production and Use Test checkboxes in the SmartConnect Configuration tool. For the web services to link up to the production database mark the Use Production check box (marked by default) and vice versa.