Skip to main content

​
Database Connection

BonData connects directly to your SQL Server database using standard connection credentials.

​
Step 1: Prepare Your Database

Ensure your SQL Server is accessible from BonData’s IP addresses. You may need to:
  1. Configure your firewall to allow connections on port 1433 (or your custom port)
  2. Enable TCP/IP connections in SQL Server Configuration Manager
  3. Ensure SQL Server authentication is enabled (mixed mode)
For security, create a dedicated read-only user for BonData: 
-- Create a login
CREATE LOGIN bondata_user WITH PASSWORD = 'your_secure_password';

-- Create a user in your database
USE your_database;
CREATE USER bondata_user FOR LOGIN bondata_user;

-- Grant read access
ALTER ROLE db_datareader ADD MEMBER bondata_user;

​
Step 3: Gather Connection Details

Collect the following information:
  • Host: Your database server hostname or IP address
  • Port: Usually 1433
  • Database: The name of the database to connect to
  • User: The username created above
  • Password: The password for the user

​
Step 4: Connect in BonData

Enter your connection details in BonData to establish the connection.

​
Required Fields

FieldDescription
HostDatabase server hostname or IP address
PortDatabase server port (default: 1433)
DatabaseName of the database to connect to
UserDatabase username
PasswordDatabase password
BonData supports encrypted connections using TLS. This is recommended for production environments.

​
Available Data

Once connected, BonData can sync:
  • Tables - All tables the user has SELECT access to
  • Views - Database views accessible to the user
  • Custom Queries - Run custom SQL queries to extract specific data