Download‎ > ‎

News


Phoebus BI connects to SYBASE

posted Oct 19, 2009, 8:55 AM by Giang Hương Tô   [ updated Mar 22, 2013, 7:47 PM by Ngo Eric ]

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.

Phoebus Inventory Control

posted Oct 19, 2009, 8:53 AM by Ngo Eric   [ updated Mar 22, 2013, 7:53 PM ]

Phoebus provides the capability to manage inventory, ensuring full visibility of product, intermediate and raw material items, while also delivering lot and batch control. The Inventory module comprises Inventory Management and Inventory Traceability, with additional options, Costing, delivering Landed Costing and Cost Analysis, and Product Profiles. The solution enables greater control over inventory levels, without forfeiting essential customer service levels. 

Material and Inventory Item Catalog

Keep your assets organized and classified to multiple catgories.

Separate purchased stock, consignment stock, rental stock and non-inventory stock. Multi costing for one item.

Classified item by condition : A- brand new. B – 75%. C – 50%. D – junk..


Barcode and Labeling

Use barcode scanners to manage your inventory more quickly and accurately. Phoebus Inventory is compatible with most barcode scanners you can plug into your computer. Barcode can be integrated to item label report.


Multiple Locations & Sublocations

Track inventory in multiple locations: Base, Rig Site, At service company . Use sublocations to more precisely track aisle numbers, bin numbers, etc.

 Alert on stock shortage and Reorder Stock

Setup minimum and maximum quatity of stock to automatically generate ReOrders report for item that are low in stock, or warning when stock level is under minimum.


 

Full Movement History

Get a full history of any inventory movements or adjustments to track down any item from purchasing to consumption.

 Multiple Currencies and Languages

Keep values of inventory movement in many currency. Automatic convert transaction currency to Base Amount. Phoebus also comes in English, Russian and Vietnamese.

 Customizable Fields

Phoebus allows you to rename any labels or messages within the software. You can also add your own's new extra custom fields.

 Web base dashboard

Have everyone working off the same data in real time using web-base Phoebus. You can have everyone's computers connected  over the internet!

 

Graphs!

Get a graphed timeline of your  inventory levels. See how your business is doing visual.

Flexible Inquiries

You can get informations in many easy and accurate ways through Phoebus's tools: Item Inquiry, Movement Inquiry, Inventory Inquiry... or you can create your own's inquiry.

 Report Designer

Use our query designer and Report Designer  to get any information like well consumption report, items below minimum level, and how long your inventory will last. …

 Automatic Mailing

 Phoebus Mailing will automatic send email to responsible persons on regular basis or on event basis.

 User defined  Workflow

Design your workflow with Phoebus for automatic routing documents between departments

 

 

Access Rights

Restrict who has access to see or modify what. Phoebus allows you to create different login users, each with a different set of access rights.

 Import/Export Data

Easy import/Export any data from Phoebus from/to Excel.

Ledger interface to SunSytems.

  


Inventory.ppt

1-3 of 3