Intellistack
Intellistack (formerly Formstack) is a leading provider of no-code data capture and workflow automation solutions. Intellistack delivers both standalone productivity products—including form-building, document-generation, and eSignature software under its Formstack brand—and a market-first no-code process automation platform, Intellistack Streamline.
The project's central goal was to engineer the Data Fabric layer for Intellistack Streamline – a no-code process automation platform that enables connecting directly to users' data sources. The idea is to eliminate the need for retaining user data, which is critical for security-conscious industries like healthcare that must comply with governance regulations for data frameworks, such as PII (Personally Identifiable Information) requirements.
The existing system faced multiple limitations, specifically in handling complex, multi-record submissions with internal dependencies. For example, processing related entities, such as a patient, their visit, and associated prescriptions, atomically across different database types. On top of that, the solution had to manage a wide array of primary key strategies without manual configuration.
Java
Our team has been involved from the very beginning of the Data Fabric project for Intellistack Streamline, which launched publicly in June 2025. This initiative, best described as a no-code process automation platform, required a multi-faceted approach combining architectural design, core engineering, and ongoing feature development.
The core of the solution is a service provider interface that orchestrates real-time CRUD (Create, Read, Update, Delete) operations on users' arbitrary databases, ensuring data manipulation occurs on their side.
We built the platform using Java and Spring, and deployed it using Kubernetes. The team successfully developed integrations for numerous data sources, including PostgreSQL, MySQL, SQL Server, Oracle, MariaDB, Snowflake, Google BigQuery, Salesforce, Power BI, Dataverse, and more.
The team implemented data flow analysis, an approach borrowed from compiler theory, to handle complex insertions that involve multiple related records. This technique builds a dependency graph of the records to ensure they are inserted in the correct order within a single atomic transaction, correctly resolving all foreign key relationships. A type-mapping system was created to manage diverse data types across various databases and prevent data corruption.
We recognized that we couldn't build a perfect solution for every possible database structure. Instead, our engineers followed an 80/20 principle: we built a system that works flawlessly for the most common database schemas, while making the architecture flexible enough to easily create custom solutions for the rare, unconventional ones.
Janea Systems engineers created a system that effectively handles various primary key generation strategies, including auto-generated, natural keys, UUIDs, and custom sequences. The system infers the key type to provide a better user experience and ensure data can be inserted and referenced correctly.
Janea Systems' involvement transformed the client's ability to meet customer needs and opened up new market opportunities. The platform drastically reduced the time-to-market for new integrations. We delivered not just a product, but also the foundational knowledge and architecture for the client’s in-house team to continue building upon.
Ready to discuss your software engineering needs with our team of experts?