For a tech professional, second time’s the charm at Oracle

For Maria, there’s a history
behind her current role as a Practice Manager for Oracle’s National Security
Group (NSG). Before belonging to the NSG, and offering applications consulting
and delivery to its clients as part of the NSG’s Applications group, as well as
being involved in the business development side of things, she had a 14-year
absence from Oracle.

“This is my second time. I
started at Oracle in October 1996 and then left in May of 2001, and then I came
back in January 2016,” Maria recounts. “But when I started back in ’96, I
belonged to Applications Contracts and Sales Consulting,” she adds. So what
made her come back to Oracle? Surely for someone with more than 20 years’
experience in the consulting field—mostly for government and healthcare—,
finding a job almost anywhere else would’ve been easy for her. Despite this,
she decided to return.

“I love that I can apply my
many years of experience with the latest Oracle technology,” Maria says. “Our
organization is not rigid, which makes it easier to reach out to other teams to
collaborate on specific areas where we need more support,” she continues.
“Access to internal training online is seriously unlimited—I am not a very
technical person, but I got my Big Data Analytics certification by taking my
specific learning path,” she also mentions.

But technology isn’t the only
thing that brought Maria back to Oracle. She also has praise for the company’s
culture: “The environment is very different. Oracle has many, many more
opportunities for career development. Management is very interested in making
sure that your ideas are taken into consideration.”

For these reasons, Maria
decided to return to Oracle. And though she’s not the first Oracle employee to
leave for other ventures, she also isn’t the first to return upon remembering
why Oracle is such a great place to work. “Oracle is the whole package. Even
though I was at other companies, I was always talking about Oracle being so
good. The environment is great and the camaraderie is fantastic. It has been a
great experience, and that is why I came back,” Maria concludes.

Interested in joining the
Oracle National Security Group? Learn more about current available
opportunities by reaching out to Lucas Jaramillo
here.

Powered by WPeMatico

Oracle NoSQL Database – Version 4.4 Released

Oracle NoSQL Database – Version 4.4 is now available. 

New Features Include:

JSON indexing – Efficient query processing

Number Datatype – Allows storage of arbitrarily big
numbers with no loss of precision

IS (NOT) NULL Query Operators – Check if a data field is
NULL or not NULL

Learn more and download now at:  http://www.oracle.com/technetwork/database/database-technologies/nosqldb/overview/index.html?ssSourceSiteId=ocomen 

and

http://www.oracle.com/technetwork/database/database-technologies/nosqldb/learnmore/4-4-features-3686573.pdf  

Powered by WPeMatico

Working With Reference Data In A Custom Extension

Introduction and Use-Case

This article provides a fictitious example of one possible option for integrating data from an external system with Oracle Sales Cloud. It’s intended to highlight particular considerations involved and provide an illustration.

Let’s setup a simple use-case. Our business users would like to see some financial performance data when dealing with their customers. This will help them make more informed decisions when managing customer account records. The financial data is held in a secondary proprietary accounting system.  The information required is summary-like data, and as such aggregation and calculation will be required on the source data. The source accounting data is quite complex and the number of records will most likely be high.

Users want this extra information available in-context, ideally inside the Account details page in Sales Cloud, and have asked for fast performance and no additional navigation. This extra financial data is for reference-use only, and no creation or update will ever be made to this data from Sales Cloud. Examples of what users would like to see include:

  • Largest Ever Spend
  • Average Spend
  • Average Spend Last Year
  • Number of Orders Last Year

Implementation Choices

One option might be to setup a live web service call to the secondary financial system to get the accounting data for display. As mentioned the existing system is proprietary and it’s unlikely the exact set of services needed is already available, meaning more development as well as some security concerns in adding API’s to this system. In addition, with a need for multiple calculated values on the page, each web service call and subsequent processing will have a performance overhead. As such this option may not be the best choice here.

A second option to get live data is to create a UI mash-up where a sub-tab is added to the Account object page layout. This has an iFrame region that embeds the user interface of the secondary financial system. This solution is also unsuitable because the need is just for a few data points and not actually financial system access for the sales users.

A final option is to get the results of specific queries on the financial system into Sales Cloud. In this use-case the users do not actually require live data, as such a query can be executed on a regular interval to refresh the data shown (e.g. daily). The query can simplify and denormalize the complex data structures in the financial system (e,g, headers-lines) into a single business object records. It can ensure only the appropriate data is included and that is it executed only by an authorized user. As such this implementation was chosen for use. Let’s look at how this was actually done.

