function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ntnngntnng 

Reports data from external source

Can we generate reports by pulling data from external sources? When a user creates a report and runs a report, we need to pull the data available in Oracle database.

sfdcfoxsfdcfox

You can't directly report on data that does not somehow exist in your organization's data. The standard method to solve this scenario is through the use of synchronization. Your organization can install software that allows an Oracle database and your organization data to be synchronized on a regular schedule, and you can then report on this data. Of course, your reports will only be as current as your last synchronization event, which could be as much as 24 hours old depending on the software used.
ntnngntnng

Thanks for your reply.

 

According to the requirement, we only need to pull the data from oracle database for report creation. The data saved in oracle won't be copied to salesforce. Is there a workaround for this situation?
sfdcfoxsfdcfox

Some CRM applications and reporting applications do support this natively, but the Force.com platform does not have this sort of feature. You can not run reports on tables that are not in your system. Any alternatives that you could use would no be "in" Salesforce, but would rather exist as an external application, such as a Java applet, Flash script, ActiveX Control, desktop application, or some other means. I wish I had a better solution, but you really would need to synchronize the data into Salesforce in order to leverage their reporting engine. You might take a look at CrystalReports and see if they can get you the report generation you're looking for.