Looking for database-aware fax software recommendation

Posted on 2009-02-23
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
    LVL 11

    Expert Comment

    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

    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
    LVL 1

    Author Closing Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    I was recently sitting at a desk at work with one of my colleagues and needed some information on my home computer. He watched as I turned on my home computer, established a remote session into it, got the information I needed and then shut it down …
    What’s a web proxy server? A proxy server is a server that goes between clients and web servers, used in corporate to enforce corporate browsing policy and ensure security. Proxy servers are commonly used in three modes. A)    Forward proxy …
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now