Data Adding and Importing

Firstly a custom object – Invoice_c – is created in Sales Cloud to hold the imported data. In this example we have just a few fields for use in the calculations needed.

Note that the Customer field is a Dynamic Choice List on the Account object. This is because it will ensure the existing customer names are used, and it allows access to both the customer name String and the PartyId stored as the foreign key in the auto-generated Customer_Id_c field. 

The implementation does NOT include generating any ‘Pages’ for this custom object, as it’s just for reference data storage. We do not want anyone creating or updating this reference data through any methods outside our integration solution – like through a UI page.

In the initial population of a high volume of records into this object we use the File-based Loader process. This is described in detail in these articles. Incremental loads can be done using the SOAP or REST custom object web services. First a process queries the financial system to get new data and outputs the records as pre-prepared JSON files. The files are then used by a second process to perform HTTP POST requests to the REST resource at /salesApi/resources/latest/Invoice_c/ with MediaType as application/vnd.oracle.adf.resourceitem+json. An example single record payload is:

{ "RecordName" : "Invoice for April 17", "InvDate_c":"2017-04-18", 
"Customer_c":"Oracle1", "Paid_c":"Y", "OrderID_c":"12347", 
"TotalAmountUSD_c":"2200.50" } 

Now the data is there, we need to display it.

Field Creation

To meet users needs several Formula Fields are added to the Account object, and displayed in the Details page layout. The fields query the Invoice object records, do simple calculation, and display the result.

Formula fields do not actually store resulting values and re-calculate whenever the field is displayed on a page. As such a Field Group was used to reduce the UI clutter and ensure the very latest values are shown when the calculations fire when the group is expanded. Note that the default state for Field Groups is expanded, as such this was deselected in the creation screen so it is collapsed by default.

It should be noted that all formula fields do fire when the page is first rendered, even when inside a collapsed field group. As such performance must be optimized at all times.

Here is our Account page with the Financial Data group and values shown.

Formula Fields

The four fields shown above include the following groovy scripts.

Invoice Average (Lifetime). The script used here instantiates the Invoice_c view object and uses a simple ViewCriteria query based on matching the current customer Account and ensuring the invoices are paid. It then cycles through the results summing the invoice amount values. Finally it divides by the record count and presents in a rounded two decimal value. Note care is taken to check for null values where an Account has no invoices yet.

def amt =0.00 
def vo = newView('Invoice_c')
def thisAcctid = PartyId
vo.appendViewCriteria("Customer_Id_c = ${thisAcctid} AND Paid_c = 'Y'")
vo.executeQuery()
def num = vo.getEstimatedRowCount()
while(vo.hasNext()) {
  def curInv = vo.next()
  amt = amt + nvl(curInv.TotalAmountUSD_c,0)  
 }
if(num>0){
  def rslt= (amt / num)
  return Math.round(rslt * 100) / 100  
 }
return 0

Invoice Average (Last Year). This is mostly the same, with a condition to check the record InvDate matches the current year. It is not possible to convert the year
inside the viewCriteria string therefore it is done later.

def amt =0.00 
def count=0
def vo1 = newView('Invoice_c')
def thisAcctid = PartyId
vo1.appendViewCriteria("Customer_Id_c = ${thisAcctid} AND Paid_c = 'Y'")
vo1.executeQuery()
while(vo.hasNext()) {
 def curInv = vo.next()
 if(year(nvl(curInv.InvDate_c,9999)) == year(today())){
  count++
  amt = amt + nvl(curInv.TotalAmountUSD_c,0)  } 
 }
if(count>0){
 def rslt= (amt / count)
 return Math.round(rslt * 100) / 100
}
return 0

Largest Invoice (Lifetime). Using the same query we simply sort the resulting rows by TotalAmount / descending and get the data from the first record. Because we also (helpfully) return the OrderID_c value in the result of this script it was implemented as a Text Formula field.

def vo = newView('Invoice_c')
def thisAcctid = PartyId
vo.appendViewCriteria("Customer_Id_c = ${thisAcctid} AND Paid_c = 'Y'")
vo.setSortBy('TotalAmountUSD_c desc')
vo.executeQuery()
def curInv = vo.first()
if(curInv){
 def txt = nvl(curInv.TotalAmountUSD_c,0) + ' for OrderID ' 
  + nvl(curInv.OrderID_c,'none')
 return txt
}
return "None"

