- 3,676,122 Users
- 9,603 Discussions
- 13,910 Comments
Forum Stats
Discussions
Send Insight reports over sFTP, REST or other more secure method, rather than email.

Summary:
I would like the ability to send reports from Insight (OBIEE) via sFTP, REST API or similar method. Currently sending via email is not considered secure enough by the business.
Situation:
We are currently scheduling weekly reports that contains sensitive data. We send excel files secured with password. We would like to send more securely due to pressures from IT and Legal teams. Currently this is treated as acceptable and a temporary measure until a more permanent and secure solution can be found.
The users that receive the reports often do not have access to Eloqua. This means that dashboards and reports that could normally be accessed securely from within the system are not available.
Requirement:
We would like to see functionality that can export both standard and custom reports and dashboards more securely via sFTP rather than just via an email attached. Also API access or similar method would also be acceptable. I understand that OBIEE has a publisher tool that appears to support this technology. Similar functionality would be useful.
Impact of implementing
- More secure data transfer.
- Improve the file size of reports so we can use more advanced capabilities.
- Drive adoption of Eloqua reporting as more reporting can be provided.
Impact of not implementing
IT and Legal teams might push business to use alternative platforms that can perform this. Or export via sFTP and use other analytics platforms to run and send analysis. Therefore there is no need for an Insight license.
Comments
Another use case is for automated data warehouse consumption
1. Build report in OBIEE with some form of transformed data and/or fields that only exist in OBIEE (e.g., visitor profile fields, closed-loop reporting fields, etc...)
2. Schedule (e.g., user specified; every 4 hours) report to export file to sFTP
3. File is consumed by data warehouse import process
There are still many data sources that are not exposed via the BULK 2.0 API (external activities, campaign, visitor, campaign membership) that has caused a gap for users wanting to export all Eloqua data efficiently. Using the REST API is not efficient for accessing these data sources if there is significant volume.
I voted this up. Exporting raw data from Eloqua objects via the API won't provide the summary data we see in OBIEE Insight reports. This seems all the more important as privacy and security concerns continue to accelerate in the marketplace.
Definitely, REST/BULK API's similar to the ones for Eloqua itself would be great for automation of processes.
This is desperately needed functionality, and only becomes increasingly necessary as the years and data security requirements progress. I've had countless clients need this capability as they are unable to get all of the data they need via the API and emails with attachments aren't secure and are cumbersome to manage.
How this functionality is not available is beyond me. Please look into this Oracle!