Archive for January, 2012

Sunset Reports supports both “Push” and “Pull” technology

January 19, 2012 Leave a comment

Push technology is a type of Internet-based communication where the request for a given report is initiated by the report server or in this case Sunset Reports report queue. The report is “pushed” to a user via email.

Pull technology by contrast is where the request for the transmission of information is initiated by the user.   Sunset Reports can receive a request via email and then reply with a report or document in a follow up email.

The use of email as the communication technology for Sunset Reports provides the broadest option for all platforms and devices.   It overcomes limitations or restrictions placed by browsers, operating systems, firewalls, network security, etc.

Data Gathering

January 5, 2012 Leave a comment

A recent customer of Sunset Reports really exploited the power of the product.    The customer was a distributor of parts and wanted to get sales data from their customers.  The application required connection to several different sales databases including Access, SQL Server, and Oracle.   It was necessary to collect sales data for products.   Each customer got a copy of Sunset Reports.  Since there were several different database schema’s, the query builder in Sunset Reports was used to extract the data.   Each different system required a different query.   A report was created that normalized the format of the data so all systems could be combined and analyzed in the same way.   The report was used to create a CSV text file and the file was daily uploaded to an FTP site.   All this was done with Sunset Reports.    The FTP site was hosted by the distributor and a program was written to consolidate the CSV files.   Then another copy of Sunset Reports produced a set of reports against the consolidated data.

The savings in software development was tremendous.   Sunset Reports provided the means to connect to, query, and transform the data.   The data was exported to a file, uploaded, and then reported on.   Comparatively, the alternatives would have cost over $20,000 more.