Connect Microsoft Synapse Spark to BI and analytics apps with Simba ODBC and JDBC drivers for fast SQL access to Synapse Spark data.
Microsoft Synapse Spark gives you a fully managed Spark engine inside the Azure Synapse Analytics service. Analysts love the flexibility, but application vendors and integrators need a redistributable, standards-based driver to surface that data in the tools their customers already use.
What is Microsoft Synapse Spark? It is an enterprise analytics service that accelerates time to insight across data warehouses and big data systems. It integrates Apache Spark, the most popular open source big data engine used for data preparation, data engineering, ETL, and machine learning.
Why Simba?
Microsoft supplies a free driver for personal use; it is not licensed for redistribution. Simba delivers a fully supported, ODBC and JDBC driver that you can embed in your products.
Simba translates ANSI SQL into Spark SQL, pushes filters and joins to the Synapse Spark cluster, and streams results back with minimal latency.
Built-in Azure AD authentication, SSL, and FIPS-ready encryption meet enterprise security demands.
Simba turns Synapse Spark into a drop-in data source for BI dashboards, custom applications, data-integration platforms, and embedded analytics—all without writing a single line of Spark code. Legal Usage (note: provided by legal, do not change) Export Control Notice Statement: You may not use or otherwise export or reexport insightsoftware (INSW) products except as authorized by United States law and the laws of the jurisdiction in which the INSW products were obtained. In particular, but without limitation, INSW products may not be exported or re-exported into any U.S. embargoed countries or to anyone or entity on the U.S. Treasury Department's list of Specially Designated Nationals or the U.S. Department of Commerce Denied Person’s List or Entity List. By using INSW products, you represent and warrant that you are not located in any such country or on any such list. You also agree that you will not use the INSW product for any purposes prohibited by United States law, including, without limitation, the development, design, manufacture or production of missiles, nuclear, chemical or biological weapons.
Microsoft’s free Synapse Spark driver cannot be packaged with commercial software, blocking ISVs from shipping Synapse Spark-ready apps. Simba offers a royalty-free licensing model that lets you embed the driver in any commercial or SaaS product.
Without a standards-based ODBC or JDBC layer, teams build fragile REST integrations that delay go-live dates. Simba provides Drop-in ODBC/JDBC connectivity that lets apps, ETL tools, and custom applications use SQL to query Synapse Spark from day one.
Drivers from an unreliable third party can lack pushdown and enterprise authentication, leading to slow queries and security questions. Simba brings 30 years of experience providing drivers at an enterprise level for some of the largest players in the data and analytics space.
Ship Synapse Spark-enabled features in weeks, not months. Simba’s redistributable ODBC/JDBC driver installs in minutes, eliminates custom REST code, shortens QA cycles, reduces support tickets, and lets product teams focus on value-add features instead of plumbing.
Simba pushes filters, joins, and aggregates into Synapse Spark, streams results efficiently with pagination, and minimizes data movement. Faster dashboards, lower cloud charges, and reduced cluster CPU mean more concurrency for every workload.
Native Azure AD, and SSL/TLS with optional FIPS-validated crypto protect data in flight. Simba’s 30-year track record powering Fortune 500 analytics stacks gives architects confidence in auditability, long-term support, and regulatory readiness.
Simba Synapse Spark drivers give BI, integration, and custom apps live SQL access to Microsoft Synapse Spark tables—no separate ETL or custom APIs, just standard ODBC or JDBC.
Synapse Tables
Spark SQL Queries
Cross-Platform Apps
SQL Access via ODBC and JDBC – Query Synapse Spark from Power BI, Tableau, Excel, Java, Python, and more.
ODBC 3.8 and JDBC 4.2 Compliant – Provides 32- and 64-bit ODBC 3.8 and JDBC 4.2 compliant connectivity for Windows, Linux, and macOS platforms.
Query Pushdown Optimization – Executes joins, filters, and aggregations inside Spark for maximum speed.
Azure AD Support – Integrates with enterprise identity providers.
Secure Transport – TLS 1.2+ with FIPS-ready encryption modules.
High-Throughput Fetch & Pagination – Streams large result sets without exhausting memory.
FIPS Compliance & Enterprise Support – Meets strict security and compliance standards, ensuring trusted data access for regulated industries.
Departmental, Enterprise, and OEM Licensing Options
Cross-Platform Compatibility – Compatible with multiple platforms, including Windows, Linux and macOS.
Compatible with Microsoft Synapse Spark: Fully compatible with the Spark 3.5 version.
32- and 64-Bit Application Support: Works seamlessly with both 32-bit and 64-bit applications.
ODBC and JDBC Compliance: Adheres to the ODBC 3.8 and JDBC 4.2 specifications for standardized database connectivity.
ANSI SQL-92 Support: Supports the ANSI SQL-92 standard for SQL compliance.
Unicode Support: Fully supports Unicode for international character sets and data.
FIPS-Ready Cryptography
