Tag Archive | "oracle bam"

Technical Tips

Oracle BAM - SQL to List Users and Roles

No Comments »
Filed Under Technical Tips // Tags: ,

I don’t really like what Oracle did with BAM user/roles and authentication.

I believe they took Microsoft (SQL Server) tables and just slapped them into Oracle (now requiring that we put quotes around tables and columns). I assume this process will change in the upcoming releases, but here is a quick SQL statement you can use to get a look at your users and their roles as BAM understands them:

1
2
3
4

SELECT iu."SysIterName" username, iur."RoleName" userrole
FROM orabam."SysIterUser" iu, orabam."SysIterRoleUserMapping" iur
WHERE iur."UserID" = iu."SysIterID"
ORDER BY iu."SysIterName"
Industry Trends, Technical Tips

Oracle BAM Sucks, For Now

No Comments »
Filed Under Industry Trends, Technical Tips // Tags: ,

Our team has been working with BAM since Oracle took it on (we rolled out BAM reports in 2007).  The product is certainly “interesting” and has some cool auto-refresh capabilities that make for a nice demo to executives.  However, there are a few pieces to the overall reporting puzzle that, well, leave me a little puzzled…

  • No ability to write reports that query an RDBMS or even the BAM data objects — I hope you like simple query logic.
  • No ability to manipulate data in the BAM data objects: I just want to run an update statement people.
  • Filters that work in the normal browser window do not work when the report is placed in an IFRAME (which is their recommended approach for putting reports on another web site).
  • Only support for IE: c’mon, the days of enterprise software only supporting IE are over.
  • No documented calculation for INSTR: hmm…if you can’t use SQL, and you there is no [documented] way to implement an INSTR, I have a hard time saying this is ready for primetime.

Note: I hope I am wrong about a few of the above statements, but this is my current understanding based on what my consultants and developers have explained (and based on my cursory look over documentation and fiddling with BAM’s reports/data objects).  I’ll be happy to edit the post if someone can prove otherwise.

Technical Tips

Oracle BAM and SOA Suite - Potential Conflict On Same Machine

No Comments »
Filed Under Technical Tips // Tags: , ,

We had an issue where BAM stopped working after installing SOA Suite on a Windows 2003 Server (BAM only runs on Windows at the time of this writing).

After trying to uninstall/reinstall many times ourselves, Oracle Support suggested that this was not a compatible configuration. We have done it before (in play environments), but this clearly can cause some issues that are not easy to resolve. So, in this case, we ended up splitting the installation to different machines and have been sleeping much better at night.



Archives

Recent Comments

  • Kavitha Muniraj said: Hi, Could you please send a script which checks the status of forms and reports of oracle...
  • Siddharth said: Hey thanks a lot !! Have been lookin all over for this :) My PC may not be able t handle FlashBuilder...
  • Cyrex said: Hey man why I cant install Apex 4? is there anyone can help me.,?
  • sharanabasava said: ALTER TABLE [my_table_name] RENAME COLUMN [current_column_name] TO [new_column_name]; Sir,I...
  • Huub Vankan said: Thanks for this easy solution. Indeed strange that is does not work in the (x86) folder….

Calendar

July 2010
M T W T F S S
« Jun    
 1234
567891011
12131415161718
19202122232425
262728293031  

Editor's Picks

Featured Testimonial

"M&S has taken 'partnership' to a new level. They are not only a deeply skilled service provider, the M&S team is actually a mission critical component to our operations, taking on new initiatives as well as maintaining custom, open source, and COTS solutions."

CEO, MedPivot

Free SQL Service