Feed aggregator

Cloud computing has brought a host of advantages for businesses that have become impossible to ignore, from decreased capital spending to enhanced collaboration. However, the true benefits of these technologies come with time, and therefore, a more extensive and strategic cloud plan, with remote database support, can potentially offer enterprises a more significant competitive edge in the long run. By applying these initiatives more holistically to all aspects of the organization, firms stand to gain more flexibility and productivity than ever before.

In a report for Forbes, Oracle Software Chief Thomas Kurian asserted that the rewards to cloud computing are different for users in various industries and departments. For example, he noted that professionals in HR, sales or financial sectors might hone in on the fact that the latest app updates are available more rapidly in the cloud while operational complexities are eliminated. Conversely, he explained that business decision-makers and executives are more focused on the functional aspects of cloud services. Kurian stressed that one of the reasons many enterprises have embraced the cloud is the inherent speed of adoption.

"Most people are really surprised at how fast they can go live with a deployment and then how quickly they can add and get new features up on it," he told Forbes.

A strategic journey
Kurian was adamant that cloud migration is not a one-time transformation, it is a continual exploration that can bring new efficiencies as deployment becomes more in-depth and sophisticated.

However, Daniela Gomes, a founder of the Brazilian Telecom Company Tellfree, explained to The Next Women that there have been challenges in her firm's cloud journey.

"When you migrate a service into the cloud and the functionalities keep the same, the process is transparent to the user," Gomes stated to the source. "However, in our case it hasn't been so because we have added new features to our communication services. And, as a result, the challenge was to introduce these new features to users (our employees), teach them how to use and implement the culture of using them – which is the most difficult part, as people in general are resistant to changes, mainly to new technology."

By utilizing dba services, businesses can ensure a more effective cloud transition with minimal interruptions or issues that could hinder ROI.

RDX offers a full suite of cloud migration and administrative services that can be tailored to meet any customer's needs. To learn more our full suite of cloud migration and support services, please visit our Cloud DBA Service page or contact us.

Craig O'Neill is the Founder and CTO of CaoSys and a recent Formspider customer. This is the feedback he left on our Q&A site.

v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}

Today as the last entry for this week of our WebCenter Partners Week, we'll be hearing from a partner that has recently rebranded themselves. Element Solutions, formerly known as Element115 creates WebCenter Sites Solutions to enhance the Web Experience across multiple industries.

If you are just joining us today for the first time this week, you'll want to check out the past few days of posts from our partners, TekStream, FishBowl , Lingotek and Extended Content Solutions for some interesting reading and video views.

And for any of you WebCenter partners out there that are feeling left out - fear not - there is always room for you on the Oracle WebCenter Blog. We'd love to hear from you and feature your solutions to our readers in upcoming weeks. Contact me directly @ michael.snow@oracle.com  and we'll take care of you.

Note From The CEO Venkatesh Korla / CEO & Co-founder Our Rebrand: Beyond Healthcare

Since rebranding back in October we occasionally get asked, “Why did you rebrand and what does it mean?” Well the short answer is, the rebrand recognizes the growth and expanded services Element Solutions now offers. Founded in 2003, as Element115 we began as a CMS implementation and solution company developing a strong partnership with FatWire Software and primarily focused on the Healthcare industry. However, that focus shifted over the years as we expanded our solution offerings as well as our customer base beyond healthcare, serving global clients in retail, financial services, hospitality, and manufacturing. 2010 brought the opportunity to become a Pillar Partner with Oracle as a result of the FatWire acquisition. Since the launch of eHealth Accelerator in 2004 we have experienced accelerated growth in size and scope, and today are positioned as a strategic solution partner for many Global 1000 companies. Our offerings focus on strategic consulting and specialized services that support the customer online experience.

In renewing the brand, we seek to enable greater transparency and customer engagement across many industries. Our new tagline, “Powering Your Success” positions us as the synergistic connector that fuses our client’s business needs with software technology which ultimately surges our partners’ success as well. We strive to be the leading System Integrator for the WebCenter Sites platform and Web Experience Management across retail, manufacturing, healthcare, and services industries.

eSite Accelerator for WebCenter Sites

We are very excited to announce the launch of our flagship solution eSite Accelerator. The solution is a successful reference implementation framework, originally built for Oracle WebCenter Sites and developed to enhance the online customer experience, streamline the Web CMS planning, discovery, and implementation process, accelerate the launch cycle and cut costs.

More Info:

• eSite Accelerator for WebCenter Sites
• eSite Accelerator for Healthcare
  

Case Studies

Floyd Medical Center

Floyd Medical Center is a healthcare system serving Northwest Georgia and Northeast Alabama.

Challenges:

• Improve the Medical Center’s Web presence and intranet with more dynamic content and a modern look
• Current system required a full-time employee to maintain content and did not easily support multiple contributors
• Ability for Employees to access the Intranet from all the different centers and locations

Services / Solutions Provided:

• The Intranet was expanded and employees can now securely and conveniently access it from a standard browser, from their office or remotely
• Each department can now manage and create their own content allowing for less dependency on IT and Marketing
• Search and segmentation capabilities were improved enabling employees to find internal content more quickly

Read Oracle/Floyd Success Story

Pella

Pella Corporation offers a full range of energy-efficient windows and doors, including residential and commercial products for new construction, remodeling and replacement projects.

Challenges:

