Connecting to Power Pick

ItemPath connects to Power Pick in two ways: with the rule engine, and directly to the MSSQL server. Pictured at the end of this article is the technical overview of these connections and ports. In order to set up these connections, here is what you'll need:

Power Pick MSSQL Connection

• 1. 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.
  • Note: If you’d like to create a firewall to limit access to your SQL server or IP, you’ll want to whitelist ItemPath’s IP address.
     
• 2. Your Power Pick 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
   
• 3. SQL Server username, password, & database name

Once you have these items, you can add those details in ItemPath's Settings, in the "Kardex" tab, under "Power Pick MSSQL".

Click the "Test Connection" button to check if the connection details were successful. If testing the connection fails, visit the Logs to see the full error message.
 

MSSQL Connection Errors: Guides & Tips

• - "Login timeout"
• - "Login failed for user [username]" — check username and password
   

Power Pick Web Services Connection

The Power Pick Web Services module is only required when the scope of ItemPath includes creating, allocating, and processing orders. This module is ordered from your Kardex dealer.

• 1. Dedicated IP and port number (if changed from the default port 1353) for your machine running the Power Pick Cross Enterprise Unit service
  • For ItemPath hosted in the cloud, the dedicated IP address should be a public IP accessible outside of internal networks.
    Note: If you’d like to create a firewall to limit access to your SQL server or IP, you’ll want to whitelist ItemPath’s IP address.
     
• 2. Web Client station in Power Pick with logical bindings (setup detailed here)
   
• 3. Power Pick user (ideally with Admin-level command rights) username and password
   

These details will also be entered in ItemPath's Settings, in the "Kardex" tab, under "Power Pick Web Services".

Click the "Test Connection" button to check if the connection details were successful. If testing the connection fails, visit the Logs to see the full error message.
 

Web Services Connection Errors: Guides & Tips

• - "Unable to connect to Web Services URL / IP address"
• - "Web Services is not installed"
• - "User must be logged in to use order management!"

Click here for how to check if the Web Services endpoint is reachable.
 

Settings & Logs

Settings and logs can be accessed in the footer of ItemPath.

Technical Overview

Pictured here is the architecture of the various connections and ports used by ItemPath.