Invoice Count (Last Year). This simple script combines elements of those above, querying records and counting when the year values match.

def count=0
def vo1 = newView('Invoice_c')
def thisAcctid = PartyId
vo1.appendViewCriteria("Customer_Id_c = ${thisAcctid} AND Paid_c = 'Y'")
vo1.executeQuery()
while(vo1.hasNext()) {
 def curInv = vo1.next()
  if(year(nvl(curInv.InvDate_c,2000)) == year(today())){
   count++
  } 
}
return count

Extra Security

Whilst not mentioned in our use-case requirements, it is possible that not everyone should be able to see this financial data. As such field level data security could be applied in the formula field scripts. The simplest implementation is a preliminary groovy condition to check the users job role, and if not appropriate return an empty string. This technique is discussed here and an example might be:

def secCtx = adf.context.getSecurityContext()
def rslt = secCtx.isUserInRole('ZCA_SENIOR_ACCOUNT_MANAGER')
if(rslt==true){  
 ...scripts above... 
}
return ""


Powered by WPeMatico

Oracle Datenbank 12.2: Oracle Multitenant und lokales AWR

Das Automatic Workload Repository (AWR) kann ab 12.2 auch lokal in den PDBs gespeichert werden.

Das AWR der Oracle Datenbank bietet umfangreiche Daten für
eine Analyse von Performance-Engpässen und sonstigen Problemen, die von
den Anwendungen verursacht werden können und ist mittlerweile für viele
eine unverzichtbare Basis für die Verwaltung von Oracle Datenbanken geworden.

Oracle Multitenant wurde mit der Version 12c Release 1 der Oracle Datenbank eingeführt und bei dieser Version wird das AWR ausschließlich auf der Ebene der CDB gespeichert.
Auch die Erfassungsintervalle werden dabei ausschließlich in der CDB
festgelegt. Da diese Daten nur in der CDB gespeichert sind, werden diese
bei einem Transport von einer CDB zur anderen CDB (Unplug und Plug)
nicht mitgenommen.

Um Oracle Multitenant als Konsolisierungsplattform noch weiter zu verbessern wurde mit der Version 12c Release 2 der Oracle Datenbank eine wichtige Veränderung beim AWR durchgeführt: die für eine PDB relevanten Daten des AWR können sowohl in der CDB, als auch lokal in der PDB gespeichert
werden. Dieses ist wichtig, zum Beispiel dann, wenn eine PDB von einer
CDB zu einer anderen CDB verschoben werden soll und die AWR Daten dabei
in der PDB erhalten bleiben sollen.

Alles Weitere dazu in diesem Tipp.

Powered by WPeMatico

教师视角:如何使用PaaS Service Manager命令行创建Oracle Cloud数据库

Creating and managing databases instances in the Oracle Cloud without the knowledge of the WebService API is possible through the installation of the PaaS Service Manager Command Line.

The installation can be carried out to any Linux compliant with prerequisites for CLI installation and configuration, which are:

 

 


 

‘psm setup’ was successful. Available services are:

o ANALYTICS : Oracle Analytics Cloud

o BDCSCE : Oracle Big Data Cloud Service – Compute Edition

o CONTAINER : Oracle Container Cloud Service

o IDCS : Oracle Identity Cloud Service

o IDCSControlPlane : Oracle Identity Cloud Service

o IOTAssetMon : Oracle IoT Asset Monitoring Cloud Service

o IOTEnterpriseApps : Oracle Internet of Things Cloud – Enterprise

o IOTFleetMon : Oracle IoT Fleet Monitoring Cloud Service

o IOTProdMonitoring : Oracle IoT Production Monitoring Cloud Service

o MySQLCS : Oracle MySQL Cloud Service

o OEHCS : Oracle Event Hub Cloud Service

o OEHPCS : Oracle Event Hub Cloud Service – Platform

o accs : Oracle Application Container Cloud Service

o caching : Oracle Application Cache

o dbcs : Oracle Database Cloud Service

o ggcs : Oracle GoldenGate Cloud Service

o jcs : Oracle Java Cloud Service

 

o stack : Oracle Cloud Stack Manager

The execution of this command is giving the associated services for which configurations can be issued. This list might be different depending on the tool version and your cloud account settings.

The next step then is to prepare a json file, which will be used to create and start your dbaas services.

