In this article, you’ll learn how to integrate COZYROC SSIS+ with your KSAT console. This integration pulls campaign and user data available via our reporting API into the COZYROC platform to migrate data from one place to another.

To learn how to create a connection to KnowBe4’s REST API using COZYROC's REST Connection Manager, follow the steps below.

1. On your Windows computer, navigate to Start > Visual Studio.
2. Right-click Visual Studio, then select More > Run as administrator.
3. Right-click on the Connection Managers tab and select New Connection.
4. In the Add SSIS Connection Manager pop-up window, scroll down and select Connection manager for REST connections.
5. Click Add….
6. In the KnowBe4 Connection Manager pop-up window, select KnowBe4 from the Configuration drop-down menu.
7. In the Server field, enter the server URL for your KnowBe4 instance using the following format: “https://[server].api.knowbe4.com”. For example, accounts on our EU server located at eu.knowbe4.com, must use the https://eu.api.knowbe4.com server URL.
   Note:For more information about KnowBe4’s API usage and URLs, see our Developer Documentation.
   
8. Based on the APIs you would like to connect to, provide the values for the Events_Token, Reporting_Token, or PhishER_Token fields. For more information about these tokens, see the list below:
   • Events_Token: Use this parameter for creating custom events for users in KnowBe4. If you want to use this parameter, paste your User Event API Token in this field.
   • Reporting_Token: Use this parameter for pulling reporting data out of KnowBe4. If you want to use this parameter, paste your Reporting API Token in this field.
   • PhishER_Token: Use this parameter for pulling messages from KnowBe4’s PhishER SOAR. If you want to use this parameter, paste your Product API Token in this field.
9. Click Test Connection to test your API connection.
10. When you’re satisfied with your connection, click OK.

You’ve successfully established an API connection to your KnowBe4 instance.

To learn how to read your API data from your COZYROC and KnowBe4 connection, follow the steps below.

1. On your Windows computer, navigate to Start > Visual Studio.
2. Right-click Visual Studio, then select More > Run as administrator.
3. Select Data Flow, then click the link to create a new Data Flow task.
4. Select SSIS Toolbox, then drag the REST Source component onto the Data Flow page.
5. Double-click on the REST Source component, then select KnowBe4 from the Connection drop-down menu.
6. From the Resource drop-down menu, select one of the API parameters that you provided information for earlier.
7. Click Columns, then select the KnowBe4 resource columns you want to read.
8. Select Preview to ensure all necessary resource columns are included.
9. Click OK.