Connecting to PowerPick

ItemPath connects to PowerPick in two ways: with the rule engine, and directly to the MSSQL server. Pictured below is the technical overview of these connections and ports.

In order to set up these connections, here is what you'll need:

For the PowerPick connection:

• PowerPick SQL Server username, password, database name, dedicated IP address, and port number (if changed from the default port 1433).
  • For ItemPath hosted in the cloud, the dedicated IP address should be a public IP accessible outside of internal networks.
• Your PowerPick SQL Server will need to be able to accept remote connections via IP. For more details on how to set this up, visit the SQL server documentation: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-ver15

For the Web Services connection:

• If you are planning to use ItemPath to create or process orders, you will need a dedicated IP and port number for your machine running the PowerPick rule engine.
  • For ItemPath hosted in the cloud, the dedicated IP address should be a public IP accessible outside of internal networks.

Once you have these items, you can add those details in ItemPath's Settings, in the "Kardex" tab, under "PowerPick" and "Web Services." (You'll see a "Test Connection" button beside each, which you can click to check if the connection details were successful.)