• Move the RTA, “Real Time Appointment Setting” application on to WebCenter Sites
• Add time slot management functionality
• Incorporate QAS address validation

Services/Solutions Provided:

• The RTA application is an appointment scheduler comprised of several HTML-based data input screens whose data, upon completion, are serialized into XML, and placed on a JMS queue where it is fed into the corporate CRM system
• Developed using the Oracle CSDT and SVN, which allowed the Element Solutions team and the Pella team to work both remotely and collaboratively
• Front end was built using AJAX, JSON and Jquery and supports all modern browsers

Read Oracle/Pella Success Story

Recent Launches

Wendy’s (wendys.com)

Phase I (called Release 1.0) of a planned 3 phase deployment of WebCenter Sites.

About Wendy’s

The Wendy’s Company (NASDAQ: WEN) is the world’s third largest quick-service hamburger company, with a market cap of 2.3 billion. The Wendy’s system includes more than 6,500 franchise and Company restaurants in the U.S. and 27 other countries and U.S. territories worldwide.

Wendy’s chose Oracle WebCenter Sites to replace their legacy implementation which had several short comings and issues.  Wendy’s Senior Management driven by Wendy’s IT and Marketing drove a sense of urgency to move this project as quickly as possible.  Element Solutions did a POC implementation followed by Discovery, Design, and eventually Development/Build phases.

Technical Highlights

• The system allows the content authors to manage and maintain promos, product images, and social content across various sections of the website.
• The system supports consumption of external data feeds via custom REST API Web Services using Jersey, for Products and Jobs which are directly managed by Wendy’s Architecture team.
• The system also supports AJAX based Web Service calls to dynamically provide Nutrition information, Location based services in Find It and Career Jobs, with MapQuest integration.
• Custom tree tabs
• The HTML/CSS/JS was provided by Resource (an external graphics design agency), which was integrated by our development team.
• The design supports internationalization with a English locale rollout at this stage.  Future rollouts will include other languages.

Holland America

This was Phase 1 of a planned 3 phase deployment of WebCenter Sites. Next phase details are in discussion.

With 139 years of experience, Holland America Line is recognized as the undisputed leader in the cruise industry’s premium segment. Holland America Line’s fleet of 15 ships offers more than 500 cruises to 350 ports in more than 100 countries, territories or dependencies. Two- to 110-day itineraries visit all seven continents and highlights include Antarctica, South America, Australia/New Zealand and Asia voyages; a Grand World Voyage; and popular sailings to ports in the Caribbean, Alaska, Mexico, Canada/New England, Europe and Panama Canal.

Holland chose WebCenter Sites to replace their failing Teamsite implementation which was constantly experiencing issues.  This drove a sense of urgency to advance this phase of the project as quickly as possible. 

Technical Highlights They are using WebCenter Sites to produce XML data for consumption by their systems. Their online booking system uses the XML data for generation of their booking website. Their online cruise and tour systems use the XML to generate all the documentation that accompanies a cruise booking or a shore excursion: www.hollandamerica.com then select cruise package which takes you to their booking sites:  book.hollandamerica.com and book.seaborn.com

• The data model is fully populated by ingestion of existing XML files and the Sites REST api
• There is a custom workflow including multiple publish points for QA and testing
• Includes a fully custom XML publishing Model
• Custom tree tabs
• Custom Delete option for xml Files

For more info on Element Solutions:  visit their website:www.elementsolutions.com

For more specific info on upgrades. Upgrades to WebCenter Sites


12.00

12.00

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 -"/> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;}

12.00

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;}

12.00 Normal 0 false false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-family:"Calibri","sans-serif"; mso-ascii- mso-ascii-theme-font:minor-latin; mso-hansi- mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;}

This week again, the Log Buffer Edition covers the exciting and ever-evolving galaxies of Oracle, MySQL and SQL Server.

Oracle:

When does an Oracle process know it’s on Exadata?

MobaXterm 6.3 has been released. You can find the download and changelog in the usual place.

A new major release (version 3.0) of Randolf’s XPLAN_ASH tool is available for download.

Important !! Clustering Factor Calculation Improvement

Grouping Data Sets by Week Number of the Month

SQL Server:

Jason Crider asks to put some Windows update in his basket.

Data cleansing can be done via SSIS as well as Data Quality Services (DQS) and Master Data Services (MDS).  The lines are a bit blurred when talking about data cleansing using SSIS, DQS and MDS.

How To: Migrate Encrypted Procedures To Windows Azure SQL Database (WASD).

It’s a best practice to keep your index keys as narrow as possible, and SQL Server enforces a maximum key length of 900 bytes on most “normal” clustered and non-clustered indexes.

Webcast Presentation Materials: Introduction to SQL Server Security

MySQL:

This is the start of the heavy travel season for the MySQL Community Team. So if you are attending PHPTek, Drupalcon, Texas LinuxFest, SELF, Redhat Summit, or Lonestar PHP please make sure to say ‘hi’ while you are in Chicago, Portland, Austin, Charlotte, Boston, or Addison.

Your databases in a glance with Glimpsee

Continuent Tungsten 2.0 is a major step forward that includes key feature improvements to help you manage very large datasets on MySQL.

How to create a new (or repair a broken) GTID based slave with Percona XtraBackup

