Forem: Daniel ZS

How to Read Apache Derby Data using ODBC with ZappySys (No-Code Guide)

Daniel ZS — Wed, 24 Dec 2025 23:00:37 +0000

Introduction

Apache Derby is a lightweight and reliable relational database, but integrating it with modern ODBC-based tools can be challenging. Using ZappySys ODBC PowerPack, you can connect to Apache Derby via ODBC and query data using standard SQL — without writing any custom code.

This guide shows the fastest setup.

Steps

1. Create an ODBC Data Source

Open ODBC Data Sources (64-bit) and create a new System DSN so the connection is available to all applications.

2. Select ZappySys JDBC Bridge Driver

From the driver list, choose ZappySys JDBC Bridge Driver and continue.

3. Configure Apache Derby Connection

Depending on your environment, configure one of the following:

Client/Server mode for remote Derby instances
Embedded mode for local Derby databases

Provide the JDBC connection string, driver class, and Derby JDBC driver file.

4. Test and Preview Data

Use Test Connection to validate the setup.

Then use the Preview tab to run a SQL query and confirm data access.

5. Save the Configuration

Once data is returned successfully, save the ODBC configuration and use it in any ODBC-compatible tool or ETL workflow.

Conclusion

By using ZappySys ODBC PowerPack with the JDBC Bridge Driver, you can seamlessly read Apache Derby data via ODBC. This approach enables SQL-based access, automation, and integration with reporting, ETL, and analytics platforms.

👉 Full tutorial with screenshots and configuration details

Fix: Device Limit Reached Error after IP Change in ZappySys ODBC

Daniel ZS — Thu, 18 Dec 2025 23:51:31 +0000

Problem

After changing the IP address of a virtual machine, you may start seeing a “License Error – Device Limit reached” message when using ZappySys ODBC. This usually happens after VM redeployment, network changes, or infrastructure updates.

Why This Happens

ZappySys ODBC uses Device-based Client Access Licenses (CALs), where each IP address is treated as a separate device.

By default:

One Device CAL is included
Each unique IP address counts as one device
When a VM IP changes, it is detected as a new device
The previous IP may still be registered against the license

If no additional Device CALs are available, the connection is rejected.

Solution (Quick Fix)

In most cases, you can resolve this issue by refreshing the license state:

Deactivate the existing ZappySys license
Activate the license again
Restart the ZappySys Application Gateway service

Restarting the gateway forces the license to reload and updates the active IP address.

When Additional CALs Are Needed

If your environment frequently changes IP addresses or uses multiple machines, you may need additional Device CALs to avoid this issue in the future.

Conclusion

This error is not caused by a misconfiguration, but by IP-based licensing behavior. Re-activating the license and restarting the Application Gateway resolves the issue in most single-VM scenarios.

👉 Full troubleshooting guide

How to Read Parquet Files in SSIS using ZappySys ODBC (DuckDB)

Daniel ZS — Thu, 18 Dec 2025 23:47:05 +0000

Introduction

Reading Parquet files directly in SSIS can be challenging without the right connector. Using ZappySys ODBC PowerPack with the DuckDB (Parquet) connector, you can query Parquet files using SQL and integrate them seamlessly into SSIS data flows.

This guide shows the fastest way to set it up.

Steps

1. Create an ODBC Data Source

Open ODBC Data Sources (64-bit) and create a new System DSN so SSIS can access it.

2. Select ZappySys JDBC Bridge Driver

From the driver list, choose ZappySys JDBC Bridge Driver and continue.

3. Configure DuckDB (Parquet)

Set the connection to DuckDB in memory mode and point it to the DuckDB JDBC driver file.

Test the connection to confirm everything works.

4. Validate Parquet Access

Use the Preview tab to run a SQL query against a Parquet file and confirm data is returned.

5. Create SSIS Project

Open Visual Studio, create a new Integration Services Project, and add a Data Flow Task.

6. Add ODBC Source

Inside the Data Flow, add an ODBC Source and create a new ODBC Connection Manager using the DuckDB DSN.

7. Query Parquet Data

Choose SQL Command or Table name, preview the data, and confirm the schema.

8. Run the Package

Connect the ODBC Source to any destination and execute the package to process Parquet data in SSIS.

Conclusion