The configuration of this json file is reflecting the Web Api of the dbaas.

A simple container db => ESORCL, with one PDB=> ESPDB1, demos and Goldengate capabilities , with the “shape”: “oc4” will be created.

The execution then of the following command will create the service:

[oracle@bigdatalite dbaas]$ psm dbcs create-service -c create-ESdb.json

“Accepted”

Job ID : 4560513

The following command will help you to monitor the creation of this service:

[oracle@bigdatalite dbaas]$ psm dbcs service -s ESdb12c-ee-v3

{

    “service_name”:”ESdb12c-ee-v3″,
“version”:”12.1.0.2″,
“status”:”In Progress”,
“description”:”ESdb12c-ee-v3″,
“identity_domain”:”XXXXXX”,
“creation_time”:”2017-03-15T10:20:27.977+0000″,
“last_modified_time”:”2017-03-15T10:20:27.956+0000″,
“created_by”:”XXXX”,
“sm_plugin_version”:”17.1.5-542″,
“backup_supported_version”:”16.2.3″, “service_uri”:”https://psm.europe.oraclecloud.com:443/paas/service/dbcs/api/v1.1/instances/XXXXX/ESdb12c-ee-v3″,
“num_nodes”:1,
“level”:”PAAS”,
“edition”:”EE_HP”,
“shape”:”oc4″,
“subscriptionType”:”HOURLY”,
“creation_job_id”:”4560513″,
“num_ip_reservations”:1,
“backup_destination”:”BOTH”,
“cloud_storage_container”:”https://XXXX.storage.oraclecloud.com/v1/Storage-XXX/XXx”,
“cloud_storage_pass”:”*****”,
“cloud_storage_user”:”****”,
“failover_database”:false,
“rac_database”:false,
“sid”:”ESORCL”,
“pdbName”:”ESPDB1″,
“demoPdb”:”yes”,
“listenerPort”:1521,
“timezone”:”UTC”,
“charset”:”AL32UTF8″,
“ncharset”:”AL16UTF16″,
“goldenGate”:”true”,
“is_clone”:false,
“clone_supported_version”:”16.3.1″,
“service_associations”:[],
“active_jobs”:[
{
“active_job_operation”:”create-dbaas-service”,
“active_job_id”:4560513,
“active_job_messages”:[]

},

{

“active_job_operation”:”start-db-compute-resources”,
“active_job_id”:4560516,
“active_job_messages”:[]
}
],

“compute_site_name”:”EM002_Z17″,
“jaas_instances_using_service”:””

}

Notice the status of the job => “status”:”In Progress”,

Job ID : 4560513 => “creation_job_id”:”4560513”

After about 20 minutes, the same command shows the status of your new service and the IP address of your VM.

[oracle@bigdatalite dbaas]$ psm dbcs services -o verbose