Disk I/O is frequently the performance bottleneck with relational databases. With AWS recently releasing 4,000 PIOPs EBS volumes, Laine Campbell wanted to do some benchmarking with pgbench and PostgreSQL 9.2.

This entry is part 19 of 19 in the series Adventures of Ace, DBA 

It’s the only explanation!

Related

Ace has dealt with problems before…

Default blame accepter?

The post Changes (Ace Comic) appeared first on Steve Karam :: The Oracle Alchemist.

Business intelligence (BI) solutions have the potential to empower businesses in a multitude of ways by allowing professionals to mine extensive stores of information for enhanced insight. However, many firms still aren't fully leveraging these tools due to inadequate resources or expertise. However, by seeking the professional support of database experts and remote dba services, these enterprises can gain greater control over data analysis for a considerable competitive advantage.

Channelnomics reported that the BI market is set to grow 7 percent annually over the next four years, according to Pierre Audoin Consultants (PAC). The research firm has determined that the BI market is in fact developing quicker than before, and is worth more than $42 billion in software and services. The strongest growth is expected to occur in advanced solutions such as predictive analytics. Philip Carnelley, research director at PAC, revealed that one of the biggest trends in BI is mobile technology, which gives users quicker access to reports on any device, from smartphones to tablets.

"Major obstacles can be seen among rapidly evolving technologies, requiring big efforts to keep pace and to acquire and maintain competency," Carnelley asserted, according to Channelnomics. "IT users need to move from one-stop shopping with ERP vendors to best of breed to get state-of-the-art solutions. New technologies may require significant product upgrades or architecture overhaul before they can be deployed."

New tools for changing objectives
As BI technologies evolve and become more complex, enterprises can leverage the assistance of third-party remote monitoring services. Carnelley explained that CIOs should partner with professionals that have expert knowledge and can guide BI projects, especially when adopting new solutions.

Information Management revealed that a related report from Saugatuck Technology also emphasized a shift in BI initiatives. The source explained that according to Saugatuck, firms are looking to harness more on-demand access to data and address challenges to the accessibility and delivery of analytics.

"I've never met any business or IT leader who complains about not having enough data. The complaints have always centered on how to find, access and effectively utilize the data available," said Saugatuck Analyst Bruce Guptill, according to Information Management. "We have practically unlimited data available, now we really need ways to manage it, quality-control it, secure it, cleanse it, etc."

Enterprises that seek support in these BI efforts have the opportunity to mine company data in new and innovative ways for more valuable conclusions.

RDX's business intelligence and big data experts assist customers in leveraging data contained in large data stores. For more information, please visit our Business Intelligence and Predictive Analytics pages or contact us.

Business intelligence (BI) solutions have the potential to empower businesses in a multitude of ways by allowing professionals to mine extensive stores of information for enhanced insight. However, many firms still aren't fully leveraging these tools due to inadequate resources or expertise. However, by seeking the professional support of database experts and remote dba services, these enterprises can gain greater control over data analysis for a considerable competitive advantage.

Channelnomics reported that the BI market is set to grow 7 percent annually over the next four years, according to Pierre Audoin Consultants (PAC). The research firm has determined that the BI market is in fact developing quicker than before, and is worth more than $42 billion in software and services. The strongest growth is expected to occur in advanced solutions such as predictive analytics. Philip Carnelley, research director at PAC, revealed that one of the biggest trends in BI is mobile technology, which gives users quicker access to reports on any device, from smartphones to tablets.

"Major obstacles can be seen among rapidly evolving technologies, requiring big efforts to keep pace and to acquire and maintain competency," Carnelley asserted, according to Channelnomics. "IT users need to move from one-stop shopping with ERP vendors to best of breed to get state-of-the-art solutions. New technologies may require significant product upgrades or architecture overhaul before they can be deployed."

New tools for changing objectives
As BI technologies evolve and become more complex, enterprises can leverage the assistance of third-party remote monitoring services. Carnelley explained that CIOs should partner with professionals that have expert knowledge and can guide BI projects, especially when adopting new solutions.

Information Management revealed that a related report from Saugatuck Technology also emphasized a shift in BI initiatives. The source explained that according to Saugatuck, firms are looking to harness more on-demand access to data and address challenges to the accessibility and delivery of analytics.

"I've never met any business or IT leader who complains about not having enough data. The complaints have always centered on how to find, access and effectively utilize the data available," said Saugatuck Analyst Bruce Guptill, according to Information Management. "We have practically unlimited data available, now we really need ways to manage it, quality-control it, secure it, cleanse it, etc."

Enterprises that seek support in these BI efforts have the opportunity to mine company data in new and innovative ways for more valuable conclusions.

RDX's business intelligence and big data experts assist customers in leveraging data contained in large data stores. For more information, please visit our Business Intelligence and Predictive Analytics pages or contact us.

I’ve had my 13″ MacBook Pro since the mid 2009 refresh and it’s been really reliable. Apart from one brief visit to Apple to replace a noisy fan, I’ve had no worries. A few years ago I upgraded from 4G  to 8G RAM, so I’m not stranger to taking the back off it.

Even though it’s quite old by computer geek standards, I really don’t have any performance problems. I do demos with a couple of Linux VMs running Oracle and it works OK. Despite this, I was bored the other night and decided to buy an SSD to replace the internal hard drive. It arrived yesterday, so during last nights insomnia, I decided to fit the hard drive, rather than stare at the ceiling.

