1. Grow
  2. Epicor Modules
  3. Prophet 21 Integration

Creating the Connection in Grow

Article last updated:

In Prophet 21, follow these steps to connect to your P21 instance.

  1. Whitelist ALL our IP addresses.
    1. 52.203.193.180
    2. 52.0.63.147
    3. 18.209.80.4
    4. 13.42.173.220
  2. Collect the Host (Valid IP or Public URL), Port (usually 1433), and Database Name for your Database.
  3. Create a user in your Database (preferably read only) with the PXXI user Role Permission (access to run stored procedures).

Creating the Connection in Grow

  1. Log in to Grow.
  2. Navigate to the Data Tab in the top left corner.
  3. Click Connections on the far left.
  4. Select the blue circle + Connect button.
  5. Search for and select Prophet21. Then click the Connect to Prophet21 button.
  6. Choose a name for your Connection. This can be anything, but we recommend something you’ll recognize if you choose to connect multiple P21 instances.
  7. Add in your Database Host, Port, and Database Name, as well as the Username and Password of the user you just created.
  8. Click Connect.

Troubleshooting

If you are on version 22.2 or higher, and the connection is made successfully, but the warehoused tables you see are “dbo” tables, then the user you’ve connected with doesn’t have the right permissions to run stored procedures. You’ll need to change the permissions on the user to see the tables required for the pre-built content.

Was this article helpful?