AOI is a useful tool to enable building custom reports on your SelectPay data. To retrieve the data from SelectPay, you first need to set up a data connection. To do this, follow the steps under the relevant section below.
Hosted
In your browser, go to your login URL.
Enter your cloud username and password.
Click AOI Administrator, then click Data Connections.
Click the connection type drop-down and click Access SelectPay (Hosted).
Check the Domain is Cloud, then enter your cloud username.
Enter the account password.
Check the HTTPS Server URL is: aoilive2.accessaCloud.com
Click the Database drop-down, and click the SelectPay database.
Click Add.
To make a default connection, click Make Default, then click Ok.
On-premise
Press the Windows key and search for 'AOI'.
Click AOI Administrator, then click Data Connections.
Click the connection type drop-down and click Access SelectPay.
If using a Windows authenticated user, select the Windows checkbox.
Enter your SelectPay username and password.
Select the checkboxes, TCP and Secure Connection.
In the TCP Server field, enter the server name and port number for SelectPay.
Click the Database drop-down, and click the SelectPay database.
Click Add.
To make a default connection, click Make Default, then click Ok.
Port number and server name
If you are self-hosted and need to find your port number and service server name, follow the steps below.
Press the Windows key, and search for 'SelectPay'.
Click the SelectPay Client application.
Click the two arrows >>.
Note down the TCP Server and Port number.