The actual hard drive replacement is pretty simple. You can see an example of it here. It takes about 5 minutes.

The transfer of the data proved a little more tricky than I expected though…

Attempt 1:

I use Time Machine for backups, so I slapped in the new hard drive, booted from the CD and expected to just restore from Time Machine. It turns out my Time Machine backups weren’t as complete as I thought.

Attempt 2:

No worries. I connected my old hard drive using a USB cable, booted from the CD and used the Disk Utility to restore the old hard drive to the new SSD. That would have been fine, except the new hard drive was fractionally smaller than the old one. That would have been fine for a Time Machine backup, since the old drive was not completely full, but for an image restore it’s a big no-no. Now I was starting to get worried. I could always replace the old drive, but I was starting to think I might have wasted my money.

Attempt 3:

So finally I bit the bullet and re-installed Snow Leopard (the most recent media I had), upgraded to Lion, then Mountain Lion through the App Store. Once that was done I dragged my apps and data from the old drive across to the new drive. Job’s a good’un!

So it got solved in the end, but it wasn’t quite the blissful experience I expected.

Cheers

Tim…

Update: Thanks to Luis Marques for reminding me about TRIM, with this Twitter comment, “Tim, don’t forget to enable TRIM on SSD (if it supports it) using this http://chameleon.alessandroboschini.it/index.php  or http://www.groths.org/trim-enabler/“

MacBook Pro Mid 2009 : Replacing hard drive with SSD… was first posted on May 10, 2013 at 9:27 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Last February, I performed an operating system rolling upgrade on a four-nodes RAC cluster (11.2.0.2). I then faced a strange problem when restarting the operating system...

The first step of the procedure was to stop all Grid Infrastructure and Database services running on the first node as well as to disable Cluster and ASM autostart. The following command is supposed to prevent Oracle High Availability Service (OHAS) to be run at operating system startup:
 

# crsctl disable crs

 
Then, I powered off the server and asked the storage administrator to disable all LUNs attached to this server, including the one containing Oracle binaries (/u00).

This step was necessary because the storage bay requires specific drivers which are not shipped with the Linux installation media. Without drivers, all mountpoints attached to LUNs and detected during the upgrade process would have displayed errors.

However, when starting the server again to check that all mountpoints were disabled, I saw that the startup procedure was blocked to the OHASD service, preventing the server to finish the startup.

In fact, even if crs autostart is disabled, a deamon called "ohasd" is still running at server startup. Among other things, it checks and indefinitively waits for the presence of CRS binaries. No luck, the LUN attached to the mountpoint containg CRS binaries was disabled...

We can see this check in /etc/init.d/ohasd file:

 

# Wait until it is safe to start CRS daemons
  while [ ! -r $CRSCTL ]
  do
    $LOGMSG "Waiting for filesystem containing $CRSCTL."
    $SLEEP $DEP_CHECK_WAIT
  done

Where $CRSCTL corresponds to /u00/app/11.2.0/grid/bin/crsctl

 

What is crazy is that the loop is performed no matter if autostart is enabled or not. Just after the loop is done, the script checks if autostart is enabled - thanks to the file /etc/oracle/scls_scr/$MY_HOST/root/ohasdstr, which contains "enable" or "disable" depending of the autostart configuration.

Why do not check if autostart is enabled before looking for CRS binaries? A question that Oracle does not seem to have answered in 11.2.0.3, because we can see that, even if the ohasd startup mecanism was updated, ohasd is still waiting for CRS binaries:

 

# Wait until it is safe to start CRS daemons.
  # Wait for 10 minutes for filesystem to mount
  # Print message to syslog and console
  works=true
  for minutes in 10 9 8 7 6 5 4 3 2 1
  do
    if [ ! -r $CRSCTL ]
    then
      works=false
      log_console "Waiting $minutes minutes for filesystem containing $CRSCTL."
      $SLEEP $DEP_CHECK_WAIT
    else
      works=true
      break
    fi
  done

 

As you can see, in 11.2.0.3, the server will now finish to start, but will be waiting 10 minutes. A message is displayed in the log startup:

 

Apr 30 15:31:29 rac1 logger: Waiting 10 minutes for filesystem containing /u00/app/11.2.0/grid/bin/crsctl.
Apr 30 15:32:29 rac1 logger: Waiting 9 minutes for filesystem containing /u00/app/11.2.0/grid/bin/crsctl.
Apr 30 15:33:29 rac1 logger: Waiting 8 minutes for filesystem containing /u00/app/11.2.0/grid/bin/crsctl.
Apr 30 15:34:29 rac1 logger: Waiting 7 minutes for filesystem containing /u00/app/11.2.0/grid/bin/crsctl.
[...]

 

At this time, the workaround I found to allow the server to start immediatly is to prevent "ohasd" service to run by renaming or moving the /etc/init.d/ohasd file, or to comment the loop section in order to skip the infinite loop.

Hopefully, SSH deamon (if enabled) runs before OHAS deamon. It is possible, if the startup procedure is blocked, to access the machine through an SSH session in order to apply this workaround and to restart the server.

I finally added this pre-requisite to the upgrade procedure for the remaining nodes of the cluster.

The dial gauge is a very visual way to show data in an application - and it has been there in Oracle ADF Mobile since 11.1.2. However in that release you could only use a range of 0-100 - well now you can do better with the new ADF Mobile version.

