Download‎ > ‎News‎ > ‎

Phoebus BI connects to SYBASE

posted Oct 19, 2009, 8:55 AM by   [ updated Mar 22, 2013, 7:47 PM by Eric Ngo ]
Sybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms. (Wikipedia)

Setup connection of Phoebus Business Intelligent to SYBASE:
Step1. Connect to SYBASE Service and  Select SYBASE table (Customer)

Build the connection to sybase. 

Select SQL Anywhere OLE DB 12. Enter Server Name/ 
Default username : dba.
Default password : sql

Remember to check Allow saving password. 

Click Select Table Button. Select customer table

Schema for the customer table is automatic discovered by Phoebus.

 Hit test button to see the content of table customer

Step2. Create Query.

Use Phoebus Query Designer. Create a new Query . Drag and drop column you want display. Add filter if you want.

Then Click Extract.

Voila!!!. You can add data from SYBASE  to any report or dashboard in Phoebus Intelligent.