Looking for database-aware fax software recommendation

Posted on 2009-02-23
Medium Priority
Last Modified: 2012-05-06
Hello all,

I'm looking for a fax software that can dynamically query a database (Oracle 9i) and then fax out with the results of that query. I am trying to automate the faxing out of customer statements where all customers would get a statement on the 5th of the month. The database contains the relevant fax numbers, customer names, amounts due, what have you. I want to avoid having my users print out batches of statements then have re-key fax numbers into software.

Question by:between3and90
  • 2
LVL 11

Expert Comment

ID: 23759997
crystal reports

Use crystal reports to connect to your database and grab all the information (and format/etc..) your (what ever you want to fax out). The report should basicly return the report for each user you want to report on for the specified period.

Then use CRD to schedule the generation/faxing of those reports.

You said oracle specifically so this might not be an option, but SQL-RD does all of the above in one operation but requires and SQL server, so if you want to write something that grabs the oracle info and reformat it into SQL before your report runs this could work too:

LVL 11

Accepted Solution

asdlkf earned 750 total points
ID: 23760018
missed a point: as for the prevention of re-keying, i think SQL-RD would be a better option, possibly you can get an OLDB data connector for it? 'cause it can directly query a database and grab <info>+<fax> number, turn <info> into <report> and then fax it to <faxnumber>. It's also got sequential/batch scheduling so you could have one batch that just generates reports and stores the reports location in the database and then another one that (at a specific time on the 5th) just grabs the completed report and fax number one at a time.

-- chris

Author Closing Comment

ID: 31550399
Hi Chris,
Thanks for the links. I'll try this path and see if it's workable for us.

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Originally, this post was published on Monitis Blog, you can check it here . It goes without saying that technology has transformed society and the very nature of how we live, work, and communicate in ways that would’ve been incomprehensible 5 ye…
This month, Experts Exchange’s free Course of the Month is focused on CompTIA IT Fundamentals.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question