Connecting to Databases

This guide shows you how to quickly connect Coginiti to the most common database types. For comprehensive connection setup including JDBC driver management, authentication methods, and troubleshooting, see the Complete Database Connections Guide.

PostgreSQL

Basic Connection Setup

1. Open connection settings in your Coginiti project
2. Select PostgreSQL as your database type
3. Enter connection details:
   • Host: Your PostgreSQL server hostname or IP address
   • Port: Default is 5432 (change if your server uses a different port)
   • Database: The name of your PostgreSQL database
   • Username: Your PostgreSQL username
   • Password: Your PostgreSQL password
4. Test the connection by clicking "Test Connection"
5. Save the connection once the test succeeds

Adding SSL Security

To enable secure connections:

1. Check "Use SSL" in the connection settings
2. Select SSL mode based on your security requirements:
   • require: Basic SSL connection
   • verify-ca: Verify certificate authority
   • verify-full: Full certificate verification
3. Test and save the updated connection

MySQL

Basic Connection Setup

1. Open connection settings in your Coginiti project
2. Select MySQL as your database type
3. Enter connection details:
   • Host: Your MySQL server hostname or IP address
   • Port: Default is 3306 (change if your server uses a different port)
   • Database: The name of your MySQL database
   • Username: Your MySQL username
   • Password: Your MySQL password
4. Test the connection by clicking "Test Connection"
5. Save the connection once the test succeeds

Troubleshooting Common Issues

If you get a connection timeout:

1. Go to Advanced Settings in the connection dialog
2. Increase the connection timeout value (try 30 seconds)
3. Test the connection again

If you get an authentication error:

1. Verify your MySQL user has the necessary permissions for the database
2. Check that the user can connect from your Coginiti server's IP address
3. Ensure the MySQL user account is not locked

SQL Server

Basic Connection Setup

1. Open connection settings in your Coginiti project
2. Select SQL Server as your database type
3. Enter connection details:
   • Host: Your SQL Server hostname or IP address
   • Port: Default is 1433 (change if your server uses a different port)
   • Database: The name of your SQL Server database
   • Username: Your SQL Server username
   • Password: Your SQL Server password
4. Test the connection by clicking "Test Connection"
5. Save the connection once the test succeeds

Authentication Methods

Coginiti Team and Enterprise use standard SQL Server authentication:

1. Use SQL Server authentication with username and password
2. Ensure the SQL Server user has appropriate database permissions
3. Test the connection to verify credentials work
4. Save the connection once authentication is successful

Note: Windows Authentication is not supported in Coginiti Team or Enterprise editions.

Need More Help?

For detailed information including:

• JDBC driver management and custom uploads
• Advanced authentication methods (AWS IAM, SSO, etc.)
• SSL/TLS configuration
• Platform-specific setup (Redshift, Snowflake, BigQuery, etc.)
• Comprehensive troubleshooting
• Security best practices

See the Complete Database Connections Guide.