Nearly all companies need database administrators– but not all companies need a full time DBA. Sometimes you might need “half a DBA.” Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work.

Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Forrester Consulting conducted the survey of executives in mid to large enterprises who are using managed services to augment their in-house DBA.

No matter what the scope of an engagement covers, no matter what technology we’re asked to support, Datavail helps organizations leverage data for business value. Transform your firm’s performance, processes, decision making and more with tour technology support.

Nearly all companies need database administrators– but not all companies need a full time DBA. Sometimes you might need “half a DBA.” Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work.

Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Forrester Consulting conducted the survey of executives in mid to large enterprises who are using managed services to augment their in-house DBA.

Nearly all companies need database administrators– but not all companies need a full time DBA. Sometimes you might need “half a DBA.” Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work.

Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Forrester Consulting conducted the survey of executives in mid to large enterprises who are using managed services to augment their in-house DBA.

Nearly all companies need database administrators– but not all companies need a full time DBA. Sometimes you might need “half a DBA.” Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work.

Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Forrester Consulting conducted the survey of executives in mid to large enterprises who are using managed services to augment their in-house DBA.

Datavail runs on a culture of commitment ... to our clients, to our proficiency, to exceptional delivery and to our colleagues inside and outside of our own firm. Learn more about the culture that differentiates Datavail.

Nearly all companies need database administrators– but not all companies need a full time DBA. Sometimes you might need “half a DBA.” Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work.

Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Forrester Consulting conducted the survey of executives in mid to large enterprises who are using managed services to augment their in-house DBA.

Art of BI: Using a Proxy with BITeamwork and OBIEE

As part of the configuration process of leveraging a Proxy Server or HTTP Server with OBIEE, one configures the context-root paths accessible for routing to the target application server used by Oracle BI. This logic will apply when using a proxy with BITeamwork and OBIEE as the integration of the BITeamwork application is deployed to the same application server when deployed to the on-premise OBIEE solution.

Therefore if your Oracle BI implementation uses a Proxy or HTTP server such as Tivoli Access Manager, and F5 Load Balancer, Oracle HTTP Server, MS IIS, etc. then you will also need to represent the BITeamwork context root path if you have selectively identified the other context root paths for the Oracle BI application.

For example, per the OBIEE HA EDG Oracle documentation (http://docs.oracle.com/cd/E23943_01/core.1111/e10106/bi.htm#CHDHBAHG) when configuring the OHS server you will need to add the following routing information for the proxy to ensure proper OBIEE transport between the HTTP server and the application server.

Once you’ve made the configuration to the appropriate httpd.conf (Apache) or mod_wl_ohs.conf (OHS) configuration file, then restart the HTTP Server and all should be working well to see the BITeamwork integration with your Oracle BI implementation.

In addition if you are using the caching or compression settings of the OHS or Apache HTTP servers you will need to clear the static file cache to allow an upgrades of BITeamwork’s files to be refreshed properly on your user’s browsers. To do this run the following commands as the root user (or owner of the OHS/Apache installations).

Run htcacheclean -D

Then run, htcacheclean -r

Then run, apachectl restart, to restart the server.

In addition, if there is a need to bypass any of the static cached files you can cheery pick these by updating the config file as described by this Oracle documentation (http://docs.oracle.com/cd/E17904_01/bi.1111/e10541/querycaching.htm#BCGFJBDF)

Blog Author

Christian is an innovator in analytics and data warehousing design, best practices, and delivery. With more than fifteenyears of decision support and data warehousing with key experiences at Office Depot HQ, Sierra-Cedar, and Capgemini, he oversees the Oracle Analytics Practice which includes the technical development and delivery of Oracle BI collaboration software, data warehouse solutions, Oracle BI/EPM projects, and packaged analytics solutions at Datavail.