Execute the EMS Master Calendar Data Connector Script

In order to use the EMS Master Calendar Data Connectors, an organization must be properly licensed. If unsure about whether the EMS Data Connector Module, that allows importing from the current EMS Database, has been purchased; Log into the EMS Master Calendar site, go to the systemcheck.aspx page, click the License Information heading and review the Licensed For list and look for a description to state “EMS Connector”.

If an organization was not previously licensed for the EMS Data Connector Module but is now, update the registration information by logging in to the EMS Master Calendar, going to Admin – Site Administration - Registration, entering the new licenses information then click Save License Data. Please note, the license information is case sensitive and needs to be entered in exactly how it was provide.

After entering the registration information, EMS Master Calendar must re-read the license by going to the systemcheck.aspx page, clicking the License Information heading and then clicking Read License. At the very top of the page, it should state “License read successfully.”

The information in this section is for executing a SQL script against ones existing EMS Database. The EMS Data Connector Scripts create the needed stored procedures to export information from an EMS Database to the EMS Master Calendar Database. To do so, one must run the DEA.MasterCalendar.DataConnectorScript.sql against the existing EMS Database(s).

Be sure that the EMS Data Connector Script is executed against the EMS Database not the Master Calendar Database.

1. On the database server, start the SQL Server tool (Query analyzer\Sql Management Studio) that's used to execute sql scripts.
2. Select the EMS Database, which is going to be the data source for EMS Master Calendar.
3. In the query window, navigate and open up the EMS Data Connector Script.
4. Execute this script against the EMS Database, not the EMS Master Calendar Database.

   If error messages are generated, check the settings and permissions. Then try to re-execute the script against the correct database. If error messages continue to be generated, contact Customer Support.

   • To use the Data Connectors and exchange data between the EMS database and Master Calendar database, Ad Hoc Remote Queries has to be enabled in order for a Data Connector to work.
   • For Microsoft SQL Server 2005 – To check to see if Ad Hoc Remote Queries are enabled – on the Database Server – find Microsoft Configuration Tools > SQL Server Surface Area Configuration > Surface Area Configuration for Features > Select the server level > Database Engine > be sure “Enable OPENROWSET and OPENDATASOURCE support” is checked. If it is not checked, data connectors will not be able to pull data from the EMS database to the Master Calendar database.
   • For Microsoft SQL Server 2008 and 2012 – To check to see if Ad Hoc Remote Queries are enabled – on the Database Server - go to Management Studio > right click on Server level > Facets > from the drop-down box > Select Surface Area Configuration > Check AdHocRemoteQueriesEnabled > Set to True. (This might require a restart of the SQL Server this is changed on.)