Step 3: Define database connections (Source and Destination)

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 - this will be located on the Accelario app host server