14. External Connections

An External Connection lets you define an connection to an external database.

External Connections are used by a number of the Integrationthat Noojee Campaigner supports.

Connections to an external database are made via JDBC and as such an appropriate JDBC driver must by loaded into the Noojee Campaigner backend.

Currently MySQL and Microsoft SQL Server are supported however support of additional databases can be easily facilitated.

The External Connection can also be used to define the connection properties to an external Web Service.

Field	Description
Name	A unique name for this External Connection
Host	The FQDN or IP address of the host that the external database or web service runs on.
Schema	Were the Type is a database then then Schema is the database name that is to be connected to. For a Web Service this field should be left blank.
Username	The username to authenticate to the external database or web service.
Password	The password to authenticate to the external database or web service.
Type	The type of external connection being made.

Field usage:

Type	Description	Host	Schema	Username	Password
MSSQL	Connect to an MS SQL server instance	Host name of the server	Schema	Username	Password
MYSQL	Connect to an My SQL server instance	Host name of the server	Schema	Username	Password
WEB_SERVICES	Web Services	Host name of the web service	N/A	Username	Password
SECURE_PAY	Secure Pay Gateway	N/A	Secure Pay Service URL	Username	Password
INFUSION_SOFT	Infusion Soft OAuth	Host Name of Infusion Soft service	N/A	Username	Password
DNC_LOOP_BACK	DNC Testing	N/A	N/A	Username	Password
DNC	DNCR Connection	DNCR Host name	N/A	Username	Password