> ## Documentation Index
> Fetch the complete documentation index at: https://docs.apinizer.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Supported Databases and Third-Party Integrations

> Apinizer platform provides connection support for a wide variety of database systems and third-party integrations. Database connections via JDBC and Mongo URI, message queue systems, search engines, logging systems, and other integrations are supported. All connections provide optimized performance with pool management.

## Supported Databases

Apinizer supports multiple database types via JDBC and Mongo URI. All database connections provide optimized performance with pool management.

### Relational Databases

<CardGroup cols={3}>
  <Card title="MySQL" icon="database">
    **Driver**: mysql-connector-j v8.0.33

    Connection support to MySQL databases via JDBC.
  </Card>

  <Card title="PostgreSQL" icon="database">
    **Driver**: postgresql v42.7.10

    Connection support to PostgreSQL databases via JDBC.
  </Card>

  <Card title="Oracle" icon="database">
    **Driver**: ojdbc11 v21.5.0.0

    Connection support to Oracle databases via JDBC.
  </Card>

  <Card title="Microsoft SQL Server" icon="database">
    **Driver**: mssql-jdbc v13.2.1

    Connection support to Microsoft SQL Server databases via JDBC.
  </Card>

  <Card title="IBM DB2" icon="database">
    **Driver**: jcc v12.1.3.0

    Connection support to IBM DB2 databases via JDBC.
  </Card>

  <Card title="Sybase" icon="database">
    **Driver**: jconn4 v15.7.0.4

    Connection support to Sybase databases via JDBC.
  </Card>
</CardGroup>

### NoSQL and Big Data Databases

<CardGroup cols={3}>
  <Card title="MongoDB" icon="database">
    **Driver**: Spring Data MongoDB

    Connection support to MongoDB clusters via Mongo URI.
  </Card>

  <Card title="Apache Hive" icon="database">
    **Driver**: HiveJDBC42 v2.6.30

    Connection support to Apache Hive databases via JDBC.
  </Card>

  <Card title="Apache Impala" icon="database">
    **Driver**: ImpalaJDBC42 v2.6.38

    Connection support to Apache Impala databases via JDBC.
  </Card>

  <Card title="Trino" icon="database">
    **Driver**: trino-jdbc v479

    Connection support to Trino databases via JDBC.
  </Card>
</CardGroup>

## Supported Third-Party Integrations

### Message Queue Systems

<CardGroup cols={3}>
  <Card title="Apache Kafka" icon="layer-group">
    **Version**: v3.4.0

    Apache Kafka message queue integration

    * Topic-based message sending and consumption
    * SSL/TLS security support
    * Message queue management for event-driven architectures
  </Card>

  <Card title="RabbitMQ" icon="inbox">
    **Version**: v5.16.0

    RabbitMQ message broker integration

    * AMQP protocol support
    * Queue and exchange management
    * Asynchronous messaging operations
  </Card>

  <Card title="Apache ActiveMQ" icon="server">
    **Version**: v5.12.3

    Apache ActiveMQ message broker integration

    * JMS protocol support
    * Queue and topic management
    * Message queue operations
  </Card>
</CardGroup>

### Search and Data Systems

<CardGroup cols={2}>
  <Card title="Elasticsearch" icon="magnifying-glass">
    Elasticsearch cluster integration

    * REST-based log, metric, and search data
    * Index and lifecycle management
    * Central cluster connections
  </Card>

  <Card title="LDAP/Active Directory" icon="users">
    **Version**: v2.0.2

    LDAP and Active Directory integration

    * SSL/TLS protected connection
    * Access with pool management
    * Integration with enterprise directory services
  </Card>
</CardGroup>

### Logging and Monitoring Systems

<CardGroup cols={2}>
  <Card title="Graylog" icon="file-lines">
    **Version**: v1.5.1

    Graylog GELF integration

    * Central log collection in GELF format
    * Transmission with TCP/UDP
    * Log aggregation and analysis
  </Card>

  <Card title="Syslog" icon="file-lines">
    Syslog protocol integration

    * Sending syslog messages
    * Central logging support
    * RFC 5424 standard support
  </Card>

  <Card title="Logback" icon="file-code">
    Logback logging integration

    * Log records with Logback framework
    * Log management and routing
    * Appender configuration
  </Card>

  <Card title="SNMP" icon="network-wired">
    **Version**: v2.8.18

    SNMP protocol integration

    * Sending SNMP traps
    * Network monitoring operations
    * SNMP v1/v2/v3 support
  </Card>
</CardGroup>

### Communication and File Systems

