IBM Db2 with Aqua Data Studio
Anil Mahadev
Oracle ACE PRO ? |Principal Cloud Architect (Oracle) @ IDERA Software | Database and Cloud Family of Tools | Multi-Cloud Architect - OCI | *All Views Are My Own and Do Not Represent My Employer*
Happy Friday Gang!!
Today I will showcase how we are able to connect to IBM Db2 in Aqua Data Studio.
[Note: This assumes that you have a working copy of IBM Db2 Linux Unix Windows running on your local machine / remote Db2 environment]
For the purposes of this Demo, I am using IBM Db2 Developer Edition which is free to use for non-production environments. I have used the db2sampl command to install the Db2 Sample database.
Fire up Aqua Data studio.
Hit Insert on your keyboard to Register a new Server
Now choose IBM Db2 LUW as shown below
Enter your Server Credentials.
Next Click Test connection
Next, let us verify the Server Support Information.
Right Click on your Server and choose Server Support Information.
Next, we will connect to the Db2 Server as shown below and expand MySchema
Awesome! Now let us visit the Query Builder
Finally, we will initiate a Data Model through the ER Diagram Generator
Congratulations! You have successfully connected your IBM Db2 LUW instance to Aqua Data Studio!
Have a Great Weekend everyone!