SQL Server Integration Requirements

To Do Before Integration Kick-off

  • Configure RDP or VPN access for Mosaic to connect to your server (Link to download Getscreen.me)
  • Ensure that Replication Components are enabled on SQL Server
  • Create a Windows Admin user for Mosaic with Admin (sysadmin) access to SQL Server
  • Ensure that if using SQL Server 2012 or later, the required updates are installed

Requirements

  • Standard Edition or Enterprise Edition SQL Server 2012 or later
    * Express edition is not supported in this process
  • If using SQL Server 2012: must have the latest Service Pack installed
  • If using SQL Server 2014: must have Service Pack 3 and Cumulative Update 4 or later installed
  • Replication components for SQL Server must be enabled
  • Remote access to the server hosting your application's SQL Server database
    • VPN account (with relevant documentation) + RDP details
    • OR screen sharing session via Getscreen.me
  • Windows admin user that doesn't expire
  • SysAdmin access to your application's SQL Server database

👍

Please Note:

To ensure effective replication monitoring and troubleshooting, Mosaic recommends providing unattended remote access to the server machine for a minimum of 3 days after the replication setup.

This can be achieved through VPN, RDP, or Getscreen.me.

Mosaic Subscriber Database

Mosaic's Integrations Team will setup a publisher/subscriber job on your SQL Server. The pub/sub jobs replicate your data to an Azure database, hosted by Mosaic.
You can expect that data is available in Mosaic up to 4 hours from the time that it is added in your source application. The subscriber established a one way connection from your database, to our Azure database. No changes will be pushed from Mosaic into your source application.

Note: The integration with Mosaic utilizes the Distributor, Publisher, and Subscriber components of SQL Server. This requires your application's database to be connected to SQL Server, the SQL Server Agent to be configured and running, and the provided Windows admin user and password to not expire.