But there is one little trick to how this works compared to the way it works in the regular web ADF Faces gauge component, and if you don't notice it you might think you are still stuck in the 0-100 days - The trick is the new background property.

If you are working in the property inspector you can right-click in the property to see explanation and the available values.

Or if you work in the code editor just use the code insight to choose the value you want.

For defining your own range you'll want to use the costum options.

Then you can get something that looks like these:

Also note that you can control the indicator type with the indicator property.

<dvtm:dialGauge background="circleAntiqueCustom" indicator="needleLight" value="7000" minValue="4000" maxValue="9000"/>

Happy visualization.

I just read this post about a new patch that will allow you to affect the way the optimizer calculates clustering factor and hence how likely it is to choose a particular index for a query plan.

http://richardfoote.wordpress.com/2013/05/08/important-clustering-factor-calculation-improvement-fix-you/

Pretty cool.  I haven’t tried it, but it looks promising.

- Bobby

Today I would like to share something Fishbowl Solutions has been working on internally for a little while now and started to implement at customer sites – Fishbowl Multi-Upload and Batch Metadata Editor.

This component was initially developed as part of Fishbowl’s Innovation Event. The combination of the first place and second place idea meshed very well together in delivering a seamless method for bulk contributing and editing metadata. This is now within production at a customer site with several modifications made to satisfy their requirements.

The main use case for this component is the mass uploading of content to get it into the system for categorization now, or at a later time.  Providing a staging ground for content to get it in the system and off the user’s desktop is crucial for an enterprise solution. In addition, the mass tagging and editing of metadata all at once is a feature that has been missing within content server from its inception.  As many of you know, Bex Huff of Bezzotech has a Microsoft Excel Spreadsheet (Remote Metadata Updater) that uses SOAP calls to communicate with content server to perform edits to content’s metadata after a search query is performed.  My goal was extend this functionality within Oracle WebCenter Content using modern-day advancements in JavaScript and browser capabilities.

This was done using a combination of several API’s, PlupLoad (Oracle uses an older version of this for their Drag & Drop upload feature within WebCenter Spaces Document Explorer Taskflow), Handsontable, JQuery, (in addition to extensively utilizing my WebCenter Content and Jquery Framework for calling WebCenter Content services) and Fishbowl’s overall knowledge of WebCenter and web development techniques.

The most compelling feature that was added for this deployment is “Profile Awareness”.  By this I mean all aspects of the profile and rules set up within content server are taken into consideration.  This includes, but is not limited to:

• Metadata field state (hidden, edit, info only, required, excluded)
• Custom field labels
• Standard list and profile restricted lists for drop down lists
• Date selection
• Default values for profiles
• Metadata field ordering if rule is set as a group

Here are several screenshots of the features and use case it provides (click on any of them to see actual sizes):

• A user had several images to upload and know they will go within a certain profile.  Navigate to the upload page and drag and drop the files into the drop area:

• All of the items are now checked into the content server into a private workspace for that user.  Within the workspace you can filter by keywords uploaded and categorize content by profile. (Note: You can also tag content without profiles as well).

• As there are bound to be erroneous uploads of duplicates, or extra files, supporting a delete function was crucial.

• The user is now ready to check the boxes for the items they want to categories and tag with final metadata.  Here we present the user with a spreadsheet within the browser.  This is built using the Handsontable JQuery plugin which supports common Excel like features; copy / paste, undo, and cell dragging.  UCM is integrated to provide a high level of context while editing this data; Dropdowns, date fields, required fields, and info only fields aid in user tagging.

• With column support for dropdowns and dates.

• Once the user is done editing, they can execute an update.  The table will provide feedback in real time as each item is updated.  The result of the update will be relayed to the user via row highlighting and an error / exception table informing them of the failure.

This expands upon the use case of updating content already in the system with the spreadsheet (Note: That use case is still supported, however, locked down to administrators only).

I hope you find this post compelling about the power that Fishbowl can provide by combining ideas from an innovation event with the years of experience Fishbowl has within the WebCenter Content (UCM) world to provide ease of contribution and bulk editing of content. For more information, feel free to reach out to us at 952-465-3400 or info@fishbowlsolutions.com.

Thanks,

AJ LaVenture
Senior Software Consultant

 

The post WebCenter Content (Oracle UCM) Multi-Upload and Batch Metadata Editor appeared first on C4 Blog by Fishbowl Solutions.

