Batch reporting framework for Oracle databases. Needed?
-
At my previous job at the computational center I dealt besides all with a great amount of reports getting data from an Oracle database - Crystal Reports & SQL*Plus HTML reports. Monthly we had to print some thousands of pages for co-working organizations. But what worst, we had to spend several days generating these reports in a special application written by our programmers. Until I have found a proper solution! I wrote an application that maintaned SQL-queries for generating report parameters for each kind of a report. So I had only to run such a query in this app, and I got a list of command lines for SQL*plus reporting script or a VBS script that acted like a bridge to Crystal Reports engine. Then I could save these lines to a .bat file and run it. But I also wrote a secondary app that took these command-lines and could run several child reporing processes simultaneously (SQL*Plus or Crystal Reports) that speeded up the whole job. While I was in my bed at home, the report generating job was performing during a night. By morning, the report files got ready and we only had to transfer them to our printing department. I don't work there anymore for some personal reasons. Sometime ago I completele rewrote this app from the scratch (I had no original source files) and the result has no shadow of that organization specificity, so I think there will not be any copyright problems. Now it's a completely general app that can deal with Oracle databases of any look. Is there a need for such an application? Will be there any sense to maintain and develop it? Try to sell it? P.S. If someone will like to try it, I have to say that I don't have an english version, only russian one. But if you ask me, I may perform an english-american localization, it will not take long.
-
At my previous job at the computational center I dealt besides all with a great amount of reports getting data from an Oracle database - Crystal Reports & SQL*Plus HTML reports. Monthly we had to print some thousands of pages for co-working organizations. But what worst, we had to spend several days generating these reports in a special application written by our programmers. Until I have found a proper solution! I wrote an application that maintaned SQL-queries for generating report parameters for each kind of a report. So I had only to run such a query in this app, and I got a list of command lines for SQL*plus reporting script or a VBS script that acted like a bridge to Crystal Reports engine. Then I could save these lines to a .bat file and run it. But I also wrote a secondary app that took these command-lines and could run several child reporing processes simultaneously (SQL*Plus or Crystal Reports) that speeded up the whole job. While I was in my bed at home, the report generating job was performing during a night. By morning, the report files got ready and we only had to transfer them to our printing department. I don't work there anymore for some personal reasons. Sometime ago I completele rewrote this app from the scratch (I had no original source files) and the result has no shadow of that organization specificity, so I think there will not be any copyright problems. Now it's a completely general app that can deal with Oracle databases of any look. Is there a need for such an application? Will be there any sense to maintain and develop it? Try to sell it? P.S. If someone will like to try it, I have to say that I don't have an english version, only russian one. But if you ask me, I may perform an english-american localization, it will not take long.
Dmitri Novikov wrote:
Is there a need for such an application? Will be there any sense to maintain and develop it? Try to sell it?
Write an article explaining how it works, and you'll get answers to these questions :)
Bastard Programmer from Hell :suss:
-
Dmitri Novikov wrote:
Is there a need for such an application? Will be there any sense to maintain and develop it? Try to sell it?
Write an article explaining how it works, and you'll get answers to these questions :)
Bastard Programmer from Hell :suss:
Eddy, a rather good proposal! But If I publish an article at CodeProject, don't I have to publish also the source files of this application?
-
Eddy, a rather good proposal! But If I publish an article at CodeProject, don't I have to publish also the source files of this application?
I have seen some articles without an associated download. On the other hand, if the app is commercial, it might be seen as "advertising". Spend a day Googeling for commercial alternatives to your app. If there's more than three, there's probably a market. If there's not, there still might be one.
Bastard Programmer from Hell :suss:
-
I have seen some articles without an associated download. On the other hand, if the app is commercial, it might be seen as "advertising". Spend a day Googeling for commercial alternatives to your app. If there's more than three, there's probably a market. If there's not, there still might be one.
Bastard Programmer from Hell :suss:
Yet, I can't decide whether it can be done as commercial. Maybe a point will be in maintaining both commercial and freeware version. I'll think about posting an article, I will not be able to post it until the weekend. The first version of my program was written in old 2005:) I investigated the area that days and found nothing I could use to do the job I neeeded for free. But the time passed, things might have changed. You're right, I need to do the investigation nowadays also. If someone else will post answers here, I will be greatful!