If your organization uses a proxy server to access the internet, you can configure the HTTP proxy server authentication settings at design time or at run time to read data from or write data to Amazon Redshift.

Configuring HTTP Proxy Options at Design-Time

If your organization uses a proxy server to access the internet, you can configure the proxy server authentication settings in the jvmoptions.ini file to read data from or write data to Amazon Redshift.

Perform the following steps to configure the HTTP proxy options at design-time:

Ensure that you enable the proxy server settings from your web browser.

Access the jvmoptions.ini file from the following location:

<Informatica Installation Location>\clients\PowerCenterClient\client\bin

Add the following properties to the jvmoptions.ini file:

Property	Description
-Dhttps.proxyHost=	Name of the HTTP proxy server.
-Dhttps.proxyPort=	Port number of the HTTP proxy server.
-Dhttps.proxyUser=	Authenticated user name for the HTTP proxy server. This is required if the proxy server requires authentication.
-Dhttps.proxyPassword=	Password for the authenticated user. This is required if the proxy server requires authentication. The password is in plain text and not encrypted.

Configuring HTTP Proxy Options at Run-Time

If your organization uses a proxy server to access the internet, you can configure the proxy server authentication settings in the Administrator Console to read data from or write data to Amazon Redshift.

Perform the following steps to configure the HTTP proxy options at run-time:

Ensure that you enable the proxy server settings from your web browser.
In the Administrator Console, navigate to the PowerCenter Integration Service for which you want to set the proxy server settings.
Add the following custom properties as JVMOptions:
Property	Description
-Dhttps.proxyHost=	Name of the HTTP proxy server.
-Dhttps.proxyPort=	Port number of the HTTP proxy server.
-Dhttps.proxyUser=	Authenticated user name for the HTTP proxy server. This is required if the proxy server requires authentication.
-Dhttps.proxyPassword=	Password for the authenticated user. This is required if the proxy server requires authentication. The password is in plain text and not encrypted.
For example:
JVMOption1=-Dhttps.proxyHost=
<proxy_server_hostname>
JVMOption2=-Dhttps.proxyPort=8081
JVMOption3=-Dhttps.proxyUser=adminuser
JVMOption4=-Dhttps.proxyPassword=password