Database Proxy
  • 1 minute to read
  • Dark
    Light
  • PDF

Database Proxy

  • Dark
    Light
  • PDF

Article Summary

This article contains detailed information about the function and purpose of using a Database Proxy at senhasegura platform.

Proxy Database connection

A database proxy is a type of custom database reverse proxy. It takes requests from clients such as web applications and forwards them to a database server using database-specific settings.

Caution

The Database Proxy is limited to 2.000 simultaneous connections. This limit can be changed, but this means a significant increase in memory provisioning, considering each slot uses 64kb of memory. To change this limit, reach out to the senhasegura support team.

Using at senhasegura platform

At senhasegura, the Database Proxy will be able to perform a session from a given database management system, performing the proxy between the database and the session.
Allowing the use of an SQL client to execute sessions with the following functions:

  • Query filters.
  • Notifications.
  • Audit.

The proxy database will have new connectivity types for credentials, such as:

  • MS SQL Server.
  • PostgreSQL.
  • Oracle.

These are currently the databases approved by senhasegura.

DatabaseVersionClient
Microsoft SQL Server*Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64)SQL Server Management Studio 19.1.56.0 and DBeaver 23.1.0
PostgreSQLPostgreSQL 15.3PG Admin 4 v7.3 and DBeaver 23.1.0
OracleOracle Version 19.0.0.0.0SQL*Plus Release 21.0.0.0.0, SQL Developer Version 23.1.0.097 - Build 097.1607 and DBeaver 23.1.0
Attention

*Due to driver compatibility, the Database Proxy can’t be used with versions prior to SQL Server 2012.

In future versions, other databases will be added.

Important

From version 3.31 onwards, the Database Proxy is automatically configured and is ready to be used. If your database uses specific port numbers different from the default number, access the documentation How to modify Database Proxy port number to make the change.


Was this article helpful?