About the title:
I know, actually the title should have
been something like: "Configuring Gmail as Delivery
Channel Mail Server for BI Publisher 11g".
Available in 11g but could be backport to 10g:
It
is about a new feature in BI Publisher only available in 11g unless
you request a back port to 10g - Which I understand is also possible but
has to be requested as Enhancement Request through Oracle
Support and then Shinji's team will make it possible.
Benefit:
Well,
now having this available in BI Publisher 11g it is possible to
configure our Gmail email account to send or deliver
BI Publisher reports. This is useful for some companies which rely in
such email providers and prior to BIP11g this was not possible. Also, it is useful for developers to test
email delivery channel with no need to use a local company's Email
Server.
Actually, this is also supposed to work for TLS (Transport Layer Security) configuration. Suffixes for me to explain here that
this is the successor of Secure Sockets Layer (SSL) and thus improves
the network communications and reduces the risk of eavesdropping and
tampering. More on TLS here.
But unfortunately, at the time of this note this feature does not seem to be working. If you get it to work I would be pleased to hear about it.
Use: To take advantage of this new feature simply enter the following values:
Port : 465
Encryption: SSL
Showing posts with label BI Publisher 11g. Show all posts
Showing posts with label BI Publisher 11g. Show all posts
Monday, January 30, 2012
Tuesday, November 22, 2011
BI Publisher 11g - Webservices
If you are looking BI Publisher Webservices then you can simply find them under the following location:
http://servername:9704/xmlpserver/services
You will get a list for these services :
In future posts I will write on some of these new webservices.
That's it for now. Got to go back to my daily duties for my current customer :)
http://servername:9704/xmlpserver/services
You will get a list for these services :
- v2/ScheduleService (http://servername:9704/xmlpserver/services/v2/ScheduleService?wsdl)
- v2/ReportService (http://servername:9704/xmlpserver/services/v2/ReportService?wsdl)
- PublicReportService ( http://servername:9704/xmlpserver/services/PublicReportService?wsdl )
- ReportService ( http://servername:9704/xmlpserver/services/ReportService?wsdl )
- v2/SecurityService (http://servername:9704/xmlpserver/services/v2/SecurityService?wsdl)
- ServiceGateway ( http://servername:9704/xmlpserver/services/ServiceGateway?wsdl )
- XMLPService ( http://servername:9704/xmlpserver/services/XMLPService?wsdl )
- v2/CatalogService (http://servername:9704/xmlpserver/services/v2/CatalogService?wsdl)
In future posts I will write on some of these new webservices.
That's it for now. Got to go back to my daily duties for my current customer :)
Tuesday, March 29, 2011
Upgrade BI Publisher to 11g
Now that more and more customers are starting to use the newest BIEE 11g release a commom question asked is : How do I upgrade my BI Publisher 10g to 11g?.
Sometime ago we made a presentation on BI Publisher 11g and touched this matter. Here we revisit this interesting topic again and present you a summary of the upgrade process.
The upgrade of BI Publisher 10g to 11g is essentially a three step process:
1. Install BIEE 11g
2. Run Upgrade Assistant (to upgrade BI Publisher 10g Repository)
3. Run Upgrade Assistant (to upgrade BI Publisher 10g Scheduler metadata)
In Windows to start the Upgrade Assistant using the GUI change directory to the ORACLE_HOME/Oracle_BI1/bin directory of the Oracle Fusion Middleware installation: ua.bat
Assumptions: Certain considerations should be taken during the process as for example.
http://bipconsulting.blogspot.com/2011/07/10g-users-lets-upgrade-to-bi-publisher.html
or
http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi11115/upgrade/upgrade_to_11g.htm#t9
1. Oracle BI Publisher 11g Documentation
Sometime ago we made a presentation on BI Publisher 11g and touched this matter. Here we revisit this interesting topic again and present you a summary of the upgrade process.
The upgrade of BI Publisher 10g to 11g is essentially a three step process:
1. Install BIEE 11g
2. Run Upgrade Assistant (to upgrade BI Publisher 10g Repository)
3. Run Upgrade Assistant (to upgrade BI Publisher 10g Scheduler metadata)
Assumptions: Certain considerations should be taken during the process as for example.
- BI Publisher 10g Repository is file based. If it is XMLDB based then move the directory to a file system before migration. As of release 11.1.0 there is no support for XMLDB repository type (Future will use MDS as repository).
- The upgrade assistant assumes the BI Publisher 10g repository is accessible in a shared drive.
- Before upgrade, make sure BI Publisher 11g is set to repository File Type (by default it is BIEE Catalog) because the UA only upgrades to file type repository.
- After upgrade, BIEE 11g and BI Publisher 11g integration works if security is "Fusion Middleware" and BI Publisher Repository is BIEE Catalog. So use the utility in BI Publisher 11g Administration --> Server Configuration --> Select Catalog Type: BIEE --> set the BIP Repository path -->Upload to BI PS Catalog
http://bipconsulting.blogspot.com/2011/07/10g-users-lets-upgrade-to-bi-publisher.html
or
http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi11115/upgrade/upgrade_to_11g.htm#t9
1. Oracle BI Publisher 11g Documentation
Friday, February 25, 2011
BI Publisher 11g Log files location
When you are developing your first versions of your reports you probably start finding that something is wrong and may not be working. Well in these situations is really important to know what is going on and find out why your report is not working.
In the new release of BI Publisher we can find error messages of our data model or report generation in a couple of log files which are located at:
BIEE_HOME\user_projects\domains\bifoundation_domain\servers\bi_server1\logs\bipublisher
References:
http://download.oracle.com/docs/cd/E14571_01/bi.1111/e13880/T526682T542464.htm
In the new release of BI Publisher we can find error messages of our data model or report generation in a couple of log files which are located at:
BIEE_HOME\user_projects\domains\bifoundation_domain\servers\bi_server1\logs\bipublisher
References:
http://download.oracle.com/docs/cd/E14571_01/bi.1111/e13880/T526682T542464.htm
Friday, November 5, 2010
OBIEE 11g Architecture
Author: Jorge Anicama
Article Original Location: http://bichaos.blogspot.com/2010/11/obiee-11g-architecture.html
It has been awhile since my last post. The main reason is because I have been busy working in different projects and also taking care of a my new baby boy (new member of the family :) ).
Article Original Location: http://bichaos.blogspot.com/2010/11/obiee-11g-architecture.html
It has been awhile since my last post. The main reason is because I have been busy working in different projects and also taking care of a my new baby boy (new member of the family :) ).
Hoping this new post results interesting enough this time I will discuss the new BIEE11g architecture.
If you are planning to start using BIEE11g you will notice there are a few more new components and at first glance it seems complex to understand, but let us take a look at the following picture and we will notice it is not that bad:
We can identify two main component types the OBIEE 11g: The A) Java Components and the B) System Components.
A) Java Components: These are basically J2EE applications running in Weblogic Server. There are two subcomponents here: 1. Admin Server and 2. Managed Server. Each of them running in a dedicated Java virtual machine (JVM).
- Admin Server: This is nothing more than a set of J2EE applications that will help us Administering the system:
- Admin Console (WLS) — An adminstrative user interface that provides advanced management for Weblogic, JEE components, and security
- Fusion Middleware Control — An administrative user interface that is used to manage the BI domain.
- JMX MBeans — Java components that provide programmatic access for managing a BI domain.
- Managed Server: These are J2EE applications which will help the functioning of the BIEE System (highlighted in RED):
- BI Plugin — It routes HTTP and SOAP requests to BI Presentation Services.
- BI Security — It enables the integration of BIEE Server and Fusion Middleware security platform through webservices calls.
- BI Action Services — It provides the dedicated Web services that are required by the Action Framework (a nice introduction can be found here, another example of use is here and here) and that enable an administrator to manually configure which Web service directories can be browsed by users when they create actions.
- Webservices SOA — This component provides Web services for objects in the BIEE Presentation Catalog, to invoke analysis, agents, and conditions.
- BI Office — This component provides the integration between Oracle Business Intelligence and Microsoft Office products.
- Two particular applications: BI Publisher (Reporting System) and RTD (technology platform which enable the analysis of data and provides insight by using data mining algorithms and techniques in real time).
- BI Server — It provides capabilities to query and access data as well as services for accessing and managing the RPD file (BIEE Metadata).
- BI Presentation Services — It provides the framework and interface for the presentation of business intelligence data to Web clients. It maintains an Oracle BI Presentation Catalog service on the file system for the customization of this presentation framework.
- BI Scheduler — Provides extensible scheduling for analyses to be delivered to users at specified times. (BI Publisher has its own scheduler.)
- BI JavaHost — It enables BI Presentation Services to support various components: Java tasks for BI Scheduler, BI Publisher, and Graph generation.
- BI Cluster Controller — It distributes requests to the BI Server, ensuring requests are evenly load-balanced across all BI Server process instances in the BI domain.
In addition, the BI Domain requires a set of configuration files, the repository (RPD) file, the Presentation Catalog files, etc. Likewise, BIEE System uses a set of metadata tables stored in a relational database like Oracle.
How to Start BIEE System: There are multiple ways to start the BIEE System, but it must follow certain order. Based on the description given above we need to :
1. Start NodeManager : By default in Windows it runs when the OS starts (Reference about NodeManager can be found here)
2. Start Admin Server : Initiate Weblogic Server.
3. Start Managed Server : Initiate the main applications. Based on the picture above, these are highlighted in Red : BI Plugin, BI Security, BI Action Service, BI Webservices SOA. If you are planning to use BI Publisher or RTD then it must also be started.
4. Start BIEE Services : These are the main BIEE processes which are controlled by OPMN: BI Server, BI Presentation Server, BI JavaHost. If you are planning to use BI Scheduler then also start it. Or if your instance is a clustered environment then also start the BI Cluster Controller. In our next post, we will describe how to actually perform this operation and we will describe how to troubleshoot issues by looking at the log files.
References:
1. Introduction to BIEE Administration (here).
2. Rittman Mead posts on Action Services (here).
Subscribe to:
Posts (Atom)




