SSIS ETL • SQL / BI Access • Connector Guides
Connect APIs and SaaS data to SSIS, Power BI, SQL Server, Excel, and more.
Automate SSIS ETL workflows, query REST and SaaS APIs from BI and SQL tools, and build reliable integrations that run inside your own environment — keeping your data, credentials, and execution under your control.
Explore the API Integration Hub• Not sure which fits? Ask an integration expert
- Fully functional 30-day trial
- Live support during your trial
- Runs in your environment
- 30-day refund window*
- 0+
- customers
- 0+
- countries
- 0+
- years in business
- 0+
- integration guides
Choose your path
Start with the tool you use today
Pick the closest starting point, then jump straight to the product or guide that fits your workflow.
Popular entry points for integration teams
Build SSIS ETL pipelines
Drag REST/JSON sources into SSDT. Schedule with SQL Agent or Azure-SSIS IR.
Avg. first package: same afternoon
Query APIs from SQL or BI
SELECT against REST/JSON live from Power BI, Excel, Tableau, SSMS, Python.
First DSN: under 15 minutes
Find my connector + tool
1,350+ step-by-step walkthroughs — OAuth, paging, SQL, full screens.
60+ connectors × 20+ apps
Talk to an integration engineer
Real engineer, not a BDR. Bring your OAuth, paging, and deployment questions.
Avg. response: under 2 hours
Core products
Two product lines. One practical integration platform.
Choose SSIS PowerPack for package-based ETL. Choose ODBC PowerPack for SQL, BI, reporting, and application connectivity.
SSIS PowerPack
Best for SSIS / ETL workflows
High-performance SSIS components and tasks for integrating APIs, files, cloud apps, databases, and SaaS platforms inside SSIS packages.
- 100+ drag-and-drop SSIS components and tasks
- REST, JSON, XML, SOAP, CSV, file, cloud, and database connectivity
- Ideal for scheduled ETL, migration, and workflow automation
- Full trial support included — chat, phone, email, web meeting
ODBC PowerPack
Best for SQL / BI / app access
ODBC drivers that let you query REST APIs, SaaS platforms, files, and cloud data from any ODBC/JDBC-compatible application using familiar SQL.
- Query APIs with SQL — SELECT from JSON, XML, REST, OData
- Works with Power BI, Excel, SQL Server, Tableau, Python, C#, Java
- Ideal for reporting, analytics, linked server, and app workflows
- Full trial support included — chat, phone, email, web meeting
Head-to-head
SSIS PowerPack vs ODBC PowerPack — the honest comparison
No fake-negative differentiators. Where they overlap, both say “Yes”. Where they diverge, the table tells you why.
Most teams pick one; some use both. ETL teams almost always start with SSIS PowerPack. BI & reporting teams almost always start with ODBC PowerPack. If your job spans both, talk to us — we’ll help you avoid double-buying.
| SSIS PowerPack | ODBC PowerPack | |
|---|---|---|
| Best for | Scheduled batch ETLSSIS packages, SQL Agent jobs, Azure Data Factory (SSIS IR), migrations | Live SQL / BI / app accessReports, dashboards, analytics queries |
| You build it in | SQL Server Data Tools (SSDT), Visual Studio | Power BI, Excel, Tableau, SSMS, Python, C#, Java |
| Components / drivers | 100+ drag-and-drop SSIS components | 50+ ODBC / JDBC / API drivers |
| REST / JSON / XML / SOAP | Included | Included |
| OAuth, paging, retries, throttling | Configuration, not code | Configuration, not code |
| Scheduling | SQL Agent / Windows scheduler / ADF triggers | Driven by host app (Power BI refresh, etc.) |
| Real-time querying | Near real-timeSQL Agent on a 1–5 min schedule into a staging table | Live SELECT against the APIfresh data on every query — no scheduling needed |
| Logging & error handling | Built into SSIS pipeline | Driver-level diagnostics + host app |
| Pricing | Per-host annual subscription — see SSIS pricing | Per-host annual subscription — see ODBC pricing |
| Fully functional trial | 30 days · with engineer pairing | 30 days · with DSN config help |
NEW API Integration Hub
Find the exact path from your source to your tool
1350+ practical walkthroughs help you choose the right connector, match it to SSIS, SQL Server, Power BI, Excel, Python, and more, then configure it without guessing.
From idea to working connection
Choose a data source. Choose an application. Get the exact setup guide.
Most API work starts with the same questions: Which connector do I need? Will it work in my tool? How do I set up OAuth, paging, fields, and queries? The Hub answers those questions before your team installs anything.
- 60+connectors
- 22applications
- 1350+guides
- Pick the sourceStart with SharePoint, Google Sheets, Jira, OneDrive, Outlook Mail, REST APIs, or any supported connector.
- Select your toolChoose SSIS, SQL Server, Fabric, Power BI, Excel, Tableau, Python, C#, Java, and more.
- Use the matched guideFollow screens and settings for auth, paging, columns, filters, SQL, and write-back.
- Ship with supportMove from guide to working workflow with SSIS PowerPack, ODBC PowerPack, and engineer help.
Connector spotlight
Pick a connector to preview its application walkthroughs
SharePoint Online
Read and write SharePoint sites, lists, document libraries, and files — without writing CSOM code.
Why it’s tricky without ZappySys: SharePoint OAuth, throttling (HTTP 429), and large-file chunked uploads. We handle all three as configuration.
Each application has its own walkthrough:
JDBC-ODBC Bridge
Connect ODBC applications to Java-based data sources using standard JDBC drivers (.jar) — no custom code.
Why it’s tricky without ZappySys: JVM classpath setup, driver version mismatches, and bridging two connection standards. Our bridge handles both sides.
Each application has its own walkthrough:
Google Sheets
Read and write spreadsheet tabs, ranges, and rows from SSIS, SQL, Power BI, and Excel — without Apps Script.
Why it’s tricky without ZappySys: Google OAuth scopes, sheet naming, and paging across large tabs. Driver handles all three as configuration.
Each application has its own walkthrough:
OneDrive
Sync OneDrive files and folders with your ETL, SQL, and BI workflows — without custom Microsoft Graph code.
Why it’s tricky without ZappySys: Graph OAuth, delta sync, and large-file uploads. We handle all three as configuration.
Each application has its own walkthrough:
Jira
Track, manage, and automate Jira issues, projects, worklogs, and comments from your ETL and BI stack.
Why it’s tricky without ZappySys: JQL paging, custom fields, and REST API rate limits. One SQL-friendly connector covers it all.
Each application has its own walkthrough:
Outlook Mail (Office 365)
Read, send, and manage Outlook Mail messages and folders from SSIS, SQL, and BI tools.
Why it’s tricky without ZappySys: Microsoft Graph OAuth, folder hierarchy, attachments, and bulk operations. Configured without custom code.
Each application has its own walkthrough:
HubSpot
Sync contacts, deals, tickets, and marketing events with your warehouse or BI tools.
Why it’s tricky without ZappySys: Pagination cursors, association expansion, custom-property schema drift. Driver normalizes all three.
Each application has its own walkthrough:
REST API (any)
Connect to any REST API on the planet — public services or your custom internal endpoints.
Why it’s tricky without ZappySys: OAuth 1/2, paging, custom headers, throttling, retries. All configuration, not code.
Each application has its own walkthrough:
Zendesk
Integrate tickets, users, organizations, and support metrics with your warehouse or BI tools.
Why it’s tricky without ZappySys: Cursor-based paging, side-loaded associations, and incremental sync. Driver normalizes all three.
Each application has its own walkthrough:
Choose your application
Connect to your data using the tools you already use
ETL platforms, databases, BI tools, spreadsheets, and programming languages — each with step-by-step integration guides in the API Integration Hub.
Application walkthroughs
Pick your destination, then follow the exact guide
Why teams choose ZappySys
Less custom API code. More integrations your team can actually support.
ZappySys gives data teams reusable connectors, SQL-friendly access, and visible configuration so production workflows are easier to build, debug, and hand over.
Speed
Go from API docs to working flows faster
Use ready-made SSIS components, ODBC drivers, and API tools instead of rebuilding authentication, pagination, parsing, and retries for every source.
Fewer prototypes stuck in script folders
API complexity
Handle the messy parts without hiding them
Configure OAuth, headers, paging, nested JSON/XML, custom endpoints, throttling, and write-back behavior in tools your team can inspect.
Clearer troubleshooting when APIs change
Adoption
Meet users where their work already happens
Connect from SSIS, SQL Server, Power BI, Excel, Tableau, Python, C#, Java, and other environments without forcing a new platform.
Lower training cost across mixed teams
Operations
Keep integrations maintainable after launch
Make authentication, mapping, scheduling, logging, and troubleshooting visible so workflows can be supported by the team, not only the original developer.
Better handoff, audits, and production support
Your data stays in your environment
Self-hosted integration tools for teams that need control
ZappySys is installed software, not a hosted SaaS data pipeline. Your packages, queries, credentials, and business data run inside your workstation, server, VM, or self-hosted environment.
- No customer data sent to ZappySysAll processing happens in your environment. ZappySys cannot access, transmit, or store your business data.
- Offline and firewall-friendlyUse offline activation. Run in air-gapped or restricted networks where cloud-hosted tools are not allowed.
- You control deployment and updatesNo forced automatic updates. Your IT team controls installation, upgrades, and change management.
- Credentials remain under your controlSecret fields are encrypted by default. Workflows run under the account you configure.
- GDPR-friendly architecture
- No data residency questions — nothing leaves your network
- AES-encrypted secrets at rest
- 10+ years on-prem, no breaches
Trial & purchase assurance
Try ZappySys with expert help from day one
You do not have to evaluate ZappySys alone. During your trial, our engineers can help with product selection, installation, OAuth, pagination, and troubleshooting your real workflow.
- Fully functional 30-day trialTest in your own environment with your own APIs, files, databases, and applications.
- Chat, phone, email & web meeting supportHelp from people who actually understand SSIS, ODBC, APIs, SQL Server, Power BI — not a script.
- Trial extension when more testing is neededNeed more time for internal testing or approval? Just ask.
- 30-day refund window for eligible new purchasesBuy with confidence. See refund policy for current terms.
Don’t just take our word for it
See why data engineers worldwide trust ZappySys
Useful tools, clear documentation, and responsive support — from a team that answers when you call.
“I submitted a support request and had someone logged in and fixing things within 2 hours.”
Barry Wilson
“The REST source is very powerful — the only thing I found I could use after trying components from major vendors.”
Jes Kirkup · KTC
“Whenever we run into an obstacle, ZappySys has a solution for us. We are so glad that we chose ZappySys PowerPack.”
Kevin Chen · Berricle
Our philosophy: integration software should be easier to start, easier to troubleshoot, and easier to support — while keeping enough technical control for real-world API, ETL, SQL, and BI work.
FAQ
Frequently asked questions
Don’t see your question? Ask an integration engineer — usually answered in under 2 hours during US business hours.
Product fit
Which product do I need — SSIS PowerPack or ODBC PowerPack?
Choose SSIS PowerPack if you build ETL packages in SQL Server Integration Services. Choose ODBC PowerPack if you want to query APIs and SaaS data live from Power BI, Excel, SQL Server, Tableau, or code (Python, C#, Java). Many teams use both. If you’re unsure, chat with an engineer before you start.
How do I get API data into Power BI or Excel?
Install ODBC PowerPack, create a DSN for your API or file format, then connect from Power BI or Excel like any other ODBC source — you can write SQL directly against JSON, XML, or REST endpoints. Step-by-step guides are available in the API Integration Hub.
Technical
Can I connect to any REST API, even a custom or internal one?
Yes. Both products include generic REST/SOAP drivers and components that work with custom endpoints, including OAuth 1/2, API keys, custom headers, pagination, throttling, retries, and nested JSON/XML responses.
Does ZappySys handle OAuth and pagination automatically?
Yes. OAuth token acquisition and refresh, paging strategies (offset, cursor, URL-based, header-based), and error retries are configuration options — no custom code required.
Does my data pass through ZappySys servers?
No. ZappySys products are installed software that run entirely in your environment. Your business data, credentials, and workflow execution never touch ZappySys infrastructure. Offline activation is available for restricted networks.
Trial & pricing
What is included in the free trial?
The 30-day trial is fully functional — no separate trial key required. You also get live technical support by chat, phone, email, or web meeting during evaluation, and you can request an extension if your team needs more testing time.
What if it doesn’t work out after purchase?
Eligible new purchases include a 30-day refund window. Combined with the fully functional trial and live support, you can evaluate with very low risk. See the refund policy for current terms.
How is ZappySys priced?
Both products use a simple per-host annual subscription — no row-volume metering, no surprise overages. See pricing or request a quote for multi-host or enterprise terms.
Start your trial with expert support
Download the product that matches your workflow
Build SSIS packages, query APIs from SQL and BI tools, or browse step-by-step connector guides. Contact us any time before or during your evaluation.
Find my connector in the Integration Hub•Talk to an expert first
- Fully functional 30-day trialNo separate trial key. Try with your real workflow.
- Live help during evaluationChat, phone, email & web meeting — not just a download link.
- Runs in your environmentBuilt for on-premises, hybrid, and security-conscious teams.
Talk to an integration expert
Real human support — before, during, and after your trial
Pick the channel that works for you. The same engineers who build SSIS PowerPack and ODBC PowerPack answer your questions.