In this third article about the Connectivity Agent we deep-dive into the details. We learn how to use the ICS Connectivity Agent in combination with an on-premises database. For more information about the architecture and installation of the agent I recommend to read these two articles first. This article continuous where the previous article about the installation ended.
Taking the Agent for a test drive
Now that the Connectivity Agent is installed, registered and running we can use the Agent to create connections to our on-premises applications and create integration on top of these applications.
Preparing the connection to the on-premises database
Now that we know the Agent is running we can make a connection to the on-premises database. For this example I use the HR sample schema that is part of my database installation. Navigate to the connections page of ICS and click on the “Create new Connection” button. My instance is running the latest 16.1.3 version. The “Create Connection” dialog now at lot nicer and user friendlier.
Now it’s time to configure the adapter connection. The configuration consists of the Connection Properties, the Security and the Agent Group to use. The Agent Group is required so you can’t connect to a database without it.
The connection properties includes the host ip/name of the database server. The port number the instance is running on and the SID and Service Name. The configuration needs both and not one or the other.
The credentials properties includes the username and password of the database schema user to use.
The Agent group settings holds the selected agent group to connect to when using this connection.
After configuring the database settings we need to test the connection. Click on the test button on the top-right corner of the page.
In preparation of my upcoming book about “Implementing Oracle Integration Cloud Service” the further content of this blog is redacted. If you like where this blog is going I can recommend reading the book when finished around October 2016.