Probably you already noticed that by default data is shared between VO instances (or even separate VO's) based on the same EO. Newly inserted row into one instance becomes instantly visible from another VO instance. There is a way to control this behavior in ADF, this post is based on excellent Steve Muench source of information - Using the RowQualifies() Method to Fine Tune View Link Consistency Behavior. As Steve says, by default data is shared and you can turn it off either by calling setAssociationConsistent(false) or globally per AM with jbo.viewlink.consistent=false configuration property:


Idea of this post is to go a bit deeper and to show how you control data sharing between VO instances programmatically. For example how to delay new row sharing between VO instances until this row is commited.

Sample application - VOSynchEOCacheApp.zip, contains one EO and one VO for Employees:


There are two VO instances defined in AM out of Employees:


Two fragments are implemented in ADF Controller. First displays data from EmployeesEditView and allows to insert new row. While second displays a table with data from EmployeesListView:


We create now new row in the first fragment:


Navigate to the second fragment with the table. Keep in mind - new row is not commited yet, it is just inserted into EmployeesEditView VO instance. However, as per default behavior data is shared between VO's and this new row is appearing in the list from EmployeesListView VO instance:


In order to control when newly inserted row is shared between VO instances, we can override rowQualifies method from VO Implementation as per Steve Muench suggestion above. We have access to the row and can check row status. In this example row is qualified to be added into rowset if its status is unmodified:


Test now again the same scenario - try to insert new row, but don't commit yet:


Navigate to the second fragment with list data - new row is not added yet as expected:


Go back and save new row:


You can check it will be added to the rowset now and displayed in the list from second VO instance:

First Go to OTN

www.oracle.com/technetwork

Go to DOWNLOADS -> Middleware

You will see Business Intelligence Applications under Middleware

You see both 10g and 11g. Click on Oracle Business Intelligence 11g downloads
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html

You will see BI Apps 11.1.1.7.1 here:
Oracle Business Intelligence Applications (11.1.1.7.1)

Thanks to Norman Dunbar for pointing out that MobaXterm 6.3 has been released. You can find the download and changelog in the usual place.

I’ll be interested to see how the performance improvements to SFTP work out. I’ve seen some issues with this during transfers of large files before. The built in NFS and VNC servers sound interesting too. I can think of one situation where the NFS server would come in really handy.

Great stuff!

Cheers

Tim…

MobaXterm 6.3… was first posted on May 9, 2013 at 8:17 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

For those of you integrating or planning to integrate with Forms, ADF or APEX, a presentation from our friends at PITSS

Tuesday, 14.05.2013  (14-May-2013)
2:00 pm - 3:00 pm (CEST)

Free Webinar

Integrating Oracle BI Publisher with
Forms 11g, ADF and APEX

Have you already decided about how to integrate in the future your reports within your Oracle Forms, ADF or APEX applications? In view of the technical innovations in Oracle Forms 11g, we will take a closer look at Oracle BI Publisher and see, step by step, how can we reach an optimal integration of BI Publisher reports within existing Forms applications, as well as the co-existence with Oracle ADF and APEX.

Registration:
https://www2.gotomeeting.com/register/608583482

Security
Time for my quarterly (or more often) warning on our old nemesis: 10 Reasons SQL Injection Still Works

EPM
The Business Analytics - Proactive Support blog let's us know that: EPM 11.1.2.3.00 is available on eDelivery.
BI
Over at the Oracle Business Intelligence Blog: Oracle BI Apps 11.1.1.7.1 Available and 11.1.1.6.10 Bundle Patch for OBIEE Now Available.
APEX
(YABAOAE) Yet Another Blog About Oracle Application Express let's us know that Oracle Application Express 4.2.2 now available.
Dimitri Gielis Blogdiscusses: Goodies - APEX 4.2.2 included Libraries.
He also does a little crystal ball gazing: Oracle Database 12c and APEX.
RDBMS
From That Jeff Smith: How to Synch your Oracle SQL Developer Data Model to a Different Database.
This posting from The Oracle Instructor is useful: How to audit sys into an OS file owned by root.
A little peek into the possible future of clustering factors from Richard Foote, the indexing guru: Important !! Clustering Factor Calculation Improvement (Fix You).
A good hands-on technical article over at Oracle DBA--Tips and Techniques: 11g Data Guard Cascading Standby Database.
From Karen Morton: Using Optimizer Hints for Oracle Performance Tuning.
Eddie Awad pointed out this really valuable item over at Ask Tom, Tom Kyte's perennially awesome Q&A on all things Oracle: Walid -- Thanks for the question regarding "advantage of private synonyms over public synonyms", version 11.2.
At Oracle Scratchpad, some great news. It looks like Jonathan Lewis is moving into webinars. I've seen Jonathan present live, and this going to be really great. Here's the posting at Oracle Scratchpad: Webinars.
Big Data
Eddie Awad'sTweeterization is excellent as always. He pointed to this one: Oracle Introduces Big Data Appliance Applications.
Coding
Another great items pointed out by Eddie Awad recently is at Making the Complex Simple blog: What Makes Code Readable: Not What You Think.
Fusion
At the Fusion Applications Developer Relations blog:  FindingCode Artifacts for Customization (Part 2).
Part 1 is here.
Oracle Service Bus
From OTN: Fault Handling and Prevention for Services in Oracle Service Bus.
Linux
Some good slides on Linux Performance Analysis and Tools.
…And Finally
From the Singulairy Hub comes this fun item: A Box With A Hidden Video Camera Documents Journey Through The Mail.
At io9, Old Spock battles New Spock in the greatest car commercial ever. You don’t have to be a Trekkie to get all the gags in this, but it definitely helps. 

A Guest Post by Lyle Ekdahl, Group Vice President General Manager, Oracle’s JD Edwards

Imagine that you could, in a moment’s notice, access your entire portfolio of projects or products in one view, including cost and profitability. Now imagine that your customer service representatives had real-time access to your customers’ historical order information and profitability while taking orders. That kind of speed and agility changes the game. Imagine new growth opportunities, smarter decisions, reduced costs, and all the benefits that come with being able to outsmart and outmaneuver your competition.

But this isn’t about imagining. We’ve made it a reality with the new Oracle In-Memory Applications for Oracle Engineered Systems.

As announced at COLLABORATE 13 last month, our new in-memory applications make older computing approaches obsolete and can take runtime out of the equation. Now you can have instant access to scads of information and perform complex data analysis in near real time on live data sets. The result is better context and insights to solve your critical business problems.

Here’s the really good news! We have released Oracle’s JD Edwards EnterpriseOne In-Memory Applications – specifically, Oracle’s JD Edwards EnterpriseOne In-Memory Project Portfolio Management and Oracle’s JD Edwards EnterpriseOne In-Memory Sales Advisor.

Oracle’s Engineered Systems make it possible for us to provide functionality in these applications that we couldn’t deliver before. For example, in the past, a team of data analysts would use the Extract, Transfer and Load (ETL) methodology, plus spreadsheets, to pull data. The information you would receive was stale, the manual process was error prone, and the conclusions could be questionable. Today, with JD Edwards EnterpriseOne In-Memory Applications, you get immediate access to massive sets of near real-time transactional information that is broad and deep. Your data is fresher, richer, and more accurate. Which would you rather use to base your business decisions on?

We are very excited about what these In-Memory Applications mean for our JD Edwards customers. We’ve seen the increased speed and improved visibility translate directly to increased revenue and profitability.

And just so you know, we are in the process of making In-Memory Apps available for the other Oracle Applications business lines. As we roll these high-performance solutions out and as the technology continues to evolve, you can trust that Oracle will be a leader to meet your performance and agility needs – even those you can’t imagine today. In the meantime, let’s focus on the exciting possibilities that these In-Memory Applications bring to us and the dawn of a new era in enterprise applications.

Enterprises of all sizes and sectors have invested significant time and funding into big data projects, but research has shown that many firms are disappointed with the results. Industry experts suggest that the problem lies in a lack of strategy and expertise. For these initiatives to be successful, firms need support from database experts as well as the most transparent analytics solutions that can integrate with existing business intelligence (BI) tools.

The Financial Times reported on a multitude of conflicting studies that have demonstrated big data successes and failures. Many of these initiatives show great promise, but the source noted that Accenture found only 22 percent of companies are satisfied with analytics programs and just 39 percent say their data is relevant to the business strategy. According to the source, Accenture attributed this to the fact that enterprises often measure too much data that doesn't matter as opposed to focusing on the information that does. In order to improve the outcome of big data projects, experts agree that enterprises need to invest in new capabilities and intensify the application of analytics. The Financial Times explained that, for instance, businesses can analyze information to answer questions such as how many customers have been lost in a given month. But to gain deeper insight into why they have left, and furthermore, predict when they might leave in the future, is something only big data can provide with proper tools and IT management.

A new approach
Big data can be especially useful because it incorporates external information, such as weather patterns or social media trends, with internal business data, like customer transactional histories. EWeek asserted that this capability has been offering enterprises an "odd reality": firms can find a new market, product or price level that was previously out of reach using intuition-based decision-making.

However, to achieve this, companies need to re-approach big data analysis. EWeek contributor Eric Lundquist revealed that asking a simple query over a large, real-time set of data is a more accurate and effective way to gain value from these projects than creating sophisticated algorithms for smaller samples.

This process can be applied to a number of indicators, including customer sentiment, weather forecasting, sports predictions or financial services. As long as firms take a new approach to business analytics, almost anything is possible.

RDX's business intelligence and big data experts assist customers in leveraging data contained in large data stores. For more information, please visit our Business Intelligence and Predictive Analytics pages or contact us.

A guest post by Natalia Rachelson, Senior Director, Outbound Product Management, Oracle Applications

It was with a mixture of excitement and anxiety that I boarded a plane at Chicago’s O’Hare bound for San Francisco last week — excitement because it had been a while since I’d been to Oracle Headquarters and I was craving to see familiar faces and places, and anxiety because this wasn’t just any business trip. I was traveling to attend and assist with Oracle Analyst World (OAW).

OAW is an annual gathering of leading industry analysts and influencers from firms such as Gartner, Forrester, and IDC, who arguably help shape the future of our industry. Analysts and influencers can be somewhat fickle and tend to favor the “flavour du jour” rather than a well-established incumbent in any given space. In fact, when it comes to convincing the influencers and creating buzz, I would venture to say that incumbents in the enterprise space have to work twice or even three times as hard compared to new entrants. Think Helen Mirren vs. Jennifer Lawrence.

Hence, my uneasiness about OAW running smoothly and hitting all the right notes with our challenging audience. But, who doesn’t love a good challenge?

Let The Conference (And The Tweeting) Begin

Oracle’s Chief Communications Officer Bob Evans kicked off Day 1 by talking about simplifying IT, the power of innovation, and our strategic initiatives. The 100+ analysts and influencers tweeted conscientiously and consistently throughout the conference. Here are some sample tweets: Darren Bibby from IDC, Alan Lepofsky from Constellation Research, Michael Krisgsman from Asuret, and me.

Next up, Executive Vice President John Fowler discussed Oracle’s Engineered Systems. And Thomas Kurian gave our influencers an update on Oracle’s software strategy. Bob Evans, an IDC analyst, and I tweeted the news.

Then Oracle President Mark Hurd took the stage for an open Q & A session. He talked about how Oracle is focused on customer outcomes and how we do not, as a company, set out to be hard to work with. (Smile) Oracle’s Chief Customer Officer Jeb Dasteel discussed Oracle’s customer satisfaction programs.

Tracks and Takeaways

After lunch, the analysts chose one of six tracks to go deeper in their area of focus: 1) Cloud Computing, 2) Next-Generation Business Processes, 3) Business Analytics, 4) Information Management, 5) Business Applications, and 6) Data Center Modernization. Here are my takeaways from the Cloud and Apps sessions I attended.

