Solved

Oracle Discoverer Interface through ColdFusion Application

Posted on 2008-06-26
4
201 Views
Last Modified: 2013-12-20
Is it possible (reasonable) to develop a ColdFusion application which interfaces with Oracle Discoverer to build Reports?


0
Comment
Question by:lvnguyen
  • 2
4 Comments
 
LVL 19

Expert Comment

by:erikTsomik
ID: 21877526
what version of CF you using . CF 8 provide great tools for building reports
0
 
LVL 39

Expert Comment

by:gdemaria
ID: 21877596
what do you mean by "interfaces"  ?

You may be able to link to reports, but I don't think you would be able to populate oracle's tables in order to create a report without going through the discoverer GUI.

But you could use Discoverer to build reports against tables that your Coldfusion app is using...
0
 

Author Comment

by:lvnguyen
ID: 21878036
We're using ColdFusion 8.  What is desired is to be able to dynamically choose parameters through the ColdFusion app and generate Discoverer reports from those parameters, then display the reports.
0
 
LVL 39

Accepted Solution

by:
gdemaria earned 125 total points
ID: 21878413
If I recall correctly, you can create a form screen interface for discoverer reports and submitting that form would run the report.   So, if that is actually true, you could do it also from Coldfusion.

I don't really recall the Discoverer side that well, perhaps someone from the Oracle forum could add their thoughts on what Discoverer allows for running a report..

For example, can you run a report from a form submit or from a URL with paramters in the query string?  If so, you can do it from CF...

0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to recover a database from a user managed backup

707 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

18 Experts available now in Live!

Get 1:1 Help Now