Host IP or DNS Name

The internet provider address or the domain name/system name of the remote database, e.g., ec2-34-210-141-104.us-west-2.compute.amazonaws.com or simply an IP address such as 27.202.15.159

Port Number

The port number identifying the location of the remote database. Often combined with the IP or DNS name to provide access to a set of data, e.g., 1521

Instance/Service Name

Multiple instances can be associated with a single database service. This field holds the specific instance or service name to point to the required source data, e.g., sw_project1

Remote Schema Name

A schema is a grouping of database objects (tables, views, etc) within a database. It is a way of logically partitioning objects within a database. With the proper permissions, tables in multiple schemas can be accessed with one database connection, e.g., swadmin_ovc_3

Remote Table Name

The name of the table within the Schema defined in Remote Schema Name, e.g., FITTINGS, POLE, PIPE, etc.

DB User

The user identification key that provides secure access to the Source being defined, e.g., SWADMIN123

DB Password

The password associated with the DB User key that provides secure access to the Source being defined, e.g., SWPWD123