• Oracle clearly sees that Cloud Computing will be propelling our industry forward for the foreseeable future. It is a shift in the industry and Cloud Computing is here to stay.
• Oracle, unlike anybody else, is poised to be a winner across all Cloud components, including PaaS, IaaS, and SaaS
• When it comes to business applications, we are taking a customer-centric approach and supporting our customers on whatever Oracle platform they happen to be. At the same time, we are also actively educating our customer base about our complete suite of Applications Cloud Services and having conversations with our customers about why they should start looking at introducing Cloud solutions from Oracle within their organizations.
• Both Steve Miranda and Thomas Kurian explained how Oracle amassed the most comprehensive set of Applications Cloud Services in the industry. We started in the Cloud with our 100+ modules of organically grown Fusion applications and enhanced our organic suite through acquisitions with the following industry leading solutions:
• Eloqua for Oracle Marketing Cloud
• RightNow and Inquira for Oracle Service Cloud
• ATG and Endeca for Oracle Commerce Cloud
• Taleo for Oracle Talent Management Cloud
• Vitrue, Involver, and Collective Intellect for Oracle Social Relationship Management Cloud

Customers Help Tell Our Story

The customer panel on Day 2 was one of the most anticipated parts of the conference. Customers representing our entire technology stack spoke to analysts about their experiences with Oracle. The most memorable quote of the day came from Segar Annamalai, CEO at American Career College, whose company is running our HCM Cloud service powered by Fusion.

