Netvisor Connection

Step 1. Login to the Netvisor client portal, which you can access here

Step 2. Navigate to the API identifiers page

Step 3. Make sure the API service is enabled and create a new API identifier

Step 4. Make note of the User ID and Key since they are used in the connection manager for establishing a connection

Step 5. Navigate to the API resource access rights menu

Step 6. Enable the integration using the key provided to you by Netvisor

Congrats you're ready to consume and push data to your Netvisor integration

Step 1. Run "Visual Studio" under "Administrator account". Right click on Connection managers Tab and Select New Connection. In Add SSIS Connection Manager scroll down and select Connection managers for REST Connection and click Add.

Step 2. From drop-down menu Configuration select Netvisor.

Step 3. Input your credentials

Step 4. Click "Test Connection" to test your connection.

Congratulations! You have now established a connection to your Netvisor instance.

Step 1. Select an existing "Data Flow task" or create a new "Data Flow Task".

Step 2. Open the "SSIS Toolbox" and drag and drop COZYROC "REST Source" component.

Step 3. Double click on the "REST Source" component and select Netvisor connection from the combo. Select from available Netvisor resources listed in the second combo below.

Step 4. Click on the "Columns tab" and select the Netvisor resource columns you want to read.

Step 5. Click Preview to make sure all necessary resource columns are included.

Bravo! You have now learned how to read data from Zoho Campaigns service.