Connect PointClickCare DataRelay to ARP

How to connect AR Proactive to DataRelay (from PCC)

 

About PCC DataRelay

PointClickCare - transparent background

 


The two options for DataRelay setup

  • There are 2 options to connect AR Proactive (ARP) to PCC DataRelay
    • Option 1: AR Proactive hosts.  We setup and maintain your DataRelay server.  This is strongly recommended because the data updates fail less often.  The do not pay extra to us to host. You do not need an IT team.
    • Option 2: You host. You setup and maintain your own DataRelay server.  This is not recommended because the data updates fail more often if you do not maintain it properly.  You have to pay for your own hosting. You must have your own IT team to set up your database.

 


Option 1: AR Proactive hosts your DataRelay server

This is the recommended option.  Follow these steps:

Step 1.1   Request PCC to give you access to DataRelay

Contact PCC support (905) 858-8885 (helpdeskgroup@pointclickcare.com) to request access to your DataRelay. 

Complete these steps with your PCC representative:
  1. Sign an LOA (letter of authorization) giving PCC permission to share your data with an outside vendor like us (AR Proactive)
  2. Set up a DataRelay Microsoft SQL 2022 version (or 2019 version, but not 2016)
  3. Generate a "full backup" and begin "hourly" backups (which are also known as "log files")
  4. Supply PCC with these vendor contact details: Rich Handler, CEO, (414) 699-2541, rich@arproactive.com. 

It takes PCC about 2-5 business days to supply DataRelay FTP credentials after you make the request them.  When you receive them, proceed to Step 2 below.  

 

Step 1.2   Send us your PCC DataRelay FTP credentials


PCC will supply you with the following credentials. 

Please email workflows@arproactive.com the following credentials from PCC (if PCC does not copy us on the emails):

  1. FTP credentials to download the "full backup" of your PCC database, and then "hourly backups" (aka "log files) of your new data. The credentials consist of:
      1. The FTP username you need will be in the form [org code]rdbuser e.g. acmerdbuser.  (The other FTP usernames, like[org code]ftpuser and 
        [org code]emaruser and are not relevant, and will not work for this setup.)
      2. The FTP password
      3. The FTP folder that will contain .sqb files which are RedGate SQL Server backup files. 
  2. Decryption password for us to use with Redgate software, to decrypt the above backup .sqb files.  (Since 1/25/25, the password is a 12+ character, strong password.  Prior to 1/25/25, the password was usually in the form of Pcc+[org /code]=$uccess .)


We will begin setting up your DataRelay database after we receive these details.  It takes us about 2 weeks to set up.

You're done! 

 

 

Option 2: You host your own DataRelay server

This is not the recommended option.  Follow these steps:

Step 2.1  Set up your Microsoft SQL Server to host your DataRelay database

  • Create a Microsoft SQL Server in which you make the DataRelay database available. 
    • Use MS SQL Server from 2012 and more recent
    • Use full (standard) installation, not "express"
  • Host the Microsoft SQL Server on
    • an Azure VM (virtual machine), or AWS EC2 Windows instance, or a physical Windows server. 

      These will all support the necessary "automated restore from backup" and other features highlighted below. 
    • Do not use Azure SQL Database, or Azure SQL Managed Instance, because these do not support "automated restore from backup". 
    • See the comparison table taken from this link.
    • The host machine will need aroun 32GB RAM, and enough hard drive space to hold the large backup files.
  • Your IT team (or a third-party IT vendor) can help you.
    • AR Proactive does not provide this service, but we can guide you.  We also connect you with a third-party IT vendor to help you set it up.

 

Step 2.1    Send us the login to your DataRelay database (Microsoft SQL Server)

Send an email to workflows@arproactive.com with the following information. (Your IT team can supply this info after completing Step 2 above.)

  1. host name or IP address of Microsoft SQL Server containing your PCC DataRelay
  2. username (you create this, and it should be read-only, and limited only to the PCC DataRelay database we need)
  3. password
  4. port number
  5. database name
  6. Tell us about your DataRelay refresh times. 
    This is important because when a refresh occurs, our connection to your database is terminated, and we cannot pull your data.  Please answer the following:
    1. What times of day is your DataRelay refreshed?  Meaning how many minutes past the hour, and during what times of day e.g. 8:25am CST, 9:25am CST etc.
    2. How long does each refresh take?  Meaning, is the duration of refresh 1 minute or 10 minutes for example?  You can estimate if you're not sure.
    3. What times of day is the DataRelay refresh paused?  This is when we will pull your data. E.g. refreshes are paused 1am CST to 5am CST.
  7. Are the following IP addresses permanently whitelisted on your DataRelay server firewall?  (Meaning, we should not get removed from your whitelist even if our query takes a long time.)  (Ignore this if you don't have a firewall.)
    1. 148.251.50.170 (application server)
    2. 49.13.194.26 (VPN for AR Proactive)
    3. 167.99.229.162 (VPN for AR Proactive)
  8. We will begin setting up your DataRelay database after we receive these details.
  9. You're done!