By combining SSIS with ZappySys ODBC PowerPack and DuckDB, you gain a powerful and flexible way to read Parquet files using SQL. This approach enables automated ETL workflows, analytics pipelines, and data exports without complex custom code.

👉 Full tutorial with screenshots and advanced examples

Export SOAP Web Service Data to Excel using SSIS + ZappySys (Quick Guide)

Daniel ZS — Thu, 11 Dec 2025 23:04:47 +0000

Introduction

This quick guide explains how to extract data from a SOAP Web Service and export it to Excel using SSIS + ZappySys PowerPack. No coding required, fast setup, and ready for enterprise ETL workflows.

Steps

1. Add a Data Flow Task

Create a Data Flow inside your SSIS package.

2. Configure XML Source

Add XML Source (ZappySys) and point it to your SOAP endpoint (WSDL or API URL).

3. Apply Array Filter

Use a JSONPath expression (shown below) to extract the correct XML segment.

4. Validate the Response

Use Preview to verify SSIS can parse the XML structure.

5. Set Excel Connection

Add a ZS-EXCEL connection and test it.

6. Configure Excel Destination

Select the sheet, map fields from XML Source, and review the mappings.

7. Run the Package

Execute the Data Flow to export SOAP data into Excel.

Conclusion

With SSIS and ZappySys you can integrate SOAP APIs, parse XML dynamically, and send structured data into Excel with no custom code. Ideal for reporting, API-driven ETL, and scheduled automation.

👉 Full guide with screenshots

How to Install SSIS + ZappySys in Visual Studio 2026 (Quick Guide)

Daniel ZS — Thu, 04 Dec 2025 23:54:47 +0000

Introduction

If you're working with SSIS in Visual Studio 2026, you'll need the SQL Server Integration Services Projects extension. This short guide explains how to install SSIS support and enable ZappySys SSIS PowerPack components.

Steps

1. Install SSIS Extension

Open Extensions > Manage Extensions
Search for SQL Server Integration Services Projects
Install it and restart Visual Studio

2. Verify SSIS Templates

Go to Create a new project and confirm the Integration Services Project template is listed.

3. Install ZappySys SSIS PowerPack

Download the installer
Install and restart Visual Studio
If components don’t show up, change TargetServerVersion to SQL Server 2022

Conclusion

With SSIS + ZappySys PowerPack enabled, Visual Studio 2026 becomes a full data-integration environment ready for API, cloud, and file automation tasks.

👉 Read the full tutorial with screenshots

Does ZappySys Support Visual Studio 2026?

Daniel ZS — Fri, 28 Nov 2025 00:12:30 +0000

Introduction

A common question from SSIS users is whether Visual Studio 2026 is supported. The short answer: Yes — as long as Microsoft continues to support SSIS Projects in Visual Studio 2026.

Why It Works

ZappySys components depend on Microsoft’s SSIS Designer, provided by the SQL Server Integration Services Projects extension.

If the SSIS extension remains compatible with VS 2026, ZappySys tools will work without changes.

Conclusion

ZappySys SSIS PowerPack remains compatible with new Visual Studio versions as long as Microsoft continues to support SSIS.

👉 Full article here:

How to Fix Error 429: Too Many Requests in ZappySys (Quick Guide)

Daniel ZS — Fri, 28 Nov 2025 00:06:08 +0000

Introduction

When working with REST APIs via ZappySys SSIS/ODBC PowerPack, you might see this error:

429 – Too Many Requests

This means the API provider is throttling you because your package is sending more requests than the allowed rate limit.

Common Causes

Paginated or looping calls with no delay between requests
Parallel tasks hitting the same API too aggressively

Quick Fixes

Check the API’s rate-limit policy (e.g. X requests per minute)
Enable Throttling on the ZappySys JSON/XML Source to add a wait time between calls
Turn on Auto-Retry for HTTP/OAuth connections and handle status code 429
Add a small delay in For Loop / Foreach Loop containers to avoid back-to-back calls

These tweaks reduce API pressure and prevent your packages from failing due to 429 errors.

👉 Read the full troubleshooting guide with screenshots and detailed steps

How to Connect HubSpot in SSIS

Daniel ZS — Fri, 21 Nov 2025 02:45:44 +0000

Introduction

