Each connection is required to have a Connection Name, Database Type, Agent.
Mandatory fields in all cases:
Connection name - This can be anything
Database type - This can be one of Oracle, PostgreSQL, SQL Server, or File
Agent - Manager_with_Agent
PostgreSql mandatory fields:
Host
Port (The default port for PostgereSql is 5432)
Username
Password
MySql mandatory fields:
Host
Port (The default port for MySql is 3306)
Username
Password
Oracle mandatory fields:
Host
Port (The default port for Oracle Database is 1521)
Service
Username
Password
File mandatory fields:
Output Directory Path