Integrations
1. Overview
Mitra offers a comprehensive suite of options to integrate your platform with external systems, whether via database connections, file imports, or APIs. Below are the primary integration methods available:
2. JDBC Connection and CSV Files
Mitra enables seamless integration with external databases and CSV files directly through our connections tool in the database area.
2.1. JDBC Integration
JDBC (Java Database Connectivity): is the primary method for connecting Mitra with external databases.
Mitra Gateway: If the database is on a private network without an accessible IP, you can install the Mitra Gateway. It ensures secure connectivity between Mitra's cloud environment and your local database, allowing SQL queries to be executed even when the database is protected by firewalls.
2.2. CSV File Integration
For situations where the database is not accessible via a network, you can choose to import CSV files directly into Mitra.
CSV files can be used to create new tables or to load data into existing tables.
These integration options are ideal for connecting structured data to Mitra. For more details, refer to our documentation on JDBC and CSV Connections.
3. API and iPaaS Integration
Mitra also supports integration through APIs and iPaaS (Integration Platform as a Service), enabling bidirectional interaction with other systems.
3.1. Calling External APIs
"API Call" Step: Within Mitra actions, you can add a specific step to call external APIs. This allows your system to communicate directly with other services, sending or receiving data.
iPaaS Platforms: Mitra can be integrated with iPaaS platforms like Zapier, Make, and others. These platforms simplify workflow automation between Mitra and various external services.
3.2. Creating APIs in Mitra
Mitra enables you to create multiple API keys, each configurable with specific scopes that define which tables and operations (GET, POST, PUT, DELETE) they can access.
When creating an API key, you receive a URL and a token for authentication, allowing data to be sent and received based on the configured scopes.
For more details on how to use APIs in Mitra, refer to our documentation on APIs and iPaaS.