Establishing a Connection
Enabling SSIS in Visual Studio 2022
If you're using Visual Studio 2022, you will need to install the SQL Server Integration Services Projects extension to use SSIS.
- Navigate to Extensions > Manage Extensions.
- In the Manage Extensions window's search box, search for "SQL Server Integration Services Projects 2022" and select the extension in the list.
- Click Download.
- Close Visual Studio and run the downloaded Microsoft.DataTools.IntegrationServices.exe installer. Proceed through the installer with default settings.
- Open Visual Studio. There should now be an "Integration Services Project" project template available.
Adding the Greenhouse Connection Manager
Create a new connection manager as follows:
- Create a Visual Studio project with the "Integration Services Project" template.
- In the project, right-click within the Connection Managers window and select New Connection from the menu.
- In the Description column, select CData Greenhouse Connection Manager and click Add...
- Configure the component as described in the next section.
Alternatively, if you have an existing project and CData Greenhouse Source or CData Greenhouse Destination:
- Right-click your CData Greenhouse source or destination component in your data flow
- Select Edit... to open an editor window.
- Click the New... button next to the Connection manager: dropdown selector to create a connection manager.
- Configure the component as described in the next section.
Connecting to Greenhouse
You need an API key to connect to Greenhouse. To create an API key, follow the steps below:
- Click the Configure icon in the navigation bar and locate Dev Center on the left.
- Select API Credential Management.
- Click Create New API Key.
- Set "API Type" to Harvest.
- Set "Partner" to custom.
- Optionally, provide a description.
- Proceed to Manage permissions and select the appropriate permissions based on the resources you want to access through the component.
- Copy the created key and set APIKey to that value.