Visier Workforce AI turns scattered people data into workforce context that adapts as your organization changes. With strict governance and security, data and context reaches your agents, systems, and people, so AI runs on facts, without risk.
Greenhouse Recruiting’s integration with Visier allows you to analyze your applicant pipeline and job posting process flow from end to end. You can surface insight through Visier’s analytic solutions, surface them directly in your own AI workflows or through Visier’s talent agents.
Prerequisites
- Acquire the Greenhouse BI Connector through Greenhouse. This connector is included with the Expert plan. If you don't have the Expert plan, please contact your Greenhouse account manager.
- Determine whether your Greenhouse data is stored in Amazon Redshift or Amazon S3.
- If using Amazon Redshift, select Redshift when providing connector credentials in Visier.
- If using Amazon S3, select Amazon S3 when providing connector credentials in Visier.
- Create an integration user in your database (Amazon Redshift or Amazon S3).
- Allow network and data traffic between Visier and your source system. For more information, see Allow Visier Connections.
Note:
- Visier recommends that you use Greenhouse with Amazon Redshift.
- If you’re working out of the Greenhouse EU silo, your only option is Amazon S3.
IP addresses
If using Amazon Redshift, log a support ticket with Greenhouse to add the following IP addresses to an allowlist for the Greenhouse BI Connector according to your jurisdiction:
United States
- 3.209.36.139
- 18.215.76.61
Azure - EastUS
- 57.152.55.44
Canada
- 52.60.179.226
- 99.79.133.101
- 4.206.141.87
Azure - CanadaCentral
- 130.107.21.172
Europe
- 3.65.101.208
- 18.192.64.158
Asia Pacific
- 13.213.108.107
- 13.251.18.199
Create an integration user in your database
You'll create an integration user in your source system and assign it the appropriate security access so that Visier can retrieve your source data through this user.
| Access | Description |
| If using Amazon Redshift, SELECT access | Assign SELECT access to the tables you want Visier to retrieve. |
| If using Amazon S3, READ access | Assign READ access to the S3 bucket you want Visier to retrieve. |
Provide connection credentials in Visier
Create a connector credential in Visier to authenticate and authorize access to your source system. You will need to provide the following credentials in your connector credential configuration.
On the global navigation bar, click Data > Connector Credentials.
Click Add Connector Credential.
Select a data provider and click Next.
Type a display name and description. Click Next.
Enter the connector credentials. This differs by provider.
If the connector supports table sources, select a source type for the connector:
File sources: Updates require reprocessing and overwriting entire files. For more information, see Sources.
Table sources: Supports incremental updates and SQL transformations during sync. For more information, see Use SQL with Table Sources.
Click Authenticate to ensure your credentials work as intended.
Click Create.
If using Amazon Redshift with Greenhouse, provide the following credentials. If you don’t know your Amazon Redshift credentials, log a support ticket with Greenhouse to retrieve them.
| Credential | Description | Example |
| Endpoint | The URL associated with the Amazon Redshift database. | redshift.greenhouse.io |
| Port | The Amazon Redshift port number. | 5439 |
| Database | The name of the Amazon Redshift database. | mydatabase |
| Schema | The schema in the database to retrieve database objects from. | schema_1 |
| Username | The integration user’s username. | IntegrationUser |
| Password | The integration user’s password. | Password1234 |
If using Amazon S3 with Greenhouse, provide the following credentials.
| Credential | Description | Example |
| Customer API Key | The customer account’s API key. | 4b5435d937c6ae0d2f69d7a0dc457be9-3 |
After a set of user credentials are provided in Visier, the extract, load, and transform (ELT) process is managed by the Visier application or Professional Services team, depending on the specifics of your Visier contract.
Additional resources
For additional information not covered here, reach out to Visier Customer Support.