Foundation Authentication
Step 1: Determine Hosting Option
First, confirm with your customer if their Foundation instance is hosted on-premises or hosted by Foundation. Most customer instances are hosted by Foundation.
Then, follow the steps below based on the hosting option.
Step 2a: Request IP White-listing (On-Prem Only)
If your customer is using an on-premise Foundation instance, you will need to request that their IT team whitelist Agave's static IPs:
13.58.14.240
18.219.160.98
3.143.37.24
This allows our servers to communicate with the Foundation database hosted on the customer's network.
Then, follow the steps in 2b and ask the customer to give your SQL user permission to perform read and write operations to the required tables.
Step 2b: Request Foundation Enable Writes to Pending tables (Foundation-Hosted and On-Prem)
If you do not need to write data to Foundation using Agave API, you can skip this step.
If you intend to write data back to Foundation (e.g., for Purchase Orders), you will need to request permission from the Foundation team to whitelist a database name and user.
For your reference, here are the endpoints to which you can write data in Foundation:
Agave Endpoint | Foundation Tables |
---|---|
AR Payments | pending_ar_cash |
Change Orders | pending_po_sync_header , pending_po_sync_detail |
Employees | pending_employees |
Purchase Orders | pending_po_sync_header , pending_po_sync_detail |
Subcontracts | pending_po_sync_header , pending_po_sync_detail |
Here is a draft email you can send to Foundation Support. Alternatively, you can request api-support@agaveapi.com contact Foundation on your behalf with this info:
Hello - would you be able to whitelist the following Foundation Database and User to allow writing data to the following tables?
- Database: {add your Foundation database name here}
- User: {add your username here}
- Tables: {e.g. pending_po_sync_header, pending_po_sync_detail}
Step 3: Authenticate Using Agave Link
To authenticate a user with Foundation using Agave Link, you will need the following information:
- Hostname: this is the hostname of the Foundation database. For hosted Foundation instances, input "sql.foundationsoft.com".
- Port: this is the port that enables Agave to communicate with the Foundation Database. Note, this should always default to 9000.
- Database: this is the name of the Foundation database.
- Username: the username must be for a registered Foundation User. For instructions on how to create a User, see below).
- Password: this is the password for the registered Foundation User.