Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 190 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 65 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
make s_nq_ tables available to a OAC customer with on-premise Oracle DB and RDG
Organization Name
POSTMEDIA NETWORK INC. (CA)
Description
Please, make available the same features existing in OBIEE on-premise for an OAC instance that uses on-premise Oracle Database with RDG.
Features:
- Usage Tracking. As implemented on the usual BI_PLATFORM schema (tables S_NQ_ACCT, S_NQ_ACCT, S_ETL_DAY, S_ETL_TIME_DAY, etc)
- Scheduled Agent data. As implemented on tabels S_NQ_JOB, S_NQ_INSTANCE, S_NQ_ERR_MSG, S_NQ_JOB_PARAM, etc
===================
Business impact:
Missing these tables affects the quality of Support, Audit, Monitoring and Maintenance tasks.
The provided functionality as of 2020-04-24 does not cover th ementioned needs.
e.g.: automate a report with all the agents that have failed in the last 7 days, including its error message; send it every morning at 9:00 AM from Monday to Friday, to members of the Support team.
e.g.: produce a XREF report of all the Agents that deliver content for a given analysis.
e.g. produce a XREF report of all agents created by a given user.
(etc)
Use Case and Business Need
Use Case #1: automate a report with all the agents that have failed in the last 7 days, including its error message; send it every morning at 9:00 AM from Monday to Friday, to members of the Support team.
Use Case #2: produce a XREF report of all the Agents that deliver content for a given analysis.
Use Case #3: produce a XREF report of all agents created by a given user.
Use Case #4: perform Impact Analysis
Business Need #1: need to know which agents have failed in the last 4 days, and their error messages.
Business Need #2: audit and monitor what dashboards and analyses are used by a given user.
Business Need #3: Obtain ranking information of usage of specific dashboards/analyses
Business Need #4: Analyze what dashboards analyses have nto been used in more than n months. Monitor if those objects can be deprecated.
More details
See OBIEE 11g / 12 documentation about tables:
S_NQ_JOB,
S_NQ_INSTANCE,
S_NQ_ERR_MSG,
S_NQ_JOB_PARAM,
S_NQ_ACCT
S_ETL_DAY
S_ETL_TIME_DAY
Original Idea Number: dba7f5af98
Comments
-
Also help in impact analysis this kind of information.
0 -
Correct! i added your comment into the original text, hoping it improves chances Oracle personnel read it.
Thank You!
0 -
There is usage tracking on OAC -- and the table names are different. Is your question around the schema or specific missing columns/data you are looking for?
https://www.ateam-oracle.com/oracle-analytics-cloud-oac-using-usage-tracking
0 -
Thank You.
A far as I understand, usage tracking on OAC is not implemented for on-premise databases accessed via RDG.
It is implemented only for customers who have licenses for Oracle Database Classic Cloud Service or Oracle Autonomous Data WarehouseI find this paragaph at the first link you referred:
Note: Currently OAC Usage Tracking is not supported with Data Gateway (DG) using an on-premises databases. This blog will be updated if / when on-premise support becomes available.... and this paragraph at the second link:
About the Usage Tracking DatabaseOracle Analytics Cloud stores usage tracking details in a database that you specify. The database can be Oracle Database Classic Cloud Service or Oracle Autonomous Data Warehouse. You specify the database and connection pool details in your data model file using the Oracle Analytics Developer Client Tool.
makes sense?
0 -
I see -- you want the cloud service to write to an on-premises DB via the gateway. It is unlikely we will take this approach. The data gateway is very focused on satisfying queries for live analytics and is not intended as a channel for writing.
What is the challenge with using a cloud DB? Seems like the real issue is not RDG per se but some other aspect of the end to end system.
0 -
Licensing. Our company does not have a license for cloud DBs, currently.
Additional question: Would it be possible to read from an on-premise DB + RDG for analyses, scheduled agents and bi-publisher reports, AND store the usage tracking of these into a cloud database?
Thanks!
0 -
Usage tracking does track activity routed through the RDG. It is conceptually an extension of the connector to a data source. You cloud also evaluate "always free" to get started. https://www.oracle.com/cloud/free/#always-free
0 -
Usage tracking does track activity routed through the RDG. It is conceptually an extension of the connector to a data source. You cloud also evaluate "always free" to get started. https://www.oracle.com/cloud/free/#always-free
0 -
Excuse me Bret, I do not understand your sentence:
"You cloud also evaluate "always free" to get started."Could you please clarify? Thank You!
0 -
Your usage data may fit on an always free DB instance if the only issue you have is getting an instance. It might be sufficient or could at least help you evaluate how Usage tracking in OAC works and determining your retention needs.
0