Learn how to connect HubSpot to SSIS using the ZappySys HubSpot connector to manage and integrate HubSpot data effortlessly.

Prerequisites

SSIS PowerPack: Download from the Customer Download Area or try the trial version.
HubSpot Account: Make sure your HubSpot account is ready.

Quick Steps

Log in to your HubSpot account and create a Private App.
Add a Data Flow Task in SSIS, and configure the HubSpot API Source.
Enter your AccessToken in the configuration and test the connection.
Preview the data from the HubSpot endpoint and save the configuration.

Conclusion

Connecting HubSpot to SSIS via the ZappySys connector simplifies HubSpot data integration into your workflows.

👉 Read the full tutorial here for detailed steps and examples

How to Update Custom Property Values in HubSpot with REST API Call

Daniel ZS — Fri, 21 Nov 2025 02:23:19 +0000

Introduction

If you need to update custom property values for HubSpot Contacts, Deals, or Accounts, here's a step-by-step guide to help you.

Add Custom Field in HubSpot

Navigate to your Contact Properties in HubSpot.
Click on Manage Properties and select Create Property.
Choose the appropriate field type and options (e.g., dropdown, string, number).

Update Custom Fields Using ODBC

You can update custom fields using either HubSpot's API or an ODBC Driver. Example for updating a custom field:

UPDATE Contacts SET firstname = 'Brian-Upd', lastname = 'Halligan-Upd', custom_number = 12.12 WHERE Id = 51

Common Issue: Dropdown Property Error

If you try to set a dropdown value not in the allowed list, you'll get a validation error. Always ensure the value is part of the predefined options.

👉 Read the full tutorial with examples and screenshots

How to Connect HubSpot to Power BI Using ODBC (Quick Guide)

Daniel ZS — Fri, 14 Nov 2025 13:43:41 +0000

Introduction

If you want to bring HubSpot data into Power BI, the ZappySys ODBC API Driver makes it easy to connect, query, and refresh HubSpot objects directly inside Power BI—without Python scripts or manual exports.

Key Steps

Create a HubSpot Private App and get your token
Create an ODBC DSN using the ZappySys API Driver
Select the HubSpot connector and test the connection
Open Power BI → Get Data → ODBC and pick your DSN
Load tables or write SQL queries for custom data retrieval

Example: Loading Data in Power BI

Use Get Data → ODBC, choose your DSN, select HubSpot tables, and click Load to start building dashboards.

Conclusion

This fast setup lets you analyze HubSpot metrics in Power BI with refreshable, query-powered dashboards.

👉 Read the full tutorial with screenshots:

https://community.zappysys.com/t/how-to-connect-hubspot-in-power-bi/405

How to Reinstall ZappySys ODBC PowerPack

Daniel ZS — Fri, 14 Nov 2025 12:33:58 +0000

Introduction

If you need to reinstall the ZappySys ODBC PowerPack due to a system upgrade, corrupted installation, or migration, follow this quick guide to safely uninstall and reinstall the PowerPack.

Steps

Check the installed version by following this guide.
Download the installer from this page.
Uninstall via Control Panel → Programs and Features.
Reinstall by running the installer and following the setup wizard.
Verify installation in ODBC Data Source Administrator and confirm your license.

Conclusion

Reinstalling the ZappySys ODBC PowerPack ensures a clean installation and resolves common issues.

👉 Read the full tutorial here for more details

How to Reinstall ZappySys SSIS PowerPack

Daniel ZS — Fri, 14 Nov 2025 12:28:24 +0000

Introduction

Sometimes, you may need to reinstall the ZappySys SSIS PowerPack, whether due to an upgrade, corrupted installation, or migration. This quick tutorial explains the steps to safely uninstall and reinstall it.

Steps

Confirm the PowerPack version: Check which version is installed by following this guide.
Download the installer: Get the latest version from this page.
Uninstall the PowerPack: Go to Control Panel → Programs and Features, find SSIS PowerPack, and click Uninstall.
Reinstall: Run the installer and follow the setup wizard steps.
Verify installation: Ensure the components appear in the SSIS Toolbox and confirm your license in the License Manager.

Conclusion

Reinstalling the ZappySys SSIS PowerPack is a simple process that ensures your components are correctly registered and your license remains active.

👉 Read the full tutorial here for more details