<CardGroup cols={3}>
  <Card title="SMTP/Email" icon="envelope">
    Email server integration

    * Notification via TLS-enabled SMTP
    * Alarm and bulk email sending
    * Email templates and management
  </Card>

  <Card title="FTP/SFTP" icon="folder">
    FTP/SFTP file transfer

    * FTP/SFTP/FTPS protocols
    * Secure file transfer
    * Directory management and automatic retry
  </Card>

  <Card title="Webhook" icon="link">
    HTTP webhook integration

    * HTTP webhook connections
    * Event-driven operations
    * REST API calls
  </Card>

  <Card title="Linux Script" icon="terminal">
    Linux script execution

    * Running commands on remote Linux servers via SSH
    * Script execution support
    * DevOps automation
  </Card>
</CardGroup>

## Connection Pool Management

All database connections are optimized with pool management:

<CardGroup cols={2}>
  <Card title="Performance Optimization" icon="gauge">
    * Connection performance is optimized
    * Resource usage is kept under control
    * Connection count can be limited
  </Card>

  <Card title="Configuration" icon="gear">
    * Minimum and maximum connection counts
    * Connection timeout settings
    * Connection test and validation
  </Card>
</CardGroup>

<Tip>
  Database connections are optimized and resource usage is kept under control thanks to connection pool management. This provides high performance and scalability.
</Tip>

## Connection Configuration

The following information is defined when creating a connection:

<AccordionGroup>
  <Accordion title="Basic Information">
    * **Connection Name**: Unique name identifying the connection
    * **Connection Type**: Database, message queue, etc.
    * **Description**: Descriptive information about the connection (optional)
  </Accordion>

  <Accordion title="Connection Information">
    * **Host/URL**: Server address or connection URL
    * **Port**: Connection port (varies by connection type)
    * **Database Name**: Database name (for database connections)
    * **JDBC URL**: JDBC URL for database connections
    * **Mongo URI**: Mongo URI for MongoDB connections
  </Accordion>

  <Accordion title="Authentication">
    * **Username**: Username for connection
    * **Password**: Password for connection (stored encrypted)
    * **Credential Usage**: Whether credentials will be used
  </Accordion>

  <Accordion title="Advanced Settings">
    * **Pool Settings**: Minimum and maximum connection counts
    * **Timeout Settings**: Connection and query timeout values
    * **SSL/TLS Settings**: Secure connection configuration
    * **Environment-Based Management**: Dynamic configuration with environment variables
  </Accordion>
</AccordionGroup>

## Usage Areas

Connections are used in various areas in the Apinizer platform:

<CardGroup cols={2}>
  <Card title="DB-2-API" icon="wand-magic-sparkles">
    Creating APIs from database

    APIs can be instantly created with DB-2-API using database connections.
  </Card>

  <Card title="Policies" icon="shield">
    Policies running database queries

    Queries can be run using database connections within policies.
  </Card>

  <Card title="API Integrator" icon="diagram-project">
    Task flows containing database operations

    Integration scenarios can be created using database connections in Task Flows.
  </Card>

  <Card title="Connectors" icon="plug">
    Connectors requiring database and system connection

    Connectors provide integration with different systems using connections.
  </Card>

  <Card title="API Traffic Logging" icon="file-lines">
    Sending API traffic logs to log systems

    Connections are used to send logs to systems like Elasticsearch, Graylog, Syslog.
  </Card>

  <Card title="Alarm and Monitoring" icon="bell">
    Sending alarms to monitoring systems

    Connections are used to send alarms and monitoring data to systems like SNMP, Syslog.
  </Card>
</CardGroup>

## Security

Connection information is securely stored in Apinizer's Secret Manager:

<CardGroup cols={2}>
  <Card title="Encryption" icon="lock">
    * Connection passwords are stored encrypted
    * Secure credential management
    * Environment-based security settings
  </Card>

  <Card title="Access Control" icon="shield">
    * Role-based access control
    * Connection test and validation
    * Audit logging support
  </Card>
</CardGroup>

<Warning>
  Connection information is sensitive data. Connection passwords and credentials are stored securely and encrypted. Appropriate permissions are required to access connection information.
</Warning>

## Next Steps

<CardGroup cols={2}>
  <Card title="Connections" icon="plug" href="/en/concepts/core-concepts/connections">
    Learn about the connection concept
  </Card>

  <Card title="Connectors" icon="plug" href="/en/concepts/core-concepts/connector">
    Learn about the connector concept
  </Card>

  <Card title="DB-2-API" icon="wand-magic-sparkles" href="/en/develop/api-proxy-creation/api-creator-db-api-creation">
    Creating API with DB-2-API
  </Card>

  <Card title="API Integrator" icon="diagram-project" href="/en/concepts/core-components/api-integrator">
    Learn about API Integrator component
  </Card>
</CardGroup>