Paylocity
Paylocity
Setup Guide
Follow these steps to connect Paylocity to your CData Connect account:
-
Open the Connections page of the CData Connect dashboard.
-
Click + Add Connection in the upper-right corner.
-
Type Paylocity into the search field, then click the data source name.
-
On the Basic Settings tab of the new connection, enter a connection name or keep the default name.
-
Enter the following information:
-
OAuth Client Secret—Set to the client secret in your app settings.
-
OAuth Client Id—Set to the client Id in your app settings.
-
IV—Set this to the base64-encoded AES initialization vector (IV) to use when encrypting content. Only required if Key is also set.
-
Key—Set this to the base-64 encoded AES symmetric key to use when encrypting content. Only required if the IV is set.
-
RSA Public Key—the RSA key associated with your Paylocity account. Only required if you want to execute Insert and Update statements.
-
-
At the top of the CData Connect Add Paylocity Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
More Information
For more information about interactions between CData Connect and Paylocity, see this information page.