DocsConnect Database
Connect Data
Connect Database
Connect directly to a relational or document database. NNIPA reads the schema, profiles the tables, and keeps the connection available for querying and future ingestion.
Quick Start
- 1
Pick a connector
Choose your database type — PostgreSQL, MySQL, Oracle, SQL Server, or MongoDB.
- 2
Name the source
Give it a Source Name and, optionally, a Description.
- 3
Fill in connection details
Host, Port, Database, Schema, and the credentials NNIPA uses to connect.
- 4
Set advanced options (optional)
SSL Mode, Connection Pool Size, and Read-only mode are set to sensible defaults but can be adjusted.
- 5
Test & save
NNIPA verifies it can connect before saving. Once saved, tables are profiled and added to the Catalog automatically.
Connection details
HostHostname or IP address of the database server.PortDefaults to the standard port for the selected database type — e.g. 5432 for PostgreSQL.DatabaseName of the database to connect to.SchemaDefaults to public — change it if your tables live elsewhere.Username / PasswordCredentials NNIPA uses to authenticate the connection.Advanced options
SSL ModeControls whether the connection is encrypted. Require is recommended for production.Connection Pool SizeMaximum number of concurrent connections NNIPA opens to this database.Read-only modeRestricts NNIPA to read operations only — recommended for production databases.Good to know
- Use a read-only database user wherever possible.
- Credentials are stored encrypted and are never shown in plain text after saving.
- An already-configured database source can be reused as the base for a CDC connector.