Connecting to a database allows you to integrate data directly from your database into CashCloud, providing seamless data synchronization.
Steps to Connect a Database
1.Navigate to Data Groups: Go to the Settings menu. Select Data Groups and then Integrations.
2.Select Database: Choose the Database option and click Connect.
3.Configure Database Settings: Select SQL Dialect: Choose the SQL dialect used by your database (e.g., MySQL, PostgreSQL). **Host: Enter the database host address. Port: Specify the database port number. User: Enter your database username. Password: Enter your database password. Database: Provide the name of the database. SQL Query: Enter the SQL query to execute, such as SELECT * FROM table.