Custom JDBC Driver Development Case Study
Simba JDBC is a custom-built data connector designed to bridge the gap between REST APIs and analytics platforms. The client required a unified, secure, and scalable JDBC driver capable of reading API-generated JSON and exposing it as schema, tables, and columns that make API data behave like a fully query-able database.
Process maturity
CMMI Level 5
Information security
ISO 27001
Industry experience
25+ years
Global clients served
600+
Project Scope & Challenges
User requirement: connect BI tools to REST APIs with the same ease as connecting to MySQL or Postgres.
APIs return JSON, not relational tables, making it impossible for BI tools to interpret data directly.
Mapping complex & nested JSON structures into schema → tables → columns required custom logic.
Performance bottlenecks emerged due to large API payloads and inefficient full-response loading.
Lack of query pushdown led to excessive data transfer and slow analytics workflows.
Mapelcode’s Solution
Mapelcode engineered a robust and optimized JDBC driver using the Simba SDK, purpose-built for reading JSON responses from REST APIs.
Highlights of Our Solution
Built a custom JDBC driver that directly consumes REST API data.
Converted JSON nodes into relational structures (schemas, tables, columns).
Implemented on-demand loading so only required data is fetched during query execution.
Developed custom parsing and metadata detection for fields, types, hierarchies, and nested elements.
Optimized performance by eliminating unnecessary API calls and avoiding full payload downloads.
Ensured seamless integration with Tableau and other leading BI tools.
Tools & Technologies We Leverage
Java
SDK
JSON parsing
JDBC
SQL
Results & Achievements
Enabled BI tools to query API data as if it were a normal SQL database.
Reduced data retrieval times significantly with intelligent, on-demand loading.
Improved BI performance and scalability even with large and nested JSON structures.
Delivered a stable, low-memory driver ideal for enterprise workloads.
Unlocked real-time analytics on API-driven data sources.
Empowered seamless Tableau connectivity without requiring any backend database restructuring.
Enabled BI tools to query API data as if it were a normal SQL database.
Reduced data retrieval times significantly with intelligent, on-demand loading.
Improved BI performance and scalability even with large and nested JSON structures.
Delivered a stable, low-memory driver ideal for enterprise workloads.
Unlocked real-time analytics on API-driven data sources.
Empowered seamless Tableau connectivity without requiring any backend database restructuring.
Bring Your API Data to Life with Custom Connectivity Solutions
Whether you're dealing with REST APIs, JSON feeds, or complex data streams, Mapelcode builds custom JDBC/ODBC connectors that deliver real-time, high-performance access for analytics, BI, and enterprise applications.
From the Mapelcode Engineering Lab
The intelligence layer behind how Mapelcode teams plan, engineer, test, release, and govern enterprise software.
Keep exploring.
Let's build something like this.
Share your challenge and we'll put together the right team, stack, and approach — just like we did for these clients.