Segar said that today he is dealing with a different Oracle than he did in the past. He stated that he used to hear from Oracle once a year when his support contract was up for renewal, and maybe one other time when sales reps came knocking on the door for an obligatory cross-sell/up-sell conversation. Things have changed dramatically since then. Segar now has a relationship with Oracle. He talks to Development on a frequent basis, and overall, feels that he is getting the right level of service. According to Segar, Oracle has become a service-oriented company and not just a seller of widgets — and that is what is required of a cloud service provider.

After the panel concluded, analysts got a chance to speak with our customers and executives in a one-on-one setting for deeper insight. Then Chief Corporate Architect Edward Screven talked to the audience about Oracle infrastructure, and Oracle’s Corporate Development and Strategic Planning SVP Doug Kehring talked about our merger and acquisition strategy. Here are a couple of the tweets flying out of the Conference Center from Kehring’s session.

Note: To see a compilation of the tweets from OAW, blogger Holger Mueller published a play-by-play Twitter feed for #Oracle_AR.

Up Close and Personal: The Influencer Roundtable

We ended the three-day conference with a handful of leading influencers meeting with Steve Miranda in a more intimate, friendly setting. The select few included (below from left to right): Vinnie Mirchandani from Deal Architect. Brent Leary from CRM Essentials, Denis Pombriant from Beagle Research Group, and Brian Vellmure from Initium LLC / Innovantage

Miranda confidently spoke to them about Oracle’s most comprehensive Cloud offering for applications, including Oracle Sales Cloud, Marketing Cloud, Commerce Cloud, Service Cloud, Social Cloud, ERP Cloud, HCM Cloud, and Talent Management Cloud. He talked about our progress with Fusion stating that we added 150 more customers since the last publicly disclosed figure of 400 from Oracle OpenWorld 2012.

More facts from Steve that he discussed with the group: About 85 percent of our Fusion customers are going with a SaaS deployment option. We’re switching to a three-times-a-year release schedule for Fusion as a best practice. Customers have about 60 days to take an upgrade, including some weekends for convenience.

When the influencers asked about a “mobile first” design philosophy, Steve explained that we take a triad approach to mobile: ADF for Mobile, task-specific apps, and Oracle Tap for the Cloud, which is now available for Fusion, RightNow, and Taleo apps. Oracle will only invest in those task-specific apps that take advantage of the mobile form factor and features. He used Fusion Expenses as an example. It takes advantage of phone calendar, voice, camera, and contact information. Another example is a time entry app, which takes advantage of a phone’s alarm clock.

Future investments in the Cloud? Steve articulated that Oracle is focused on:

• Integrations
• Vertical capabilities in CRM
• More manufacturing capabilities and SaaS in SCM
• More localizations, third party integrations, and public sector capabilities in ERP

Did We Meet the Challenge?

Only time will tell if we met the challenge of hitting all the right notes with the analysts and influencers. However, we are confident that we impressed this tough audience with substance, vision, and candor. Every one of the attendees had an opportunity to gain an appreciation of the breadth and depth of our business and better understand why customers put their trust in Oracle to help them with their most critical business challenges. They also couldn’t miss the fact that Oracle is playing to win.

And speaking of winning, Brian Sommer of ZDNet wrote in his blog post following the conference, ”Oracle is definitely innovating.” He enthusiastically declared, ”Cloud applications are going to be the future. Oracle’s got a lot going for it here.” We do have a lot going for us – and even more for our customers as they move to the cloud.