RxDB

RxDB gives you SQL access to your PDS data

Use standard tools to harvest your PDS data including

• Microsoft Excel
• Microsoft Access
• Sql Server
• Crystal Reports
• Any ODBC-enabled program

With this tool, you can easily create standard and ad-hock reports in just the format you'd like. Build the reports yourself, or ask for help from a trained RxDB professional.

These diagrams show how the tables in RxDB relate, and demonstrate how to find foreign key lookups.

We've built a few common reports that can simplify management tasks:

• Customer Purchases Report
• Customer Ranking using Sales History by Month
• Extended Margin report showing Gross Profit ( $ and % )
• Customer Contact List - Ideal for mail merge
• Vendor Contact List - Ideal for mail merge

Don't see what you're looking for? We can train you to crate your own reports or we can create versatile reports for your business needs.  Send us an email, and we'll create a report for you.

RxDB requires an ODBC driver to be loaded on your PC, and a DSN set up for your database.  These steps show the ODBC programs such as Excel or Crystal Reports how to get to your data.

Learn how to Set up RxDB

• SCO OS 5.0.7. 
• Pentium III 900Mhz processor with 1Gig of RAM. 
• An Ethernet network linking your PCs to the UNIX server
• PCs that use the database must be Windows 98 or newer and connected to the network