Skip to main content

Trillo Workbench

Build applications on Google Cloud in half the time and at a fraction of the cost with Trillo Workbench!

Trillo Workbench is a middleware Operating System that sits in your Google Cloud Platform (GCP) environment and manages the DevOps work for you. You write the frontend app code, Trillo Workbench configures and manages the backend GCP infrastructure.

How Trillo Workbench Works

Trillo Workbench is a server-side low-code platform that runs as a cluster of microservices on Kubernetes in your VPC environment. It’s fully scalable and customizable to handle heavy enterprise-level production workloads.

Trillo Workbench saves you enormous development time and cost by providing common services out-of-the-box such as: authentication, role-based access control, a database layer as an API, file management of buckets, scheduled jobs, tasks, audit logs, and many additional services. All of these are integrated into the Workbench platform. Focus on your app, not backend DevOps.

Trillo Workbench is an API server. Using a simple API, cloud infrastructure is abstracted away, allowing you to write other clients or serverless functions remotely in your IDE on your computer.

Trillo Workbench UI allows you to enter database schemas, roles, schedules, serverless functions, workflows, etc. and then Workbench manages the backend cloud infrastructure for you.

Once you define the data model, roles, and policies using the Trillo Workbench UI, you are ready to write application logic as serverless functions. They plug in as APIs, event-driven triggers, long-running workflows, and scheduled tasks.

Write custom plugins to integrate with your external services and processing (we also offer a number of pre-built plugins).

Trillo Workbench Architecture

Build Amazing Apps with Workbench

Data warehousing in the cloud

Use BigQuery/Cloud SQL to integrate with enterprise applications such as NetSuite, Workday, Salesforce, and Electronic Medical Records (EMR). Workbench can automatically sync the data from source to warehouse (with better performance than most 3rd-party connectors).

File sharing & Storage management

Create large-scale storage and organization of files from multiple users/companies. Implement access control of files and folders with file sharing and SFTP (perfect for media, analytics, and health insurance companies).

OCR & parsing using Document AI

Upload documents as images and PDFs. Preprocess them for OCR or text processing using Google’s Document AI. Post-process and store in database and provide an API that integrates with enterprise workflow.

Google Merchant Center feed

Keep your Google Merchant Center catalog continuously updated with your current products from your e-commerce store.

DICOM & FHIR

Provide multi-tenant, multi-region images and health record management, including on-premise gateways to upload from PACs server securely.

AI/ML model serving

Use Workbench to process interactive or batch data files for image processing, object detection, and processing documents for NLP.

Frequently Asked Questions

What Use Cases Are Not Supported by Trillo Workbench?

Some application types are better served by using cloud-native tools. For example:

  1. Remote File System: Replicating a shared remote file system is a use case that requires a network and operating system-level tools. Therefore, it is not a valid use case for the Trillo Workbench.
  2. AI/ML Model Training: Trillo Workbench is not used as an MLOps platform. Instead, Vertex-AI or KubeFlow is a better AI/ML training pipeline platform. However, Trillo Workbench works well for ingesting training data and preprocessing it.
  3. Streaming BigData Pipeline: Kafka or Google’s Pub/Sub and DataProc work well for big-data processing pipelines.

Is Trillo Workbench Secure?

Yes! Workbench runs on a Kubernetes cluster that is configured and runs in your VPC environment. All network communication between Workbench and your backend GCP infrastructure services (databases, file storage, functions, etc.) stays within your environment.

Behind the scenes, Workbench uses native cloud services. It follows the best practice recommended for each service. The end result is the same as if you built it from the ground up yourself, except that you save up to 90% of the cost and time.

Can Workbench autoscale and remain performant under heavy loads?

Absolutely! Workbench is built on Kubernetes using microservices. It can automatically scale up (or down) as needed to handle large loads while still maintaining excellent performance.

We have helped many enterprise-level customers build real-world applications that consistently experience heavy usage loads.

What application services does Trillo Workbench Provide for an application?

Metadata Service – application metadata such as database schemas, configuration files, SQL query templates, schedules, and workflow definitions.

Data Service – creates, alters, and operates on the database tables based on meta properties specified for each table and its columns. Using meta properties, it imposes access control rules (for example, a certain role can access a certain column). It provides CRUD, batch operations, and query APIs.

Storage Service – manages files using Google Cloud Storage, including uploading, downloading, sharing, and supporting folder/file operations such as mode, delete, and copy.

Function Service – Function Service dynamically compiles and executes plug-in code. In the production environment, it can use dynamic compilation with a jar file.

Workflow Service – executes functions in the background as tasks or workflows consisting of multiple steps. Developers can define workflows graphically. Alternatively, a function can implement a workflow by controlling the execution of multiple steps. Each step, in turn, is a function.

Scheduling Service – schedules a function or workflow for the periodic execution.

Firebase Notification – Workbench provides out-of-the-box integration with Firebase Notification for applications requiring a real-time push to a UI.

Audit Logging – Audit Logging is a powerful feature of Trillo Workbench. It tracks workbench activities performed by a client program or backend tasks. Standardizing audit log records provides easy search and filtering of a particular activity. It serves multiple purposes – troubleshooting, operations management, and compliance.

User Management – user management and authentication using a database or Google Cloud identity platform. Using SAML and OIDC, it can integrate with external authentication systems.

API Gateway – A client can access Trillo Workbench services using an in-built API gateway. The API gateway is oauth2 compliant.

Git Integration – Trillo Workbench uses a database for storing metadata. It retains multiple versions of metadata. It also integrates with a git repository so an admin can push metadata and plug-in code to a git-repo. A workbench instance running in a different environment can pull code from Git. Thus a typical Trillo Workbench deployment uses Git for managing development to QA to production code deployment processes.

Can I build my application GUI using Workbench?

No. Trillo Workbench is not a UI-building tool. We suggest you build your UI using other open-source technologies and use Trillo Workbench as a server using APIs.