SSIS Tutorial: How to connect Cloude.IA to SSIS

Introduction

Cloud.IA is a powerful cloud-native intelligence and automation platform that offers REST APIs for accessing AI models, data processing pipelines, and automation workflows. In this guide, we will demonstrate how to connect Zappysys SSIS connectors to the Cloud.IA using API key authentication.

Whether you are using Cloud.IA for intelligent document processing, data enrichment, or automated workflows, you will learn how to configure SSIS integration without writing custom code. Zappysys handles all the complexity, allowing you to focus on building ETL workflows.

Prerequisites

1. SQL Server Integration Services (SSIS) is installed.
2. Visual Studio with SSIS extension or SQL Server Data Tools (SSDT).
3. Zappysys SSIS PowerPack installed.
4. Cloud.IA account with API access enabled.

Steps

Generate API Key in Cloud.IA

1. Log in to your Cloud.IA account settings.
2. Navigate to Settings > API Keys.
3. Click Create Key.
4. Enter the workspace name (optional).
5. Enter a descriptive name for the API key.
6. Press Add to generate the token Key.
7. Save the API key in a secure location; you won’t be able to view it again.
   

   Claude – Generate Token

8. Set Up Billing (required): add a payment method via the Billing Settings page.

Create Zappysys Connection in SSIS

1. Create or select your SSIS project and open the package.
2. Right-click in the Connection Managers pane and select New Connection…
3. Select ZS-HTTP from the SSIS connectors list
   

   Create a new HTTP connection

4. In Credentials Type, select Static token/API key.
5. Enter the API key from the previous step.
6. The API documentation requires sending the token in the header with this format: x-api-key: API_KEY
   1. In the OAuth header Name, we will use x-api-key
   2. For the OAuth Scheme, set to none
7. Click OK to save the settings.
   

   Claude – HTTP connection

Create and Configure the JSON source

1. In your SSIS package, drag and drop a Data Flow Task from the Toolbox into the Control Flow.
   

   Drag and drop Data flow

2. Double-click the Data Flow Task to enter the Data Flow tab.
3. In the Data Flow, drag and drop a ZS JSON Source component from the Toolbox.
4. Double-click the JSON Source to open its editor.
5. Enable Use credentials, then select your Cloud.IA HTTP connection from the connection list dropdown.
6. Enter the following URL:
   
   https://api.anthropic.com/v1/messages

   1	https://api.anthropic.com/v1/messages

7. Select POST as an HTTP Request Method
8. Inside the header, add: anthropic-version: 2023-06-01
9. In the Body content type, select  JSON(application/json)
10. Use this as the body:
    
    { "model": "claude-sonnet-4-6", "max_tokens": 1024, "messages": [ { "role": "user", "content": "{YOUR-Message}" } ] }

    1 2 3 4 5 6 7 8 9 10

    {   "model": "claude-sonnet-4-6",   "max_tokens": 1024,   "messages": [     {       "role": "user",       "content": "{YOUR-Message}"     }   ] }
11. Press on Preview to check the result.
12. You can use the Array filter to get the object you need, and you can use $.messages[*].content  to get only the message.
13. Click OK to save the configuration.
    

    Cloud.IA – JSON source request

Configure the Destination

1. Drag and drop a destination component (e.g., Trash destination) into the Data Flow.
2. Connect the output arrow from the JSON Source to the destination component.
3. Double-click the destination component and configure it to point to your target table or file.
4. Map the columns from the response to the appropriate destination columns
5. Click OK to save the destination configuration.
6. Execute the package and verify that the data extraction is working correctly.
   

   Cloud.IA – Final Result

Conclusion

You now have a secure and reliable connection between Zappysys SSIS and Cloud.IA. API Key authentication is simpler to set up with our HTTP connection. With this connection configured, you can build powerful data extraction, transformation, and loading workflows using Cloud.IA’s intelligence and automation capabilities are directly from your SSIS packages without writing any custom code.

Explore the full capabilities of the ZappySys SSIS PowerPack to optimize your data integration tasks. By applying this pattern, you can extend your solution to include additional transformations, data validation, error handling, and scheduling through SQL Server Agent.

Need Help?

If you encounter any issues, our support team is here to help:

1. Live Chat — Use the chat widget (bottom-right corner of this page)
2. Email — support@zappysys.com
3. Support Center — Visit the ZappySys Support Portal