Updated: October 1, 2020 9:31am

Connections

Data is replicated between two servers at each end of a connection. As servers join the enterprise, you can create one or more connections for each server. At a minimum, each store server or child POA needs a connection to its POA. You can add other connections as needed.

Tech Toolkit: Add New Connection

  1. In the Tech Toolkit, select File > Connection Manager from the top menu. Click the Add button    
  2. The New Connection screen is displayed. Enter a Name for the connection. Enter the FQDN or IP Address of the server that will be on the other end of the connection.    
  3. Select a Connection Type. (If you select Database, select a Database Type: Oracle or MySQL)    
  4. (Rest or Database Connection type) Enter a valid Prism User Name and Password. (default = sysadmin/sysadmin)    
  5. Test the connection.   Click OK.     
  6. Confirm the RIL Address in the Installation Defaults area of the Admin Console    

Connection Types

Type Description
Local Use this type of connection if connecting to an installation on the local machine.
REST The type of connection will use standard HTTP REST statements (GET, PUT, UPDATE, DELETE) to replicate data.
Database Use this type of connection to create a connection to a MySQL database.


Connection Manager - SSL Connections
In the Connection Manager area of Tech Toolkit, when adding a new REST connection, select the Use SSL checkbox if the connection uses SSL.
 
Link Profile to RIL Connection
Click the Checkbox on the left side of the grid for the desired connection. Click the Checkbox for a profile for both the Send and Receive directions. Above the grid is a description of the connection, e.g. "From Prism HQ to POA 1". Make sure the profiles are assigned to the correct direction. The changes you make on this screen are automatically saved by the system.
RIL dashboard connections

Deactivate Connection
With a connection selected in the grid, you can click the Deactivate Connection button to deactivate the connection. Deactivating breaks the TCP/IP connection.  To reactivate the connection, refresh the screen display, select the connection, and then click Activate.
Disconnect Connection
If you click the Disconnect button, the currently selected connection is removed. If the deleted connection was your only RIL connection, you will see a warning message.  You can then click the Use Existing RIL server button to add the connection back. If a server has to leave the enterprise (e.g. seasonal stores, or store closings), before leaving the enterprise, you MUST disconnect the server's RIL connection.
RIL Dashboard if no RIL Connections Exit
If no RIL connections exist yet, then when you navigate to the RIL Dashboard, you will see a pair of buttons for selecting an existing RIL server or adding a new RIL server.
No RIL Server scvreen
Click Use Existing RIL Server to select an existing server that is already known and connected on the network. Select the desired server from the dropdown and click Connect.

Add/Edit Local RIL Server
Click the Add/Edit Local RIL Server button if you want to connect to a server that is not yet known to the machine. After you enter the server name and save, that server will be available for selection in the "Use Existing RIL Server" drop down and you can connect to it.

My SQL Considerations
MySQL users must be careful to select the correct connection when activating a connection for initialization. For example, many MySQL users will notice two entries in the Connection drop-down: one for MySQL and one for RPS (see screenshot below). Users must be careful to choose the RIL (RPS) connection, not the MySQL connection. Keep in mind that "RPS" is the default name for RIL connections. The RIL connection name you see in the drop-down will likely be different.

Connection Types

Connection Type Description
Local Use this type of connection if connecting to an installation on the local machine.
REST The type of connection will use standard HTTP REST statements (GET, PUT, UPDATE, DELETE) to replicate data.
Database  Use this type of connection to create a connection to a MySQL database