{ “uri”:”https://psm.europe.oraclecloud.com:443/paas/service/dbcs/api/v1.1/instances/ouopc006?outputLevel=verbose”,
“service_type”:”dbaas”,
“implementation_version”:”1.0″,
“services”:[
{
“service_name”:”ESdb12c-ee-v3″,
“version”:”12.1.0.2″,
“status”:”Running”,
“description”:”ESdb12c-ee-v3″,
“identity_domain”:”ouopc006″,
“creation_time”:”2017-03-15T10:20:27.977+0000″,
“last_modified_time”:”2017-03-15T10:20:27.956+0000″,
“created_by”:”XXX”,
“sm_plugin_version”:”17.1.5-542″,
“backup_supported_version”:”16.2.3″,
“service_uri”:”https://psm.europe.oraclecloud.com:443/paas/service/dbcs/api/v1.1/instances/ouXXXX/ESdb12c-ee-v3″,

“database_id”:”0″,
“num_nodes”:1,
“level”:”PAAS”,
“edition”:”EE_HP”,
“shape”:”oc4″,
“subscriptionType”:”HOURLY”,
“creation_job_id”:”4560513″,
“num_ip_reservations”:1,
“backup_destination”:”BOTH”,
“cloud_storage_container”:”https://XXXXX.storage.oraclecloud.com/v1/Storage-XXXXX/XXX”,
“cloud_storage_pass”:”XXXXX”,
“cloud_storage_user”:”XXX”,
“failover_database”:false,
“rac_database”:false,

  “current_version”:”12.1.0.2.161018″,
“sid”:”ESORCL”,
“pdbName”:”ESPDB1″,
“demoPdb”:”yes”,
“listenerPort”:1521,
“timezone”:”UTC”,
“em_url”:”https://XXX.XX.XX.XX:5500/em”,
“connect_descriptor”:”ESdb12c-ee-v3:1521/ESPDB1.XXXXX.oraclecloud.internal”,
“connect_descriptor_with_public_ip”:” XXX.XX.XX.XX:1521/ESPDB1.XXXXX.oraclecloud.internal“,
“apex_url”:”https:// XXX.XX.XX.XX /apex/espdb1/”,
“glassfish_url”:””,
“dbaasmonitor_url”:”https:// XXX.XX.XX.XX /dbaas_monitor”,
“charset”:”AL32UTF8″,
“ncharset”:”AL16UTF16″,
“goldenGate”:”true”,
“is_clone”:false,
“clone_supported_version”:”16.3.1″,
“service_associations”:[],
“compute_site_name”:”EM002_Z17″
}

With this public IP, we can then connect to our instance with Putty by giving out private key in the Auth configuration section of the Putty.

 

 

 

 

In the Putty prompt, provide “oracle” as the user. You are then logged into your cloud instance.

 

The service is up, as you can see in the following picture:

And that’s all.

In the next series, we will show you how to configure some other parts of your cloud database, clone, backup and migrate – either by using a normal DBA command or using ansible to enable automation of your deployments.

 

 

Powered by WPeMatico

My Oracle Support メンテナンス実施のお知らせ(4/29)

My Oracle Supportはネットワーク・メンテナンス実施のため、以下の日程で一時的にサービスが中断する場合があります。

  • 日時: 2017年4月29日(土)13:30 ~ 16:00
  • 対象ユーザー: My Oracle Support をご利用のお客様

上記の時間中でも、My Oracle Support ナレッジ・ベースはhttps://support-lite.oracle.com/から検索機能をご利用いただくことが可能です。

パッチや必要な情報の入手等を事前に計画して頂くようお勧めします。システム停止中にお電話の必要がある場合、すぐにご利用いただくことが可能です。お問合せにはお電話をご利用下さい。

お客様にはご不便をお掛けし、誠に申し訳ございません。

オラクル カスタマ・サポート

Powered by WPeMatico

5月18日開発者向けイベント@品川

世界20都市で開かれるイベントの東京版は5月18日です。まだ空席ありますのでぜひお申込みください。

Tokyo | Oracle Code 2017 | Live for the Code

Oracle Codeは世界中の技術者を対象に、最新技術動向や、ユースケース、トレンドに関するノウハウや技術情報が入手できる開発者のためのイベントです。

私もセッションで話す予定です。

Powered by WPeMatico

Just how fast is TimesTen In-Memory Database?

The TimesTen In-Memory Database can have excellent performance on even commodity hardware. RDBMS performance has two important factors, latency and throughput. Latency is about how fast SQL Select, Insert, Update, Delete or Merge operations can be completed. TimesTen is known for enabling really low latency SQL transactions. We measure TimesTen latency in microseconds rather than milliseconds:

TimesTen latency on commodity hardware

This latency benchmark was run on commodity Linux / Intel hardware:

  • 2 CPU sockets, 22 cores/socket, Intel Xeon E5-2699 v4 @ 2.20GHz
  • The benchmark is TPTBM for Reads and Updates
  • TimesTen 11.2.2.8.0 (100M rows of data, DB is 17 GB)

Having really low latency also helps with throughput. RDBMS throughput is defined in terms of (ACID) transactions per second.

TimesTen Throughput on commodity hardware

This throughput benchmark was run on the same commodity hardware:

  • 2 CPU sockets, 22 cores/socket, Intel Xeon E5-2699 v4 @ 2.20GHz
  • The benchmark is TPTBM for mixed workload (80% reads, 10% updates, 5% inserts and 5% deletes)
  • TimesTen 11.2.2.8.0 (100M rows of data, DB is 17 GB)

The performance of TimesTen is dependent on the workload and hardware.  These TPTBM benchmarks used primary key lookups and the SQL statements in each transaction only affected a few rows.  If your SQL workload has complex joins for many tables or returns a huge number of rows then these operations will take longer.  The hardware that the workload runs on also affects the performance.  Faster CPUs in terms of GHz, size of the L3 cache and number of cores tend to give better TimesTen In-Memory Database performance.

Download and try TimesTen In-Memory Database with your workload.  The TimesTen Quickstart Guide will lower the learning curve.

Disclaimer: these are my personal thoughts and do not represent Oracle’s official viewpoint in any way, shape, or form.

Powered by WPeMatico

Integration at the Speed of Business

Being recognized by Gartner as a Leader in Enterprise Integration PaaS (iPaaS) in just two years of inception has been one of the most welcome news yet for our team in 2017.  Click here for the report.

With the explosive growth in the number of SaaS and PaaS solutions in the past few years, Cloud has transformed into a “best-of-breed playground” where organizations mix and match “specialized” applications that have a specific business function/pillar (for e.g. Sales, Service, Marketing, Talent Management, Payroll etc) and then integrate them to build end to end business solutions. 

Enterprise iPaaS platforms have been the new favorite with the Cloud-boomers, with their modern user experience and ease of use, helping bring down costs, accelerate time to market. They also help enterprises find budget and resources for growth-focused innovative projects that can help them differentiate against their competition. In fact, according to Gartner, this fervent demand for and growth of iPaaS is reflected in the growing market segment estimated at around $11 billion today with over 120+ iPaaS vendors in the market today, and projected to hit nearly $15 billion by 2020.
However, there are dangers lurking for organizations who perform the move without having a well-thought-out organization-wide cloud strategy.  The truth is that most organizations move to the cloud “incrementally” from within various business units where each team drives their own functional requirements, as well as their own vision of cost savings, simplicity and efficiency. Without an organization-wide cloud strategy, each team drives their own choice of cloud solutions without understanding the organization-wide impact. In the absence of cloud strategy, enterprises continue to spend more time integrating and managing a “Frankenstein” solution rather than spending time in revenue-generating, innovation-focused projects that can help drive growth.  
Cloud helps you to simplify, but it does not change the laws of physics. The more unrelated elements you have in a system, the more issues and problems you’ll have in the implementation and operation—and the more headaches you’ll face every time you do an update.

John Chorley

– Jon Chorley, GVP, Oracle SCM Cloud

Within Oracle Custoemrs and Organizations who have been successful cloud adopters, Business, IT and LOB/Apps IT Business Units work closely with each other, yet autonomously, knowing very well that modern iPaaS platforms are no magic pill to avoid spaghetti architectural nightmares in the cloud. It takes “Practical Governance,” strategy and processes in the organization to effectively embrace the cloud. Integration is far less a “technical” exercise and far more a “strategy exercise” when it comes to measuring its long term effectiveness within any enterprise.

When Oracle started its journey of Integration in the Cloud a few years ago, we had three key objectives in mind.

1. Simplify SaaS integration as much as possible.

    • This made a lot of sense for us to focus on to start with. Oracle itself has a large SaaS footprint, so this was critical for us as well. SaaS applications from Oracle such as Sales Cloud, ERP and CPQ Cloud, as well as those from third parties such as Salesforce, ServiceNow or SuccessFactors, are diverse in form-factors – underlying data models, security policies, APIs, integration patterns (real-time, bulk/batch, file-based), etc.  The magnitude of the challenge multiplies with the number of apps being on-boarded within organizations. This rate of adoption and uptake has been on a phenomenal rise as well. Mid-to-large organizations own, on an average, more than 23 SaaS Applications across their enterprise. Plus, you are talking about more than 2300+ SaaS applications in the marketplace today. Talk about scale!

2. Enable ad-hoc and citizen integrators to be able to build and deliver integrations quickly on the platform.

  • Unlike earlier when IT had massive budgets and long running projects, several of the new integration projects are now being driven by Lines of Business. As an example, a VP of Sales had annual budgets to modernize Sales Automation. Their team of Apps IT designers were tasked to deliver the solution that involved integrating data and processes amongst various applications. However several of these designers had little to do with traditional integration and middleware technologies in their career.  These users were predominantly functional experts with some range of technical skills. They usually look for a modern simple application-centric approach to integration where the focus was more on the functional end to end experience. These teams care less about the fine-grained control and configuration that traditional SOA offered, and more on ease of use.

3. Enable customers to harness the data and value of their existing on-premises application assets and middleware platforms 

  • Oracle’s large footprint of 7000+ on-premises middleware customers and over 100,000+ on-premises Database and Enterprise application customers (such as EBS, JDE, Siebel, etc) reflect the scale of the market-segment of enterprises that continue to have application and middleware footprint in their data centers. A large majority of these enterprises already have a cloud strategy in planning and/or execution phase, but they aren’t eliminating their on-premises footprint any time soon.  Several of these customers want to use the cloud for their digital transformation projects, however the data ownership or residency could continue to be within the on-premises applications.  There could also be several business processes running on-premises integrating various resident home-grown systems, enterprise applications and/or trading partners that the customer wishes to continue leveraging.  So enabling a hybrid platform for integration was extremely important for ensuring organizations can progressively embrace the cloud – meaningfully.  

The past two years have seen us come a very long way, not only in our customer-base (We have grown our iPaaS customer-base five-fold increase in the last two years), but also with respect to significant maturity and completeness of our vision. This is reflected in how our customers and analysts are perceiving us today. 
Today, Oracle’s iPaaS portfolio is an extremely rich set of capabilities over various offerings
  • Integration Cloud Service (elevated zero-code integration for ad-hoc integrators – optimized for SaaS Integration)
  • SOA Cloud Service (Powerful SOA for Integration specialists),
  • Process Cloud Service (For Process Automation – Zero code)
  • Managed File Transfer Cloud (Secure file exchange – zero code)
  • Integration Insight Cloud (Analytics for ad-hoc Integrators)
  • API Platform Cloud (For API Design, Management, Discovery and Consumption)
From just over 5 native connectors to on-premises enterprise applications and just one SaaS Connector back in 2015, we have “hyperlooped” to more than 50 feature-rich connectors to various SaaS applications from Oracle and key third party SaaS apps. These connectors/adapters are directly sold and supported by Oracle – and several of these adapters are built and delivered by the SaaS vendors themselves. Being a part of the organization that is also the largest SaaS vendor in the world has also helped our teams understand and work together with various SaaS strategy teams to understand the nitty gritties of the SaaS integration pain-points, key use-cases, and thus ensure that the APIs, integration patterns, practices etc are best in class and supported natively within the platform to simplify SaaS Integration.

Adapters

Figure 1: The Adapter Library within Oracle Integration Cloud Service

With connectivity challenges, also come security challenges. With the Integration platform running in the Cloud, outside of the enterprise data center, Security is a critical focus to all enterprises. Oracle’s vision is to create the most secure and trusted public cloud infrastructure and platform services for enterprises and government organizations. It’s mission is to build secure public cloud infrastructure and platform services where there is greater trust – where Oracle customers have effective and manageable security to run their workloads with more confidence, and build scalable and trusted secure cloud solutions. In fact, Oracle has published an Oracle Cloud IaaS and PaaS Security whitepaper that outlines the security capabilities of Oracle Cloud. In addition to this, Oracle iPaaS provides powerful and flexible security policies at all layers of communication- Transport level, Message level, and even custom policies, depending on the application. All key security policies such as SSL/TLS, WS-Security, HTTP Basic Auth, SAML, OAuth etc and so on are supported within the iPaaS platform.  One of the critical security facets of having an integration platform in the cloud is the requirement to securely integrate with applications and endpoints within the customer’s enterprise (e.g. an EBS PL/SQL API or an SAP BAPI). ICS comes with a secure Connectivity Agent that enables secure connectivity to any on-premises application without needing to open up a pinhole in the Customer’s firewall. This helps enterprises have shorter and more effective conversations with their security teams while on-boarding their iPaaS platform in the Cloud.

The increased number of traditional “SOA” middleware customers embracing the cloud also brought forward major Enterprise-Readiness requirements to us – including more advanced integration constructs, enterprise-grade orchestration, monitoring and error handling capabilities etc and so on.  Several of these customers expect the same elevated “zero-code” user experience of ICS while modeling more advanced multi-step orchestrations. While we were designing and delivering these next-generation capabilities, we did UX and functional design-partnership with “Integration Specialists” from several of these early-adopter customers from the “SOA” side to ensure that the new rich user-experience on the Web is more elevated, require users to understand lesser number of concepts and underlying technical details while delivering the same power-packed functionality.  Today, ICS supports a modern multi-step orchestration designer and runtime with rich logical constructs for conditional routing, iterations, scheduling, fault handling and so on, with advanced resiliency features, all with no-code.  
 Figure 2: The zero-code Orchestration designer with “No source view”
These elevated experiences, in no way, makes SOA less significant for enterprises. Requirements for advanced SOA will continue to exist for several enterprises – SOA helps organizations implement medium to very complex use-cases, and provide the integration specialists the much required control over the ecosystem through its powerful toolsets, scripts and management consoles.  Being able to run SOA in the Cloud using Oracle SOA Cloud Service, an integral part of Oracle’s iPaaS portfolio, provides an easy way for customers to quickly provision and run SOA projects in the cloud, including dev/test (and thus avoid major operational expenses and project delays), and/or lift-shift existing SOA projects from on-premises to the Cloud to accommodate a shift in the Application center of gravity.
Together with ICS and SOACS, customers can run a true Bimodal practice in their organization and help overcome two critical competing priorities – the priority to provide advanced, stable, secure, high performance services and that to deliver, innovative, technology-intensive services quickly.

I would also like to add another popular and critical aspect of our ecosystem – a large partner community – delivering connectivity and pre-built solutions for our platform. These connectors and packaged integrations will be available on our Cloud Marketplace for discovery and use within your integrations.

The Oracle Integration and API Partner summits are now running across various cities in North America and across the globe – all of them are currently overbooked. In fact, we just wrapped up an exciting, well attended summit at Reston, VA on Integration and APIs.  Partners have been working with us on various fronts. Several of them work with us on native connectivity/integration with several applications such as Adobe eSign, MS Dynamics CRM and several others.  Some of the partners have delivered packaged integrations between various apps such as Salesforce.com, SAP, Ariba, Successfactors and so on, whereas others have built dedicated Center of Excellence and Practice for delivering Integration projects on Oracle’s Integration Cloud Platform.  With the breadth and skillset available on the product and platform, customers won’t have shortage of skill sets when it comes to engaging a skilled SI to deliver an integration project on Oracle iPaaS.

The capabilities do not stop here. There is the rich process designer for the human element in business processes, the very critical API-driven experience with Oracle’s API Platform which allows organizations to  deliver and consume capabilities incrementally and scalably within and across enterprises, the Integration Analytics that is so easy to use for critical Business Insight into important transactions, the Self Service Integration Cloud that Business Users can use to automate their critical day to day business activities with absolutely no knowledge of Integration technologies and so much more!

The difference between “Vision with the Cloud” and a “Clouded Vision” is all about your understanding of the business challenges involved in your move/execution in the cloud, choice of products and platform your organization has chosen for building a solution.  It all all boils down to your organizations’ overall cloud strategy – getting that right, and across all your teams is most important.  With Oracle’s iPaaS platform, we try to simplify a critical part of that problem – the pervasive integration challenge – and I believe we’ve got good at it!

Powered by WPeMatico

通过物联网(IoT) 培训实现业务转型

Diana.H.
Gray
Oracle2017330


骨文大学课程产品经理
Jim Moniak参与撰写

想像一下,当生活中所有的一切都与各种各样的设备互联,世界将变成什么样?

· 带有内置传感器的汽车可监控您的冰箱

· 可挽救生命的跟踪设备跟随您日常的每个活动

· 您的家庭安全系统全自动化

所有这些数据看起来似乎并无关联,但我们可以通过互联网和现有的网络基础设施进行远程跟踪。

这为远程收集数据、处理数据以及用数据背后的情报创造新的可能提供了巨大的机会。

Oracle致力于通过新的云计算解决方案来扩大物联网(IoT)产品组合范围,帮助企业检测、分析和采用支持IoT的设备。

甲骨文大学很高兴通过Oracle平台即服务(PaaS)云端学习订阅为您提供培训,深化您对该领域的理解。

欢迎您选择我们的物联网频道提供的全天候数字培训内容:

· 物联网(IoT)云服务介绍

· IoT概念

· 注册远程设备

· 将数据从设备转发到企业应用程序

· 使用Stream Explorer分析数据

· 如何使用IoT资产监控云

· 集成IoT和集成云服务(ICS

· IoT与移动云服务和大数据云服务集成

· 使用RESTIoT云服务

· IoT云服务发送数据至商业智能(BI)云服务

· IoT Cloud Service Gateway开发设备适配器

· 创建简单的仪表板

该订阅将随技术的发展同步跟进,因此该频道将不断添加更多主题。

立即购买Oracle平台即服务(PaaS)云端学习订阅,获取12个月内无间断更新的数字培训内容!


Powered by WPeMatico