Article
Muhammad Waseem · Sep 28 1m read

Connecting to Caché with Appeon PowerBuilder by using ODBC

https://www.appeon.com/products/powerbuilder

Appeon PowerBuilder is an enterprise development tool that allows you to build data-driven business applications and components.
It is one of a suite of Appeon products that together provide the tools to develop client/server, Web, mobile, and distributed applications.
 

In this article I will show the steps to connect to Caché with Appeon PowerBuilder by using ODBC

Step1 :
Make sure ODBC Driver option is selected while installing IRIS

 

Step 2:
Configure ODBC IRIS Data Source by using ODBC Data Source Administrator 

 

Step 3: Configure InterSystems ODBC Data Source

 

Step 4: Test the connection (make sure IRIS instance is running)

 

Step 5: 
From PowerBuilder open Database Profiles, Select ODB ODBC from the list and click New... button

 

Step 6: 
Select Data Source "IRISHealth User" which we created by using ODBC administrator



Step 7: Test the connection under Preview tab by clicking Test Connection button

 

Congratulation! We have established successful connection to Caché
Now we
 can view Tables and data by using PowerBuilder database painter



Thanks

40
1 0 0 168
Log in or sign up to continue