--- title: Database Connection slug: lowcode-en/database-connection description: Learn how to create a database connection in Low Code with this comprehensive document. Understand the parameterization aspect of Low Code and the significance of a database connection for working with business objects. Follow step-by-step instructions fo docTags: createdAt: 2023-01-04T11:59:47.000Z --- The main purpose of **Low Code** is parameterization, meaning there will always be a way to handle and manipulate the screen. Therefore, it is worth mentioning that nothing in **Low Code** is fixed. To work with a database, a connection to the database is required, especially when dealing with business objects. This connection is presented as follows: ![](https://api.archbee.com/api/optimize/pu5VMc-2TW3GQX4ly5Xp7/5m0sGd8n-ceXSMu_Iqr7Q_image.png) :::hint{type="info"} šŸ–Š **Note****: **All database connections can only be related to the three types mentioned in [Database](docId:2NSIigDjeZAj0_zFZsXbt) `Microsoft SQL Server`, `Oracle Database` , `PostgreSQL`, which in turn are necessary for the correct operation of business objects. However, Low Code offers integration with any other database through the [Integration Flow](docId:5zgVizRrsEhN00CclsOnP). ::: ## Procedure To create a database connection: - [x] You must have Infrastructure access to this database. Physical access (if it is virtual, it must be published), among other items, must be configured by Infrastructure. ![](https://api.archbee.com/api/optimize/pu5VMc-2TW3GQX4ly5Xp7/7_Vjt7z6pgwDhRv7F2A1j_image.png) | **Campo** | **DescriĆ§Ć£o** | | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------- | | **Nome** (**\***)** ** | Insira o nome sem espaƧamento | | **DescriĆ§Ć£o** (**\***) | Coloque uma descriĆ§Ć£o | | **Tipo** (**\***) | Selecione entre **conexĆ£o JNDI** ou **conexĆ£o direta** | | **Nome do Datasource** (**\***) | Dependendo dos tipos de conexƵes que colocar, entre a conexĆ£o JNDI ou direta, duas opƧƵes de bancos de dados serĆ£o exibidas. | Fields with an asterisk (**\***) are mandatory. ### JNDI Connection Shows options that are configured in the application container. It will also depend on the Infrastructure team to perform the necessary configurations. :::BlockQuote ***Example*****: **Front Manager Data Source (frontmanager) ::: In the case of the **Default Tenant**, it is the Tenant or the database connected to this URL: [https://frontmanager.apps.centralit.com.br/lwc/page/DATABASE\_CONNECTION](https://frontmanager.apps.centralit.com.br/lwc/page/DATABASE_CONNECTION) Check [Tenant](https://docs.citsmart.com/hyper/tenant-espaco-de-cliente) for more information. ![](https://api.archbee.com/api/optimize/pu5VMc-2TW3GQX4ly5Xp7/GwrSFpkd5mIF4HklL7Jpi_image.png) Click "**Save**" after completing. ### Direct Connection The other type of connection refers to the **direct connection**. ![](https://api.archbee.com/api/optimize/pu5VMc-2TW3GQX4ly5Xp7/FmbQZ3AnuUAV2OFE7iv21_image.png) | **Campo** | **DescriĆ§Ć£o** | | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Nome** (**\***)** ** | Escreva um nome sem espaƧamento | | **DescriĆ§Ć£o** (**\***) | Insira uma descriĆ§Ć£o | | **Tipo** (**\***) | ConexĆ£o direta | | **Path JDBC** (**\***) | Ɖ possĆ­vel escrever livremente a URL de conexĆ£o, o usuĆ”rio, a senha e o esquema, desde que tenha acesso ao banco de dados.
**Exemplo: **`jdbc:postgresql://localhost:5432/hyperplataform` | | **UsuĆ”rio** (**\***) | Selecione usuĆ”rio do banco de dados | | **Senha** (**\***) | A senha do usuĆ”rio do banco de dados | | **Esquema** (**\***) | Insira o esquema das tabelas do banco de dados | Fields with an asterisk (**\***) are mandatory. :::hint{type="info"} šŸ–Š **Note:** All passwords entered in Low Code screens are encrypted at the source and are encrypted in both directions (from the server to the browser and vice versa). ::: :::hint{type="warning"} āš ļø **Attention!** Regarding the user**\***, if you enter a user that has not been previously registered (that does not exist), Low Code will attempt to establish the connection, and consequently, it will time out because it will not be able to connect. The timeout depends on the database configuration. Also, you must use the necessary credentials to be able to connect to the database. :::