Feed aggregator

From Home Kitchen to Multimillion Dollar Business: hint® Achieves Rapid Growth on NetSuite

Oracle Press Releases - Tue, 2018-04-24 12:00
Press Release
From Home Kitchen to Multimillion Dollar Business: hint® Achieves Rapid Growth on NetSuite NetSuite Helps Pioneering Healthy Lifestyle Company Innovate and Scale in a Crowded Market

SUITEWORLD18—LAS VEGAS—Apr 24, 2018

hint inc., a San Francisco-based provider of unsweetened, fruit flavored water, has grown from a family-run business to a multimillion-dollar company in just a decade with NetSuite. As its founder eyes growth targets of $1 billion, NetSuite will enable hint® to scale its critical business systems as it goes toe-to-toe with industry giants.

Started by Kara Goldin in the kitchen of her San Francisco Bay Area home in 2005, hint was inspired by Goldin’s personal health journey. To replace her 10-can-a-day Diet Coke habit and stay off the soda, Goldin wanted to make water more drinkable and started to experiment by adding fruit into pitchers of water. After rave reviews from her friends and family, and the failure to find a similar unsweetened flavored water in the market, Goldin pitched the idea to Whole Foods. An initial 10 cases sold out overnight and within six months, hint water was on the shelves of Whole Foods stores nationwide. To support this rapid growth, scale the business and ensure products are manufactured as close as possible to the point of distribution, hint selected NetSuite.

“I didn’t set out to launch a beverage company, but as I learned more about the options available to consumers, I realized that it was time to shake things up,” said Goldin, a former long-time AOL executive. “The market was ready, but it was still dominated by centuries-old stalwarts. To have our voice heard in such a crowded space, we needed to couple all of our startup energy and enthusiasm with business processes that allowed us to operate like a much larger firm. NetSuite has given us a platform to grow our business so that we can focus on delighting our customers.”

With NetSuite, hint has been able to avoid IT complexity as its business has grown by automating inventory and order management practices with financial and accounting processes from a very early stage. By adopting business process best practices of much larger organizations from the beginning, hint has been able to quickly capitalize on market opportunities. Building on this success, hint started selling direct to consumers in 2014 and B2C sales now make up a huge percentage of hint’s business.

“hint offers so many lessons on purposeful growth, from its very inception, to the way it continues to influence the industry,” said Jim McGeever, executive vice president Oracle NetSuite. “We are excited to partner with the hint team to help support its next stage of growth.”

Contact Info
Michael Robinson
Oracle NetSuite Corporate Communications
781-974-9401
michael.s.robinson@oracle.com
About hint Inc.

hint inc., the San Francisco-based company founded by entrepreneur Kara Goldin in 2005, is a healthy lifestyle brand known for its delicious unsweetened flavored water. hint® makes it easier and more enjoyable for consumers to live healthier lives. The company’s products have received numerous accolades, including Best Flavored Water (Health, Men’s Health, and SELF), Best New Product (Better Homes and Gardens) and the Silver Stevie Award for Best New Product. Since its launch, hint has been making water taste great without adding any sugar or diet sweeteners. hint’s brands include its flagship product, hint water, its sparkling product line, hint fizz®, and its lightly caffeinated line, hint kick®. hint recently expanded its product offerings into other health and wellness categories with the launch of hint sunscreen spray, a SPF 30 mist that is oxybenzone and paraben-free and scented with hint fruit essences. hint’s products are available nationwide in most major specialty and grocery stores and are available at drinkhint.com for delivery direct to your door. For more information, visit www.drinkhint.com..

About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries.

For more information, please visit http://www.netsuite.com.

Follow NetSuite’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Michael Robinson

  • 781-974-9401

NetSuite Unveils World’s First Intelligent Cloud Suite

Oracle Press Releases - Tue, 2018-04-24 11:45
Press Release
NetSuite Unveils World’s First Intelligent Cloud Suite Artificial intelligence and machine learning deliver insights, automation and intelligent interactions

SUITEWORLD18—LAS VEGAS—Apr 24, 2018

Providing customers with the tools and insight required to meet rapidly evolving business demands, Oracle NetSuite today announced the world’s first intelligent cloud suite. By natively building powerful artificial intelligence and machine learning-based capabilities within its leading cloud business management suite, NetSuite can deliver the insight, interaction and automation customers need to grow their business.

“A pioneer in the cloud, NetSuite has long been a leader in providing powerful business intelligence across its suite,” said Jim McGeever, executive vice president, Oracle NetSuite. “With new artificial intelligence and machine learning capabilities within NetSuite, we’re equipping our customers to understand not only what’s happened with their business, but what will happen in the future and how they can stay ahead.”

Businesses can no longer rely on backward-looking data or traditional business intelligence (BI) systems to successfully grow, scale and adapt to change. To provide the real time-insights businesses need today, NetSuite has built upon its existing native BI functionality by incorporating advanced machine learning and sophisticated data science within its unified cloud suite. The new intelligent cloud combines NetSuite and third-party data to enable businesses to make proactive and timely decisions and take action from right within the NetSuite application. 

“A future where AI drives new business models is quickly becoming the present,” said R “Ray” Wang, principal analyst and founder, Constellation Research. “Having business applications that can deliver predictive, prescriptive and automated outcomes is going to be an imperative for businesses that want to grow and succeed in the years to come.”

The new artificial intelligence and machine learning based capabilities enable businesses to glean better insights, drive efficiencies by further automating processes and determine the next best action with predictive actions. The intelligent cloud suite can deliver benefits to business users across the organization.

  • Finance and Procurement Professionals: AI and machine learning enables finance professionals to improve audit risk analysis, analyze past payment history with vendors and customers and enhance cash flow predictions, a key pain point for growing businesses.
  • HR Professionals: AI and machine learning enables HR professionals to create profiles of the best candidate based on existing top performers, predict high performers who might be a flight risk and better automate employee self-service by identifying what questions employees might have based on role, time of year or other factors.
  • Supply Chain Professionals: AI and machine learning offers supply chain professionals the potential to not only identify risks or potential upcoming problems in the supply chain but, as it learns, provide potential solutions.
  • Manufacturing Professionals: AI and machine learning helps manufacturing professionals optimize labor schedules in the warehouse based on past performance or predicted demand and identify machinery in need of maintenance before it becomes a problem.
  • Commerce Professionals: AI and machine learning helps commerce professionals significantly boost searchandising and improve online sales and conversions by serving up products customers are more likely to buy based on key indicators such as past purchases, search history and results of similar buyers.
  • Customer Services Professionals: AI and machine learning provide customer service professionals with more accurate results around total customer lifetime value by using predictions of costs to the support organization, anticipated satisfaction and information on a customer’s likelihood of renewal.
  • Marketing Professionals: AI and machine learning help marketers improve campaign optimization by identifying what type of campaigns lead to a conversion with what frequency and what type of sale based on demographics, a profile within the customer base, and activity on the website, at events or other available data points.
  • Sales Professionals: AI and machine learning for sales teams support intelligent interactions guiding agents through the sales process, personalizing it for the prospect, the product and upsell, and cross-sell opportunities.
 

“Data is the new gold. With NetSuite, we have real-time insights and visibility into all of our key performance indicators, enabling us to make lightning fast decisions,” said Tony Drockton, Founder and CEO of Hammitt, a Los Angeles-based luxury accessories brand. “Building in intelligence and automation will make using NetSuite easier and more powerful than it already is.”

Contact Info
Michael Robinson
Oracle NetSuite Corporate Communications
781-974-9401
michael.s.robinson@oracle.com
About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials/Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries.

For more information, please visit http://www.netsuite.com.

Follow NetSuite’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle.

Talk to a Press Contact

Michael Robinson

  • 781-974-9401

NetSuite Enables Businesses to Launch an Online Store Within 30 Days

Oracle Press Releases - Tue, 2018-04-24 11:30
Press Release
NetSuite Enables Businesses to Launch an Online Store Within 30 Days New ecommerce solution gives customers the freedom to grow and evolve their online business

SUITEWORLD18—LAS VEGAS—Apr 24, 2018

Empowering businesses to quickly and efficiently deliver engaging online experiences, Oracle NetSuite today announced an innovative new ecommerce product. The latest release of SuiteCommerce enables businesses to launch a sophisticated online store within 30 days and provides the freedom to grow and evolve to meet the changing needs of shoppers. The first 1,000 customers to sign up for SuiteCommerce get implementation included for pre-defined themes*. To learn more about the offer, sign up here.

“With SuiteCommerce, businesses can quickly and easily launch, manage and enhance their ecommerce site. From day one, they get a single, unified solution that supports their entire business and will be the first and last system they will ever need,” said Jim McGeever, executive vice president, Oracle NetSuite. “Most importantly, our unique approach puts an end to long, costly implementations and allows customers to get the most they can from their commerce investment.”

To keep up with ever-evolving customer expectations, merchants need an ecommerce solution they can easily manage, extend and enhance without development resources. The new NetSuite commerce solution meets this need by providing themes, accelerated deployment, drag-and-drop site management tools and plugins to extend site capabilities. In addition, ecommerce is integrated with the NetSuite platform so businesses gain the advantage of having a single source of real-time order, customer and inventory information to create seamless omnichannel brand experiences and streamline business processes.

“SuiteCommerce is the perfect solution for us,” said Bob Sullivan, CEO and owner of DASH Medical Gloves, a leading supplier of high quality protective gloves for a variety of industries. “It’s amazing how much you can do without a lot of technical knowledge. The fact that we can go in and make changes to the site, add new products or run promotions with simple drag-and-drop tools is extremely valuable. The beauty of this approach is that we can continually evolve our website to meet changing customer needs.”

SuiteCommerce delivers:

  • Full-Featured SaaS Ecommerce: By supporting B2C and B2B ecommerce on the same platform, SuiteCommerce provides uniquely branded, relevant shopping experiences that drive online engagement and conversion. To help businesses further increase engagement, a selection of themes optimized for performance, engagement and conversion are available. All themes are fully responsive to provide a consistent experience no matter how shoppers browse the store.
  • Easy to Implement: Rapid site implementation enables faster time to value, increased business efficiency and greater customer satisfaction. By leveraging the knowledge, experience and best practices from thousands of ecommerce deployments, SuiteSuccess for SuiteCommerce enables customers to get a best-in-class B2C or B2B online store with commerce reports, dashboards and KPIs within 30 days.
  • Easy to Manage: Drag-and-drop site management tools allow non-technical users to edit pages and manage content. This gives business users the ability to update the look and feel of their site without the help of a developer. In addition, users can easily complete multiple changes to the site and then schedule them for future deployment based on business needs.
  • Easy to Extend: Business users can quickly and easily expand the capabilities of their stores with extensions. Extensions are designed to upgrade seamlessly with each release, allowing customers to enhance their site in a way that’s maintainable. To support developers, the NetSuite Commerce Extension Framework provides an API that makes it easy for developers to create their own extensions.
 

* SuiteSuccess for SuiteCommerce implementation service included with the purchase of SuiteCommerce
1. Offer applies only to webstores built with the purchase of NetSuite’s SuiteCommerce Module
2. Offer is available for the implementation of a single webstore hosted under a single domain
3. Offer is only available for implementation services that leverage NetSuite’s pre-defined theme templates for design and functionality of the webstore
4. Offer is valid for webstores that transact in USD only; are subject to a tax jurisdiction(s) within the United States; and display only US English on the webstore
5. Additional descriptions which define webstore functionality, the implementation services, & the provision of training services will be defined in a Statement of Work provided by NetSuite Professional Services
6. Promotional pricing is available for new and current customers who contract for subscription and services on or before 5/31/2018
7. Customers are required to complete the self-paced training class; Getting Ready for Commerce, which is provided at no additional cost, prior to the scheduled start date of any implementation services

Contact Info
Michael Robinson
Oracle NetSuite Corporate Communications
781-974-9401
michael.s.robinson@oracle.com
About Oracle NetSuite

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud financials/Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries.

For more information, please visit http://www.netsuite.com.

Follow Oracle NetSuite’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle.

Talk to a Press Contact

Michael Robinson

  • 781-974-9401

NetSuite Industry Innovations Help Businesses Accelerate Growth

Oracle Press Releases - Tue, 2018-04-24 11:15
Press Release
NetSuite Industry Innovations Help Businesses Accelerate Growth New industry-specific solutions, finance, HR, supply chain and data analytics transform and improve business operations

SUITEWORLD18—LAS VEGAS—Apr 24, 2018

Oracle NetSuite today announced a series of new innovations to help organizations across industries drive growth, reduce costs and quickly and easily achieve the benefits of cloud computing. The latest innovations within the NetSuite platform include new SuiteSuccess industry cloud solutions, enhanced financial management, HR and supply chain capabilities, new innovations for product and service companies, and a powerful new data analytics solution.

Successfully growing a business has never been harder. New technologies, rapidly shifting consumer expectations and evolving industry regulations continue to change the game. For business leaders, this can feel like a no-win situation, particularly as competition continues to increase and results are under the microscope. The latest innovations from NetSuite help business leaders navigate this change, overcome the barriers to growth and successfully scale by delivering industry best practices, new customer engagement models and business optimization methods, more than 20 major enhancements to core business applications and powerful data processing and visualization capabilities.

“Many companies are able to get their businesses up and running only to struggle when the time comes to reach the next stage of growth,” said Jim McGeever, executive vice president of Oracle NetSuite. “With continuous innovation, we give our customers the tools to overcome the barriers to growth.”

New Industry SuiteSuccess Cloud Solutions

To deliver faster time to value, increased efficiency and provide the flexibility to foster growth and customer success, NetSuite is introducing 14 new editions of SuiteSuccess. A unified, and pre-configured industry cloud solution, SuiteSuccess is built on industry leading practices, combining deep domain knowledge with pre-built KPIs and dashboards. The latest editions are designed to meet the unique requirements of micro-verticals and span a variety of specific industries, company sizes and maturity in the cloud ERP journey. The new SuiteSuccess editions include:

  • Starter: Designed for small and rapidly growing company needs, including finance and accounting, order-to-cash and procure-to-pay.
  • Commerce: Designed for retailers and other ecommerce-focused business needs, including website development and order management.
  • Technology Services: Designed for technology services provider needs, including project management, sales, order and financial management.
  • Consulting Services and Consulting Services Emerging: Two new editions designed for consulting services organizations at different stages of growth with finance and accounting, project and resource management.
  • Manufacturing and Manufacturing Emerging: Two new editions support manufacturers at different stages of growth with inventory, supply chain and order management.
  • Food and Beverage Manufacturer: Designed for food and beverage manufacturers, including features for demand planning, tracking and traceability.
  • Advertising, Media and Publishing: Three new editions designed for agencies, media and entertainment and publisher needs, including features for resource allocation, time and expense, and reporting.
  • OneWorld, Administrator and Accounting: Three new editions for existing NetSuite customers are designed to support global growth, enhance the capabilities and knowledge of NetSuite administrators and ensure accounting features within NetSuite are being maximized.

New Vertical Industry Functionality

To help customers accelerate growth while reducing costs, NetSuite has introduced more than 20 major enhancements to its core application. The enhancements include new industry-specific capabilities for product and services companies as well as innovative HR and financials functionality. The latest updates include:

  • Innovations for Product Companies: For companies in industries like manufacturing, wholesale distribution and retail, NetSuite is delivering new features that increase efficiency, deliver greater insights and improve the customer experience. The enhancements include new supply chain control tower, warehouse management, fulfillment, engineering change management, quality management system and landed costing capabilities.
  • Innovations for Services Companies: To help service companies improve profitability, resource management, revenue management and revenue recognition, NetSuite has introduced enhanced project profitability reporting, advanced revenue management enhancements, charge-based billing for ‘time-based rules,’ a new UI for weekly timesheets, a deferred expense waterfall report and new resource allocation grid filters.
  • Innovative Financial Features: To ensure customers have a leading-edge financials solution, NetSuite has reworked its cash management and bank reconciliation functionality in order to streamline the process and give companies better control of one of their key assets - cash. The latest additions include an enhanced online bank statement reconciliation and transaction matching engine, improved bank statement import record capabilities, full translation support for electronic payments and new multi subsidiary customer support.
  • Innovative HR Features: Building on the launch of NetSuite SuitePeople, an HR offering natively built on NetSuite’s unified cloud suite, NetSuite has introduced a range of new capabilities to help HR professionals attract, manage, train and retain talent. New capabilities include a mobile employee directory, payroll dashboard, headcount and turnover analytics, absence management enhancements and integration with Oracle Taleo Business Edition.
  SuiteAnalytics

To help customers make better business decisions, NetSuite has introduced new SuiteAnalytics capabilities, including a powerful consumer grade data exploration tool that brings rapid, secure and meaningful data exploration capabilities to non-technical users enabling them to gain real-time insight into the business without needing to wait for data warehouses to be updated, outdated reports to be written our moving large amounts of important company data to unsecure spreadsheets.

Contact Info
Michael Robinson
Oracle NetSuite Corporate Communications
781-974-9401
michael.s.robinson@oracle.com
About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials/Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit http://www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Talk to a Press Contact

Michael Robinson

  • 781-974-9401

NetSuite Empowers Businesses to Capitalize on Opportunities Presented by World’s Largest and Fastest Growing Economies

Oracle Press Releases - Tue, 2018-04-24 11:00
Press Release
NetSuite Empowers Businesses to Capitalize on Opportunities Presented by World’s Largest and Fastest Growing Economies NetSuite OneWorld adds localized product capabilities and expands in-country presence for businesses in Germany, France, China, Japan, Brazil and Mexico

SUITEWORLD18—LAS VEGAS—Apr 24, 2018

Extending its commitment to helping businesses across the world grow, scale and adapt to change, Oracle NetSuite today announced localized product capabilities and customer support for businesses in Germany, France, China, Japan, Brazil and Mexico. With the new local capabilities and in-country teams, NetSuite further empowers customers to take advantage of one unified business platform to streamline the management of multi-subsidiary operations, achieve consistent processes across countries, support global compliance and gain real-time global insight.

“With ever-changing regulations and evolving customer expectations, it is getting harder for businesses to drive growth both locally and internationally,” said Jim McGeever, executive vice president, Oracle NetSuite. “With new native localizations and customer support, we are giving our customers a complete solution with language, currency, tax compliance and local support teams in six of the world’s biggest and fastest growing economies.”

Germany, France, China, Japan, Brazil and Mexico are among the top 15 largest and fastest growing economies in the world, but increasing competition, shifting customer expectations and constantly changing regulations mean it is harder than ever to capitalize on the opportunities presented by these economies. With the new localized product capabilities and local in-country teams, NetSuite empowers businesses headquartered or operating subsidiaries in these economies to quickly and easily leverage an integrated suite of modern business applications to drive growth, reduce costs and achieve the benefits of cloud computing. 

With customers now operating in 199 countries and dependent territories around the world, NetSuite is the proven cloud ERP business platform of choice for companies operating and growing internationally. The expanded global support further extends NetSuite OneWorld, a real-time, unified global business management platform that enables global businesses to streamline multi-subsidiary operations and achieve real-time visibility into key business metrics at the local, regional and headquarter levels. In addition, to help businesses across the world successfully grow, OneWorld supports 190 currencies, 24 languages, automated tax calculation and reporting in more than 100 countries.

  • Germany: NetSuite has achieved the local IDW PS 880 certifications necessary to validate NetSuite OneWorld for use by companies headquartered in Germany, and subsidiaries of multinational companies with operations in Germany. In addition, NetSuite OneWorld delivers country-specific features and functionality such automated period end closing entries, general ledger impact locking (Storno) and coming later this year, legal central bank reporting Z4/Z5a, fixed asset reporting – Anlagengitter, and bank and cash management updates.
  • France: NetSuite has achieved the first ever formal certification of NetSuite software in the market. OneWorld for French-based companies delivers period end close journals, FEC reporting, (Fichier d’écritures comptables), general ledger impact locking (Storno), Foreign Currency Gains/Losses variance postings (including custom rules), and coming in the next release support for Lettrage.
  • China: NetSuite customers can now open subsidiaries or new businesses in the world’s fastest-growing economy without the need for third-party products or extensive customization. Support for local Chinese requirements includes China-specific Reports and accounting as well as support for the China Golden Tax System.
  • Japan: NetSuite customers can now benefit from an improve user experience that includes enhanced Japanese summarized invoice support and automatic validation of closing and payment date. Summarized invoice support enables users to easily follow the general practice of sending a consolidated statement of all invoices, while automatic validation of closing and payment date capabilities enables users to automatically adjust the payment due dates on an invoice and credit memos if it falls on a weekend or holiday.
  • Brazil: NetSuite OneWorld can support services-based companies in Brazil, the largest economy in Latin America, with further plans to support product-based companies in the next 12 months. Support for local Brazilian requirements includes Brazilian-specific tax support, Nota Fiscal Eletrônica NFS-e (electronic invoices for services), electronic statutory reports and enabling Electronic Payments integrations to local banks.
  • Mexico: NetSuite customers can now benefit from native support for Mexican-based companies including the latest Electronic Invoicing requirements—CFDI 3.3—and Electronic Accounting 1.3.
Contact Info
Michael Robinson
Oracle NetSuite Corporate Communications
781-974-9401
michael.s.robinson@oracle.com
About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials/Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries.

For more information, please visit http://www.netsuite.com.

Follow NetSuite’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Talk to a Press Contact

Michael Robinson

  • 781-974-9401

Oracle Linux 7 Update 5 is out: time to create a new Vagrant Base Box

Darwin IT - Tue, 2018-04-24 09:31
It's been busy, so unfortunately it's already been almost two weeks I wrote my introductory story on Vagrant. Today I happen to have an afternoon off, and I noticed that Oracle Linux 7 Update 5 is out. I based my first boxes on 7.4, so nice moment to start with creating a new Base Box.

De essentials on creating a Vagrant base box can be read here. But I'm going to guide you trough the process step by step, so I hope you will be able to repeat this yourself, using this guide-through.

First of, Vagrant recommends Packer to automate the creation of base boxes. But I'm a bit confused, because in this guide it is apparently stated that this is deprecated by march 2018. I haven't tried Packer yet, but I feel that over the years I created a base VM only a few times. I used to create a base VM that I import/clone to create new VMs over and over again. And often, I start of with a VM that already contains a pre-installed database for instance.

Vagrant has a built in command to create a base box out of an existing VM. That is what I use.
Base box requirementsWhat is a Base Box actually? Well, it's in fact sort of a template that is used by Vagrant to create and configure a new VM and provision that. It should contain the following
  • An OS: I use Oracle Linux 7 Update 5 for this story. I also have a base box with Ubuntu. Ubuntu has some peculiarities I want to discuss later on in this series. For this base box I'll install a server-with-gui. But further as basic as possible.
  • A vagrant user. The vagrant user is used for provisioning the box. We'll place a public insecure key in it, that will be replaced by Vagrant at first startup. We'll add vagrant to the sudoers list, so the user can sudo without passwords.
  • A started ssh daemon:  Vagrant connects via ssh using the vagrant-user to do the provisioning.
  • A NAT (Network Address Translation) Adapter as the first one: needed to do kernel/package updates without further network configuration.
  • VirtualBox GuestAdditions installed: Vagrant makes use of shared folders to map the project folder to get to the scripts. Also it's convenient to add an extra stage folder mapping. 
  • Password of root: not a requirement, but apparently it's a bit of a standard to set the root password to vagrant as ease of sharing. But at least note down the passwords.
That's about it. Maybe I forget something, but since it's digital, I can edit it later... So let's get started.

Download  Oracle LinuxAll the serious enterprise stuff of Oracle can be downloaded at edelivery. Search for Oracle Linux:
Then add the 7.5 version to the Cart by clicking it:

Follow the wizard instructions and you'll get to:
I downloaded V975367-01.iso        Oracle Linux Release 7 Update 5 for x86 (64 bit), 4.1 GB.

Create the VMThe ISO is downloading, so let's create a VM in VirtualBox. I assume VirtualBox with VirtualBox Extension Pack is installed. And for later on Vagrant of course.

From the Oracle VM VirtualBox Manager, create a new VM, I called it OL75, for Oracle Linux 64 bit:
I followed the wizard and gave it 10240 MB memory and a 128GB dynamically allocated virtual disk:

In the VM Settings, I set the number of processors to 4 and for now I kept everything to the default.

In the meantime my download is ready, so in the VM Settings, under Storage I added the disk by clicking the disk icon next to the IDE controller:

Then navigate to your downloaded iso:
and select it. Now the VM is ready to kick-off:


It will startup automatically after a minute, but let's not wait that long.

I don't need much, but in the Sofware Selection I do want Server with GUI:
But with out selecting other packages. What I might need later on, I'll install at provisioning.

I do not like default local domain networknames. So I changed the network hostname to darlin-vce.darwin-it.local:
Hostname darlin stands for Darwin Linux and vce for Virtual Course Environment.

Then hit Begin Installation:


Soon in the installation the installer asks for the Root password:
And the password is as said: vagrant.
Then I add also a vagrant with the same password:
Having done that, we need to wait for the installer to finish. At the end of the Install, do a reboot:

This leads to 2 questions to be answered. One is about accepting the licensing. I assume that can be answered without guidance. The other is about connecting the network.

You need to switch on the network adapter, but to have it done automatically you need to configure it and check the box Automatically connect to this network when it is available on the General tab. You'll need to have this done, otherwise Vagrant will have difficulties in connecting to the box.
Then finish the configuration:
Install guest additionsTo be able to install the guest additions, we need to add some kernel packages. We could have done that by installing additional kernel packages. But I wanted to have a as basic as possible installation. And the following is more fun...

So open a terminal and switch to the super user:

[vagrant@darlin-vce ~]$ su -
Password:
Last login: Tue Apr 24 09:41:21 EDT 2018 on pts/0
...


Then stop package kit, because it will probably hold a lock pausing yum:
[root@darlin-vce ~]# systemctl stop packagekit

And then install the packages kernel-uek-devel kernel-uek-devel-4.1.12-112.16.4.el7uek.x86_64, that are suggested by the GuestAdditions installer, by the way:
[root@darlin-vce ~]# yum -q -y install kernel-uek-devel kernel-uek-devel-4.1.12-112.16.4.el7uek.x86_64
No Presto metadata available for ol7_UEKR4
warning: /var/cache/yum/x86_64/7Server/ol7_latest/packages/cpp-4.8.5-28.0.1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Public key for cpp-4.8.5-28.0.1.el7.x86_64.rpm is not installed
Public key for kernel-uek-devel-4.1.12-124.14.1.el7uek.x86_64.rpm is not installed
Importing GPG key 0xEC551F03:
Userid : "Oracle OSS group (Open Source Software group) "
Fingerprint: 4214 4123 fecf c55b 9086 313d 72f9 7b74 ec55 1f03
Package : 7:oraclelinux-release-7.5-1.0.3.el7.x86_64 (@anaconda/7.5)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

Having done that, insert the GuestAdditions CD:
It brings the following pop-up, click Run:

And provide the Administrator password:

In my case the script ran and during that the display got messed up. But after a reset of the VM (I waited until I got the impression it was done), the VM got up with a Hi-res display, indicating that the install went ok. Also the bi-directional clipboard worked.

Configure vagrant userAgain in a terminal switch to super user and add the following line to the /etc/sudoers file:
vagrant ALL=(ALL) NOPASSWD: ALL

Exit and as vagrant user create a .ssh folder in the vagrant home folder, cd to it and create the file authorized_keys:
[vagrant@darlin-vce ~]$ mkdir .ssh
[vagrant@darlin-vce ~]$ cd .ssh
[vagrant@darlin-vce .ssh]$ vi authorized_keys

Insert the following content:
ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEA6NF8iallvQVp22WDkTkyrtvp9eWW6A8YVr+kz4TjGYe7gHzIw+niNltGEFHzD8+v1I2YJ6oXevct1YeS0o9HZyN1Q9qgCgzUFtdOKLv6IedplqoPkcmF0aYet2PkEDo3MlTBckFXPITAMzF8dJSIFo9D8HfdOV0IAdx4O7PtixWKn5y2hMNG0zQPyUecp4pzC6kivAIhyfHilFR61RGL+GPXQ2MWZWFYbAGjyiYJnAmCP3NOTd0jMZEnDkbUvxhMmBYSdETk1rRgm+R4LOzFUGaHqHDLKLX+FIPKcF96hrucXzcWyLbIbEgE98OHlnVYCzRdK8jlqm8tehUc9c9WhQ== vagrant insecure public key

This is the insecure key of vagrant that can be downloaded here.
It will be replaced by Vagrant at first startup.

Package the boxSo, now we have a base install that can function as a base box for Vagrant. Thus we can now shut it down to export it to an OVA (just as a backup for VirtualBox) and then create are base box out of it.

After creating your export of the OVA, that I skip describing here, you just open a command window. I assume you have Vagrant installed.

To package the box, you use the package subcommand of vagrant:

Microsoft Windows [Version 10.0.16299.371]
(c) 2017 Microsoft Corporation. All rights reserved.

d:\Projects\vagrant>vagrant package --base OL75 --output d:\Projects\vagrant\boxes\OL75v1.0.box
==> OL75: Exporting VM...
==> OL75: Compressing package to: d:/Projects/vagrant/boxes/OL75v1.0.box

d:\Projects\vagrant>

Conclusion Well, that concludes this part of the series. We have our own base box and it's barely 3GB. Next: create a VM with it. Stay tuned.




Is it safe to use ROWID to locate a row?

Tom Kyte - Mon, 2018-04-23 18:46
Hi Tom, I'm looking at a client application which retrieves several columns including ROWID, and later uses ROWID to identify rows it needs to update: update some_table t set col1=value1 where t.rowid = :selected_rowid Is it safe to do so? ...
Categories: DBA Blogs

Unable to Find Sample Schema HR Scripts

Tom Kyte - Mon, 2018-04-23 18:46
Hi Install Oracle 12C on my personal laptop, unfortunately the sample schemas HR,Scott were not created so i tried to Execute below script from command prompt but it did not worked @?/demo/schema/human_resources/hr_main.sql when i checked the loc...
Categories: DBA Blogs

Domain Indexes -- 4 : CTXRULE Index

Hemant K Chitale - Mon, 2018-04-23 10:48
I have earlier provided simple demonstrations of CONTEXT and CTXCAT Indexes.

A CTXRULE Index can be used to build a Document Classification application.  This involves indexing a table of "queries" that define the classification.  Queries use the MATCHES clause.
(Note : Like the CONTEXT Index, a call to SYNC_INDEX is required before the rows are indexed).

SQL> create table common_query_classes
2 (classification varchar2(64),
3 query_text varchar2(4000));

Table created.

SQL> create index query_class_index
2 on common_query_classes (query_text)
3 indextype is ctxsys.ctxrule
4 /

Index created.

SQL>
SQL> insert into common_query_classes
2 values ('Players','Gavaskar OR Tendulkar OR Chappell OR Imran OR Botham');

1 row created.

SQL> insert into common_query_classes
2 values ('Grounds','Brabourne OR Wankhede OR Lords');

1 row created.

SQL> commit;

Commit complete.

SQL>


Note that the query predicates are divided by the OR.  They are NOT listed in Alphabetical order.

Now, I test a few queries :

SQL> exec ctx_ddl.sync_index('QUERY_CLASS_INDEX');

PL/SQL procedure successfully completed.

SQL>
SQL> select classification
2 from common_query_classes
3 where MATCHES (query_text,'Tendulkar is a Player at Brabourne') > 0
4 /

CLASSIFICATION
----------------------------------------------------------------
Grounds
Players

SQL>
SQL> select classification
2 from common_query_classes
3 where MATCHES (query_text,'Botham') > 0
4 /

CLASSIFICATION
----------------------------------------------------------------
Players

SQL> select classification
2 from common_query_classes
3 where MATCHES (query_text, 'Kohli is a Player at Wankhede') > 0
4 /

CLASSIFICATION
----------------------------------------------------------------
Grounds

SQL>


Note that, since Kohli is not in the Players list, the last query doesn't return the Classification "Players".
.
.
.

Categories: DBA Blogs

BPM LLP Helps Clients Achieve Rapid Growth with NetSuite

Oracle Press Releases - Mon, 2018-04-23 09:00
Press Release
BPM LLP Helps Clients Achieve Rapid Growth with NetSuite Top 50 Accounting Firm Joins NetSuite Business Process Outsourcing and Solution Provider Program

SUITEWORLD18—LAS VEGAS—Apr 23, 2018

To address fast-growing demand for cloud business management software, Oracle NetSuite today announced that BPM LLP, one of the largest California-based public accounting and advisory firms and a top 50 firm across the U.S., has joined the NetSuite Business Process Outsourcing (BPO) Program and Solution Provider Program. Founded in 1986, BPM combines its technological expertise in financial advisory/ERP with its long history of leadership in tax assurance and advisory services to deliver NetSuite solutions that equip small and midsized organizations to achieve rapid growth.

“NetSuite’s flexible, cloud-based platform has become the choice for organizations seeking a solution that can scale with their growth, while streamlining processes and delivering real-time information for informed decisions,” said Bryan Rhody, Director of BPM’s Technology Solutions Practice. “We wanted to partner with the leading cloud ERP solution that gives us the flexibility to deliver rapid implementations and agile solutions that scale as our clients grow.”

BPM handles NetSuite financials/ERP, CRM, ecommerce, HR and PSA, with industry-specific implementations based on the NetSuite SuiteSuccess methodology. For businesses executing carve-out transactions and other M&A-related activity within the private equity/venture capital sector, BPM is developing NetSuite solutions to provide rapid implementation, accelerate value and streamline transitions. In addition, BPM implementations of NetSuite OneWorld equip fast-growing businesses with the scalability and functionality needed to expand through new subsidiaries and geographic locations far faster than would be possible with on-premises systems.

“BPM delivers a compelling combination of accounting, strategic and technology expertise to help midmarket organizations achieve their growth objectives,” said Craig West, NetSuite Vice President of Alliances and Channels. “We look forward to a close and prosperous partnership that helps joint customers capitalize on the power of cloud ERP to transform business performance.”

Designed for companies that provide Business Process Outsourcing (BPO) or Business Process as a Service (BPaaS), the NetSuite BPO program is the industry's first and only BPO program that provides partners with a unified cloud-based ERP solution to support clients of any size ranging from small businesses and fast-growing start-ups to mid-market organizations and beyond. As a NetSuite Business Process Outsourcing (BPO) partner, BPM provides outsourced accounting and C-level strategic advisory services to clients. To learn more, please visit: www.netsuite.com/bpo.

Launched in 2002, the NetSuite Solution Provider Program is the industry’s leading cloud channel partner program. The program delivers unprecedented benefits that include highly attractive margins and services that range from business planning, sales, marketing and professional services enablement, to training and education. As a NetSuite Solution Provider, BPM gains new flexibility to provide a full range of services that address diverse needs of clients in industries that include technology, financial services, fintech, life sciences, consumer goods and private equity. For more information about the NetSuite Solution Provider Program, visit www.netsuite.com/partners.

Contact Info
Michael Robinson
Oracle NetSuite Corporate Communications
781-974-9401
michael.s.robinson@oracle.com
About BPM LLP

Founded in 1986, BPM is one of the largest California-based public accounting and advisory firms and ranks as one of the 50 major firms in the country. With six offices across the Bay Area – as well as offices in Oregon, Hong Kong and the Cayman Islands BPM serves emerging, mid-cap, and closely-held businesses, and high net worth individuals in a range of industries. From financial services, technology, life science and consumer business to real estate, nonprofits, wine and craft beverages, BPM is committed to the success of its clients. To learn more, please visit www.bpmcpa.com.

About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials/Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit http://www.netsuite.com.

Follow Oracle NetSuite’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Michael Robinson

  • 781-974-9401

Blu Coffee Distributors Brews Success in the Philippines

Oracle Press Releases - Mon, 2018-04-23 08:30
Press Release
Blu Coffee Distributors Brews Success in the Philippines B2B Distributor of Premium Italian Coffee and Equipment Achieves Rapid Growth with NetSuite OneWorld

SUITEWORLD18—LAS VEGAS—Apr 23, 2018

Blu Coffee Distributors, an importer and distributor of premium Italian coffee and equipment in the Philippines, has implemented NetSuite OneWorld to support its rapid growth. With NetSuite, Blu Coffee Distributors has been able to capitalize on soaring demand for premium coffees across the Philippines by streamlining its business processes.

Founded in 2013, Blu Coffee has expanded from a two-person startup into a thriving business that has roughly doubled its revenue every year and now has more than 50 employees and a reported PHP 100M ($1.92 million USD). To continue to take advantage of soaring demand for premium coffees across the Philippines, where consumption of roasted coffee grew nearly four-fold between 2010 and 2017 and is expected to increase another 72 percent by 2021, Blu Coffee needed to eliminate the complexity created relying on QuickBooks and Excel as its business management system. After evaluating different solutions, Blu Coffee selected NetSuite OneWorld over SAP Business One.

“The coffee market has really taken off in the Philippines,” said Rolando Villanueva, Blu Coffee Distributors founder and CEO, who also owns gas stations, a realty company and other business interests. “I saw this as an exciting opportunity to bring the experience of premium Italian products to coffee lovers across the country. Today we supply more than 1,000 hotels, cafés, restaurants and other businesses. We knew that as we grew and established showroom branches all over the Philippines, we would need a more scalable solution in the cloud.”

With NetSuite, Blu Coffee Distributors manages an expanded footprint of four showrooms in Baguio City, Angeles City, Cebu City and Davao City, along with its headquarters and showroom in Quezon City. Time needed for monthly financial close has been reduced by about 300 percent, while the company now has the insights needed to easily track expiration dates of perishable coffee beans. To further streamline processes, Blu Coffee Distributors is implementing NetSuite SuiteCommerce to provide a B2B commerce portal that will allow customers to order products online. Blu Coffee Distributors worked with NetSuite Solution Provider PGE Solutions to implement its NetSuite solution.

Building on its success, Blu Coffee Distributors has upgraded to the NetSuite OneWorld global business management solution for two reasons. One, it lets Blu Coffee easily transact in the Euro and U.S. dollar with its international suppliers. Moreover, NetSuite OneWorld is scheduled to be rolled out at Panville Unique Distributors, a parent company headed by Villanueva that’s comprised of Blu Coffee Distributors, gas stations, a newly formed bagel distribution company and other interests. With OneWorld, Panville will be able to treat its multiple businesses as subsidiaries for seamless financial consolidation, supporting improved efficiency, visibility and continued growth.

“Companies like Blu Coffee Distributors that identify an opportunity and move quickly to capture the market are increasingly turning to NetSuite to support that growth,” said Hazel del Rosario-Lee, managing director, Oracle NetSuite Philippines. “We’re excited to see their success and look forward to continuing to support them as their business grows and evolves.”

Contact Info
Michael Robinson
Oracle NetSuite Corporate Communications
781-974-9401
michael.s.robinson@oracle.com
About Blu Coffee Distributors

Established in 2013, Blu Coffee Distributors (BCD) was born to be the premier channel partner of highly acclaimed and globally trusted brands of Italian coffee machines and coffee beans in the Philippines.

About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials/Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit http://www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Michael Robinson

  • 781-974-9401

Russian Retailer O’STIN Turns to Oracle to Keep Shelves Stocked at the Speed of Fast Fashion

Oracle Press Releases - Mon, 2018-04-23 08:00
Press Release
Russian Retailer O’STIN Turns to Oracle to Keep Shelves Stocked at the Speed of Fast Fashion Partner Veltio Parlays Data Science and Oracle Demand Forecasting to Automate Manual Inventory Fulfillment Process

Redwood Shores, Calif.—Apr 23, 2018

Today, Oracle announced that O’STIN has deployed Oracle Retail Demand Forecasting, Oracle Retail Planning & Optimization and Veltio APX Supply Chain Planning to create a product replenishment program that proactively anticipates customer demand. With the Oracle Retail and Veltio integration O’STIN sought to improve the effectiveness of inventory fulfillment across 700 stores throughout Russia to better meet customer demand while protecting profitability. Veltio, an Oracle Partner Network Platinum Partner, drove the implementation resulting in a more accurate planning process that can anticipate consumer demand.

“Disparate silos of customer information, store and product performance prevent retailers from having accurate inventory forecasts,” said Chris James, Vice President, Oracle Retail. “Without this holistic perspective brands risk significant decreased margins by having to continually discount inventory to make room for new seasonal merchandise.”

Prior to the upgrade, O’STIN merchants personally managed a 90,000 line product matrix that included the store, style and color. O’STIN management would manually calculate stock levels for each SKU at every store for the previous four weeks, magnifying a scalability problem as the brand operated at the speed of fast fashion.

“The most effective stock level decisions are based on product performance and stock position. The combined Oracle Retail Planning & Optimization complemented by Veltio APX empowers our planning team to better forecast consumer demand and increase their productivity through automation and exception-based reporting. Now we can rely on data science to predict and automate replenishment based on future sales forecasts,” said Prosvirnin Nikolay, Head of Allocation and Replenishment teams, O’STIN.

“By tuning the high-level replenishment parameters, we optimized inventory to hold the right amount of safety stock to meet consumer expectations and manage the end of season inventory,” said Grechin Sergey, Assortment and Planning Director, O’STIN. “In 18 months, we have rolled out the solution to all stores in Russia, Belorussia and Kazakhstan with Veltio.”

“With the ability to directly integrate with Oracle solutions like Oracle Retail Assortment Planning and Oracle Retail Demand Forecasting in a single deployment, Veltio provides clients like O’STIN with an easy-to-use tool that offers increased automation to help predict product lifecycles, size and store split, and initial allocation quantities to feed the supply chain,” said Costas Malamas, Managing Partner, Veltio.

Implementation Benefits:

  • Oracle Retail's Planning and Optimization suite empowers planning teams to combine disparate data sources, including performance, market, and vendor, and leverage retail science to drive intelligent and localized assortments without the increased overhead of full-time data scientists.

  • Oracle Retail Demand Forecasting allows retailers to centralize demand forecasts for their omnichannel enterprise — from operations and vendor collaboration to planning and optimization to marketing and insights — accurately and efficiently.

  • Veltio APX Supply Chain Planning is a set of Oracle Retail Predictive Application Server components developed that provide advanced allocation, replenishment and execution functionality.  Exclusive to Veltio, this cutting-edge retail science can allocate stock to stores using simple or complex packs while optimizing ROI. Veltio APX calculates order quantities at multiple tiers of the supply chain and can create purchase orders at all tiers to be executed by downstream systems. 

Contact Info
Matt Torres
Oracle
4155951584
matt.torres@oracle.com
About O’STIN

O’STIN is European fashion apparel brand, offering products for women, men and kids. O’STIN operates more than 700 stores in Eastern Europe, Russia and Asia. O’STIN is a vertically integrated business that controls the whole value chain across product design production and retail sales. This allows us to assure high product quality at reasonable prices and to keep a direct communication with our customers. For more information about O’STIN, please visit ostin.com.

About Oracle Retail:

Oracle provides retailers with a complete, open, and integrated suite of best-of-breed business applications, cloud services, and hardware that are engineered to work together and empower commerce. Leading fashion, grocery, and specialty retailers use Oracle solutions to anticipate market changes, simplify operations and inspire authentic brand interactions. For more information, visit our website at www.oracle.com/retail.

About Oracle

The Oracle Cloud delivers hundreds of SaaS applications and enterprise-class PaaS and IaaS services to customers in more than 195 countries and territories while processing 55 billion transactions a day. For more information about Oracle (NYSE:ORCL), please visit us at oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Matt Torres

  • 4155951584

Bronto Makes Product Recommendations Personal Across Channels

Oracle Press Releases - Mon, 2018-04-23 08:00
Press Release
Bronto Makes Product Recommendations Personal Across Channels Integrated Product Recommendations Solution Helps Marketers Quickly and Easily Grow Engagement and Revenue

SUITEWORLD18—LAS VEGAS—Apr 23, 2018

To help marketers increase consumer engagement and revenue, Oracle Bronto, a leading cloud-based email marketing vendor to the Internet Retailer Top 1000, today launched an innovative new product recommendation solution. Integrated within the Bronto Marketing Platform, Recommendations Web enables commerce marketers to leverage a combination of custom business rules and predictive models to automate dynamic, personalized product recommendations for ecommerce websites, without the need for extensive technical support.

“Seeing what the recommendations tool has done for our emails, I cannot wait to get Recommendations Web live,” said Matt Grimm, director of ecommerce at RST Brands, a manufacturer of premium outdoor furniture. “Having a tool like this live on our NetSuite SuiteCommerce site will change how we interact with our site visitors. The Bronto team has put great thought into how this solution works, and we couldn’t be more excited to launch it.”

Consumers increasingly expect a personalized and relevant shopping experience whenever and however they interact with a brand. To help commerce marketers meet these rapidly changing expectations and maximize conversion and engagement, Recommendations Web makes it easy to provide a seamless transition from email to the web by ensuring consistent branding and appearance of product recommendations across channels - all while helping to guide customers down the path to purchase with tailored recommendations. The user-friendly solution enables marketers to quickly and easily create business rules and personalize content to maximize conversion and engagement.

“Recommendations Web is game-changing for our customers,” said Bronto General Manager, George Moser. “Our goal has always been to help merchants maximize engagement and drive revenue by elevating the omnichannel shopping experience. The launch of Recommendations Web is another example of how we’re helping our customers stay ahead of increasing expectations and achieve their business goals.”

Recommendations Web is part of the Bronto Marketing Platform, a sophisticated marketing automation platform that powers personalized multichannel content to generate higher shopper engagement to maximize revenue opportunities. An extension of Bronto’s recommendations offerings for email, Recommendation Web empowers marketers to easily and quickly add dynamic, personalized product recommendations anywhere on their ecommerce website.

Unlike other marketing automation platforms that offer integrated web recommendations, the Bronto Marketing Platform makes it quick and easy for marketers to select the predictive rules or customize the display layout. Third-party providers often also require marketers to add custom code to every page where the recommendations appear. With Recommendations Web, the same set of recommendations can be used on multiple pages, minimizing the need to update or implement custom code when recommendations rules or designs change.

Recommendations Web is available now as an extension of Bronto’s email recommendations solutions.

Contact Info
Michael Robinson
Oracle NetSuite Corporate Communications
781-974-9401
michael.s.robinson@oracle.com
About Oracle Bronto

Oracle Bronto arms high-growth retailers with sophisticated marketing automation to maximize revenue opportunities. The Bronto Marketing Platform powers personalized multichannel content that generates the higher engagement needed for retail success. Keenly focused on the commerce marketer, Bronto continues its longstanding tradition as a leading email marketing provider to the global Internet Retailer Top 1000 and boasts a client roster of leading brands, including Rebecca Minkoff, Timex, Lucky Brand, Theory, Brooks, Ashley Homestore and Christopher & Banks. For more information visit bronto.com or follow Bronto’s blog, Facebook page and @Bronto Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Michael Robinson

  • 781-974-9401

Oracle API Platform Cloud Service: using the Developer Portal for discovering APIs via the API Catalog and subscribing applications to APIs

Amis Blog - Sun, 2018-04-22 14:22

At the Oracle Partner PaaS Summer Camps VII 2017 in Lisbon last year, at the end of august, I attended the API Platform Cloud Service & Integration Cloud Service bootcamp.

In a series of article’s I will give a high level overview of what you can do with Oracle API Platform Cloud Service.

At the Summer Camp a pre-built Oracle VM VirtualBox APIPCS appliance (APIPCS_17_3_3.ova) was provided to us, to be used in VirtualBox. Everything needed to run a complete demo of API Platform Cloud Service is contained within Docker containers that are staged in that appliance. The version of Oracle API Platform CS, used within the appliance, is Release 17.3.3 — August 2017.

See https://docs.oracle.com/en/cloud/paas/api-platform-cloud/whats-new/index.html to learn about the new and changed features of Oracle API Platform CS in the latest release.

In this article in the series about Oracle API Platform CS, the focus will be on the Developer Portal, discovering APIs via the API Catalog and subscribing applications to APIs. As a follow-up from my previous article, at the end the focus is on validating the “Key Validation” policy of the “HumanResourceService”API.
[https://technology.amis.nl/2018/04/14/oracle-api-platform-cloud-service-using-the-management-portal-and-creating-an-api-including-some-policies/]

Be aware that the screenshot’s in this article and the examples provided, are based on a demo environment of Oracle API Platform CS and were created by using the Oracle VM VirtualBox APIPCS appliance mentioned above.

This article only covers part of the functionality of Oracle API Platform CS. For more detail I refer you to the documentation: https://cloud.oracle.com/en_US/api-platform.

Short overview of Oracle API Platform Cloud Service

Oracle API Platform Cloud Service enables companies to thrive in the digital economy by comprehensively managing the full API lifecycle from design and standardization to documenting, publishing, testing and managing APIs. These tools provide API developers, managers, and users an end-to-end platform for designing, prototyping. Through the platform, users gain the agility needed to support changing business demands and opportunities, while having clear visibility into who is using APIs for better control, security and monetization of digital assets.
[https://cloud.oracle.com/en_US/api-platform/datasheets]

Architecture

Management Portal:
APIs are managed, secured, and published using the Management Portal.
The Management Portal is hosted on the Oracle Cloud, managed by Oracle, and users granted
API Manager privileges have access.

Gateways:
API Gateways are the runtime components that enforce all policies, but also help in
collecting data for analytics. The gateways can be deployed anywhere – on premise, on Oracle
Cloud or to any third party cloud providers.

Developer Portal:
After an API is published, Application Developers use the Developer Portal to discover, register, and consume APIs. The Developer Portal can be customized to run either on the Oracle Cloud or directly in the customer environment on premises.
[https://cloud.oracle.com/opc/paas/datasheets/APIPCSDataSheet_Jan2018.pdf]

Oracle Apiary:
In my article “Oracle API Platform Cloud Service: Design-First approach and using Oracle Apiary”, I talked about using Oracle Apiary and interacting with its Mock Server for the “HumanResourceService” API, I created earlier.

The Mock Server for the “HumanResourceService” API is listening at:
http://private-b4874b1-humanresourceservice.apiary-mock.com
[https://technology.amis.nl/2018/01/31/oracle-api-platform-cloud-service-design-first-approach-using-oracle-apiary/]

Roles

Within Oracle API Platform CS roles are used.

Roles determine which interfaces a user is authorized to access and the grants they are eligible to receive.
[https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfad/api-platform-cloud-service-roles-resources-actions-and-grants.html]

  • Administrator
    System Administrators responsible for managing the platform settings. Administrators possess the rights of all other roles and are eligible to receive grants for all objects in the system.
  • API Manager
    People responsible for managing the API lifecycle, which includes designing, implementing, and versioning APIs. Also responsible for managing grants and applications, providing API documentation, and monitoring API performance.
  • Application Developer
    API consumers granted self-service access rights to discover and register APIs, view API documentation, and manage applications using the Developer Portal.
  • Gateway Manager
    Operations team members responsible for deploying, registering, and managing gateways. May also manage API deployments to their gateways when issued the Deploy API grant by an API Manager.
  • Gateway Runtime
    This role indicates a service account used to communicate from the gateway to the portal. This role is used exclusively for gateway nodes to communicate with the management service; users assigned this role can’t sign into the Management Portal or the Developer Portal.
  • Service Manager
    People responsible for managing resources that define backend services. This includes managing service accounts and services.
  • Plan Manager
    People responsible for managing plans.

Within the Oracle VM VirtualBox APIPCS appliance the following users (all with password welcome1) are present and used by me in this article:

User Role api-manager-user APIManager api-gateway-user GatewayManager app-dev-user ApplicationDeveloper

Publish an API, via the Management Portal (api-manager-user)

Start the Oracle API Platform Cloud – Management Portal as user api-manager-user.

Navigate to tab “Publication” of the “HumanResourceService” API (which I created earlier).
[https://technology.amis.nl/2018/04/14/oracle-api-platform-cloud-service-using-the-management-portal-and-creating-an-api-including-some-policies/]

Publish an API to the Developer Portal when you want application developers to discover and consume it.

Each published API has a details page on the Developer Portal. This page displays basic information about the API, an overview describing the purpose of the API, and documentation for using the API. This page is not visible on the Developer Portal until you publish it.
[https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfad/publishing-apis.html#GUID-145F0AAE-872B-4577-ACA6-994616A779F1]

The tab “Publication” contains the following parts:

  • API Portal URL
  • Developer Portal API Overview
  • Documentation

Next I will explain (in reversed order) these parts in more detail.

As you can see, for some of the parts we can use HTML, Markdown or Apiary.

Remark:
Markdown is a lightweight markup language with plain text formatting syntax.
[https://en.wikipedia.org/wiki/Markdown]

Part “Documentation” of the tab “Publication”

You can provide HTML or Markdown documentation by uploading a file, manually entering text, or providing a URL to the documentation resource. After you have added the documentation, it appears on the Documentation tab of the API detail page in the Developer Portal.
[https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfad/publishing-apis.html#GUID-9FD22DC2-18A9-4338-91E7-70726C906B91]

It is also possible to add documentation from Oracle Apiary to an API.

Adding documentation to the API can help users understand its purpose and how it was configured.

Note:
Swagger or API Blueprint documentation can only be added to an Oracle Apiary Pro account. To add documentation, the team must have ownership of the API in Oracle Apiary. API definitions owned by personal accounts cannot be used. To transfer ownership of an API from a personal account to a team account, see the Oracle Apiary documentation.
[https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfad/publishing-apis.html#GUID-A7E68AA0-396D-400C-933C-1C4CD3DDD832]

So let’s see how I tried using documentation from Oracle Apiary.

Using Oracle Apiary for documentation

I clicked on button “Apiary”. In my case the following screen appeared:

Next, I clicked on button “Go To Apiary”.

Then I clicked on button “Sign in”.

After a successful sign in (for example by using Email/Password), the following screen appeared (with the “HumanResourceService” API visible):

Next, I clicked on button “Create a team”. The following pop-up appeared:

Because I use a Free (personal) Account for Oracle Apiary, I am not able to create a team.

Remember the note (see above) saying: “Swagger or API Blueprint documentation can only be added to an Oracle Apiary Pro account. To add documentation, the team must have ownership of the API in Oracle Apiary. API definitions owned by personal accounts cannot be used.”.
[https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfad/publishing-apis.html#GUID-A7E68AA0-396D-400C-933C-1C4CD3DDD832]

So, for me, the path of using documentation from Oracle Apiary came to an end.

As an alternative, in this article, I used Markdown for documentation. But before explaining that in more detail, I want to give you an impression of screenshot’s of what happens when you click on button “Apiary” and have an Apiary account with the right privileges to add documentation to an API.

Remark:
The screenshot’s that follow, are taken from the API Platform Cloud Service bootcamp, I attended at the Oracle Partner PaaS Summer Camps VII 2017 in Lisbon last year.

So, when you click on button “Apiary”, the following screen appears:

A list of API’s is visible where you can choose one to connect. For example: “TicketService27” API.

After a click on button “Connect”, the “Documentation” part of tab “Publication” looks like:

Using Markdown for documentation

For reasons mentioned above, as an alternative for using Oracle Apiary, in this article, I used Markdown for documentation. Markdown is new to me, so (in this article) I will only demonstrate it with a simplified version of the documentation (available in Apiary).

Click on button “Markdown”.

Next, click on tab “Text” and enter the following text:

# HumanResourceService

Human Resource Service is an API to manage Human Resources.

## Employees Collection [/employees]

### Get all employees [GET /employees]

Get all employees.

### Get an employee [GET /employees/{id}]

Get a particular employee by providing an identifier.

### Create an employee [POST /employees]

Create an employee, by using post with the complete payload.

### Update an employee [PUT /employees/{id}]

Update an employee, by using put with the a payload containing: last_name, job_id, salary and department_id.

## Departments Collection [/departments]

### Get a department [GET /department/{id}]

Get a particular department by providing an identifier.

### Get a department and employee [GET /departments/{department_id}/employees/{employee_id}]

Get a particular department by providing a department identifier and a particular employee within that department by providing an employee identifier.

After a click on button “OK”, the “Documentation” part of tab “Publication” looks like:

In the pop-up, click on button “Save Changes”.

Part “Developer Portal API Overview” of the tab “Publication”

You can provide overview text for an API, describing its features and other information a developer should know about its use, in either HTML or Markdown.

You can upload a file, enter text manually, or provide a link to HTML or Markdown to use as overview text. This text appears on the API’s detail page in the Developer Portal.
[https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfad/publishing-apis.html#GUID-D1BF7E3E-03C9-42AE-9808-EC9BC77D3E61]

For the “Developer Portal API Overview” part, I chose to use HTML (because in this article, up to now, examples of using Markdown and Apiary were already provided).

Once again I will only demonstrate it with a simplified version of the documentation (available in Apiary).

Click on button “HTML”.

Next, click on tab “Text” and enter the following text:

<h1>HumanResourceService</h1>

Human Resource Service is an API to manage Human Resources.

It provides CRUD methods for the resources <b>Employees</b> and <b>Departments</b>.

After a click on button “OK”, the “Developer Portal API Overview” part of tab “Publication” looks like:

In the pop-up, click on button “Save Changes”.

Part “API Portal URL” of the tab “Publication”

Before publishing to the Developer Portal, each API has to be configured with its own unique Vanity Name. A vanity name is the URI path of an API’s details page when it is published to the Developer Portal.

On the Publication tab, enter the path at which this API will be discoverable in the Developer Portal in the API Portal URL field. This is also called the API’s vanity name.

Note:
An API’s vanity name must be unique, regardless of case. You can’t have APIs with vanity names of Creditcheck and creditcheck. You must enter the vanity name exactly (matching case) in the URL to navigate to an API’s details page in the Developer Portal. For example, navigating to https://<host>:<port>/developers/apis/Creditcheck opens the page for an API with a vanity name of Creditcheck; https://<host>:<port>/developers/apis/creditcheck doesn’t open this page and returns a 404 because the segment in the URL does not match the vanity name exactly.

Only valid URI simple path names are supported. Characters such as “?”, “/”, and “&” are not supported in vanity names. Test_2 is a supported vanity name, but Test/2 is not.
[https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfad/publishing-apis.html#GUID-C9034B10-72EA-4046-A8B8-B5B1AE087180]

The default API’s vanity name, is derived from the API name:

<not published>/HumanResourceService

Publish the “HumanResourceService” API to the Developer Portal

So now that we have all the documentation in place, Notice that the button “Preview” appeared.

Clicking on button “Preview” generates an error:

Remember that I am using a demo environment of Oracle API Platform CS by using the Oracle VM VirtualBox APIPCS appliance. This seems to be a bug in that environment. So what should have been visible was something like:

Here you can see on the left, that the tab “Overview” is selected . There is also a tab “Documentation”.

Remark:
Please see the screenshot’s later on in this article for the “HumanResourceService”API in the “Developer Portal” (tab APIs), with regard to the tabs “Overview” and “Documentation”. These show the same information as in the Preview context.

Next, click on button “Publish to Portal”.

Notice that the > icon “Launch Developer Portal in another browser window” appeared and also that the API Portal URL is changed to:

http://apics.oracle.com:7201/developers/apis/HumanResourceService

In the top part of the screen you can see that the “HumanResourceService”API is “Published’.

It’s time to launch the Developer Portal.

Click on the icon “Launch Developer Portal in another browser window”.

Sign in to the Oracle API Platform Cloud – Developer Portal as user app-dev-user

After a successful sign in as user app-dev-user, the next screen appears (with tab “APIs” selected):

The “Developer Portal” is the web page where you discover APIs, subscribe to APIs and get the necessary information to invoke them. When you access the “Developer Portal”, the API Catalog page appears. All the APIs that have been published to the “Developer Portal” are listed. Use the API Catalog page to find APIs published to the “Developer Portal”.

In the “Developer Portal” screen above there are no APIs, or they are not visible for the current user. So we have to go back to the Oracle API Platform Cloud – Management Portal (as an API Manager). There we can grant the privileges needed for an Application Developer to see the API. How you do this is described later on in this article.

For now we continue as if the correct privileges were already in place. Therefor the “HumanResourceService” API is visible.

Click on the “HumanResourceService” API.

Here you can see on the left, that the tab “Overview” is selected.

For now I will give you a short overview of screenshot’s of each of the tabs on the left.

Tab “Overview” of the “HumanResourceService” API

Remember that we used HTML code for the “Developer Portal API Overview” part of the tab “Publication”?
So here you can see the result.

Tab “Documentation” of the “HumanResourceService” API

Remember that we used Markdown code for the “Documentation” part of the tab “Publication”?
So here you can see the result.

Remark:
If I had an Apiary account with the right privileges to add documentation to an API and used Apiary for documentation, the tab “Documentation” would have looked like:

Discover APIs

In the API Catalog page, you can search for an API by entering keywords in the field at the top of the catalog. The list is narrowed to the APIs that have that word in the name or the description. If you enter multiple words, the list contains all APIs with either of the words; APIs with both words appear at the top of the list. If a keyword or keywords have been applied to the list, they appear in a bar at the top of the page. Filters can also be applied to the list. You can also sort the list for example in alphabetical order or by newest to oldest API.
[Oracle Partner PaaS Summer Camps VII 2017, APIPCS bootcamp, Lab_APIPCS_Design_and_Implement.pdf]

Subscribe an application to the “HumanResourceService” API

In the “Developer Portal” screen if we navigate, in the API Catalog page, to the “HumanResourceService” API, and if the user has the correct privileges, a button “Subscribe” is visible. In the Oracle API Platform Cloud – Management Portal (as an API Manager) we can grant the privileges needed for an Application Developer to register an application to the API. How you do this is described later on in this article.

For now we continue as if the correct privileges were already in place.

Click on button “Subscribe”.

Next, click on button “Create New Application”. Enter the following values:

Application Name HumanResourceWebApplication Description Web Application to manage Human Resources. Application Types Web Application Contact information: First Name FirstName Last Name LastName Email Email@company.com Phone 123456789 Company Company

Click on button “Save”.

For a short while a pop-up “The application ‘HumanResourceWebApplication’ was created.” appears.

So now we have an application, we can subscribe it, to the “HumanResourceService” API.

Notice that an Application Key was generated, with as value:

fb3138d1-0636-456e-96c4-4e21b684f45e

Remark:
You can reissue a key for an application in case it has been compromised, Application keys are established at the application level. If you reissue an application’s key, the old key is invalidated. This affects all APIs (that have the key validation policy applied) to which an application is registered. Every request to these APIs must use the new key to succeed. Requests using the old key are rejected. APIs without the key validation policy are not affected as these do not require a valid application key to pass requests.
[https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfad/reissuing-application-key.html#GUID-4E570C15-C289-4B6D-870C-F7ADACC1F6DD]

Next, click on button “Subscribe API”.

For a short while a pop-up “API ‘HumanResourceService’ was subscribed to application ‘HumanResourceWebApplication’.” appears.

A request to register the application to the API is sent to the API Manager. So now we have to wait for the approval of the API Manager. How you do this is described later on in this article.

In the API Catalog page, when viewing an API you can see which applications are subscribed to it.

In the My Applications page, when viewing an application you can see which APIs it subscribed to.

After a click on the “HumanResourceWebApplication” application, the next screen appears (with tab “Overview” selected):

First l will give you a short overview of screenshot’s of each of the tabs on the left. Some of these I will explain in more detail as I will walk you through some of the functionality of Oracle API Platform CS.

Tab “Overview” of the “HumanResourceWebApplication” application

Tab “Subscribed APIs” of the “HumanResourceWebApplication” application

Tab “Grants” of the “HumanResourceWebApplication” application

Application grants are issued per application.

The following tabs are visible and can be chosen:

  • Manage Application
    People issued this grant can view, modify and delete this application. API Manager users issued this grant can also issue grants for this application to others.
  • View all details
    People issued this grant can see all details about this application in the Developer Portal.

See for more information: https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfad/managing-application-grants.html

Tab “Analytics” of the “HumanResourceWebApplication” application

Create an Application in the “My Applications” page

Click on button “New Application”.

In the same way as described before I created several applications (one at a time) with minimum information (Application Name, Application Types, First Name, Last Name and Email).

In the My Applications page, the list of applications then looks like:

In the table below I summarized the applications that I created:

Application Name Application Types Application Key DesktopApp_A_Application Desktop App e194833d-d5ac-4c9d-8143-4cf3a3e81fea DesktopApp_B_Application Desktop App fd06c3b5-ab76-4e89-8c5a-e4b8326c360b HumanResourceWebApplication Web Application fb3138d1-0636-456e-96c4-4e21b684f45e MobileAndroid_A_Application Mobile – Android fa2ed56f-da3f-49ea-8044-b16d9ca75087 MobileAndroid_B_Application Mobile – Android 385871a2-7bb8-4281-9a54-c0319029e691 Mobile_iOS_A_Application Mobile – iOS 7ebb4cf8-5a3f-4df5-82ad-fe09850f0e50

In the API Catalog page, navigate to the “HumanResourceService” API. Here you can see that there is already one subscribed application.

Click on button “Subscribe”.

Next, select the “MobileAndroid_B_Application” application.

For a short while a pop-up “API ‘HumanResourceService’ was subscribed to application ‘ MobileAndroid_B_Application ‘.” appears.

In the API Catalog page, when viewing an API you can see which applications are subscribed to it.

Here we can see the status “Pending”. A request to register the “MobileAndroid_B_Application” application to the “HumanResourceService” API is sent to the API Manager. So now we have to wait for the approval of the API Manager. Repeat the steps described in this article, to approve the request, by switching to an API Manager.

In the screen below, we can see the end result:

Edit the Key Validation Policy, via the Management Portal (api-manager-user)

In the top right of the Oracle API Platform Cloud – Management Portal sign in as user api-manager-user.

Navigate to tab “API Implementation” of the “HumanResourceService” API.

Hoover over the “Key Validation” policy and then, on the right, click on icon “Edit policy details”.

Click on button “Apply”.

Next, click on button “Save Changes”.

I applied this policy as an active policy, represented as a solid line around the policy.

Redeploy the API, via the Management Portal (api-manager-user)

Navigate to tab “Deployments” of the “HumanResourceService” API, and then hover over the “Production Gateway” gateway and then, on the right, hover over the icon “Redeploy”.

Next, click on icon “Latest Iteration”. Also approve the request, by switching to a Gateway Manager.
How you do this, is described in my previous article “Oracle API Platform Cloud Service: using the Management Portal and creating an API (including some policies)”.
[https://technology.amis.nl/2018/04/14/oracle-api-platform-cloud-service-using-the-management-portal-and-creating-an-api-including-some-policies/]

So now the “HumanResourceService” API is redeployed on the “Production Gateway” gateway (Node 1).

It is time to invoke the API.

Validating the “Key Validation” policy, via Postman

As described in my previous article, in Postman, I created requests within the collection named “HumanResourceServiceCollection”.
[https://technology.amis.nl/2018/04/14/oracle-api-platform-cloud-service-using-the-management-portal-and-creating-an-api-including-some-policies/]

Then again I invoked two request, to validate them against the “Key Validation” policy.

Invoke method “GetEmployee” of the “HumanResourceService” API

From Postman I invoked the request named “GetEmployeeRequest” (with method “GET” and URL “http://apics.oracle.com:8001/HumanResourceService/1/employees/100”) and a response with “Status 401 Unauthorized” is shown:

After providing the Value fb3138d1-0636-456e-96c4-4e21b684f45e (being the Application Key of the “HumanResourceWebApplication” application) for the Header Key “application-key”, a response with “Status 200 OK” is shown:

After providing the Value e194833d-d5ac-4c9d-8143-4cf3a3e81fea (being the Application Key of the “DesktopApp_A_Application” application) for the Header Key “application-key”, a response with “Status 401 Unauthorized” is shown:

Invoke method “GetDepartmentEmployee” of the “HumanResourceService” API

From Postman I invoked the request named “GetDepartmentEmployeeRequest” (with method “GET” and URL “http://apics.oracle.com:8001/HumanResourceService/1/departments/30/employees/119”) and a response with “Status 401 Unauthorized” is shown:

After providing the Value 385871a2-7bb8-4281-9a54-c0319029e691 (being the Application Key of the “MobileAndroid_B_Application” application) for the Header Key “application-key”, a response with “Status 200 OK” is shown:

Tab “Analytics” of the “Production Gateway” gateway

In the top right of the Oracle API Platform Cloud – Management Portal sign in as user api-gateway-user and click on the “Production Gateway” gateway and navigate to the tab “Analytics”.

In this tab the requests I sent, are visible at “Total Requests”.

If we look, for example, at “Requests By Resource”, the requests are also visible.

Next, click on icon “Applications (4 Active)” and if we look, for example, at “Active Applications”, we can see that there were in total 3 request rejections (because of policy “Key Validation”).

If we look, for example, at “Requests By API”, the requests are also visible.

There were 2 request that had no Header Key “application-key” at all. As you can see in the graph above, these were rejected and were administrated under “Unknown Application (No Key).

There was 1 request that had a Value e194833d-d5ac-4c9d-8143-4cf3a3e81fea for the Header Key “application-key”. As you can see in the graph above, this request was rejected and was administrated under the “DesktopApp_A_Application” application. Remember that this application was not registered to the “HumanResourceService” API.

The other 2 request were accepted, because they had a valid Value for the Header Key and the corresponding applications were registered to the “HumanResourceService” API.

So the “Key Validation” policy is working correct.

Sign in to the Oracle API Platform Cloud – Management Portal as user api-manager-user

Go back to the Oracle API Platform Cloud – Management Portal and, if not already done, sign in as user api-manager-user. Navigate to tab “Grants” of the “HumanResourceService” API.

API grants are issued per API.

The following tabs are visible and can be chosen:

  • Manage API
    Users issued this grant are allowed to modify the definition of and issue grants for this API.
  • View all details
    Users issued this grant are allowed to view all information about this API in the Management Portal.
  • Deploy API
    Users issued this grant are allowed to deploy or undeploy this API to a gateway for which they have deploy rights. This allows users to deploy this API without first receiving a request from an API Manager.
  • View public details
    Users issued this grant are allowed to view the publicly available details of this API on the Developer Portal.
  • Register
    Users issued this grant are allowed to register applications for this plan.
  • Request registration
    Users issued this grant are allowed to request to register applications for this plan.

Users and groups issued grants for a specific API have the privileges to perform the associated actions on that API. See for more information: https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfad/managing-api-grants.html.

“View public details” grant

To view an API, the Application Developer must have the “View public details” grant or another grant that implies these privileges.

Click on tab “View public details”.

Next, click on button “Add Grantee”.

Select “app-dev-user” and click on button “Add”.

So now, the user app-dev-user (with Role ApplicationDeveloper) is granted the “View public details” privilege.

Remark:
In practice you would probably grant to a group instead of to a single user.

“Request registration” grant

To register an API, the Application Developer must have the “Request registration” grant or another grant that implies these privileges.

Click on tab “Request registration”.

Next, click on button “Add Grantee”.

Select “app-dev-user” and click on button “Add”.

So now, the user app-dev-user (with Role ApplicationDeveloper) is granted the “Request registration” privilege.

Remark:
In practice you would probably grant to a group instead of to a single user.

Be aware that you could also grant the “Register” privilege, so approval of the API Manager (for registering an application to an API) is not needed anymore in that case. This makes sense if it concerns a development environment, for example. Since the Oracle VM VirtualBox APIPCS appliance is using a “Production Gateway” gateway, in this article, I chose for the request and approve mechanism.

Approve a request for registering an application to an API, via the Management Portal (api-manager-user)

On the left, click on tab “Registrations” and then click on tab “Requesting”.

Hover over the “HumanResourceWebApplication” application, then click on button “Approve”.

In the pop-up, click on button “Yes”.

Then you can see on the tab “Registered”, that the registration is done.

After a click on the top right icon “Expand”, more details are shown:

So now the “HumanResourceWebApplication” application is registered to the “HumanResourceService” API.

Summary

As a follow up from my previous articles about Oracle API Platform Cloud Service, in this article the focus is on using the Developer Portal, discovering APIs via the API Catalog and subscribing applications to APIs.

I activated the Key Validation (Security) policy, which I created in my previous article, and redeployed the API to a gateway and validated that this policy worked correct, using requests which I created in Postman.
[https://technology.amis.nl/2018/04/14/oracle-api-platform-cloud-service-using-the-management-portal-and-creating-an-api-including-some-policies/]

While using the Management Portal and Developer Portal in this article, I focused on the roles “API Manager” and “Application Developer”. For example, the user api-manager-user had to approve a request from the app-dev-user to register an application to an API.

At the API Platform Cloud Service bootcamp (at the Oracle Partner PaaS Summer Camps VII 2017 in Lisbon last year, at the end of august), I (and many others) got hands-on experience with the API Platform Cloud Service. There we created an API with more policies than described in this article.

It became obvious that the API Platform Cloud Service is a great API Management solution and that with the help of policies your are able to secure, throttle, route, manipulate, or log requests before they reach the backend service.

The post Oracle API Platform Cloud Service: using the Developer Portal for discovering APIs via the API Catalog and subscribing applications to APIs appeared first on AMIS Oracle and Java Blog.

Oracle VM Server: How to add ISO images to your repository

Dietrich Schroff - Sun, 2018-04-22 09:57
After  setting up
you have to upload some ISO images to your repository, so that your virtual machines can boot with these ISO images.

So inside Oracle VM Manager go to the "Repositories" tab and use the "import iso icon" (the blue arrow):

The only way to import ISO images is to give a URL to Oracle VM Manager:


And after pushing the ok button you can monitor the download inside the job summary tab:



Inside the repository tab you will find the ISO image after a successful download:

This ISO image can now be used inside the configuration of your VMs. (Take a look here)


Domain Indexes -- 3 : CTXCAT Index

Hemant K Chitale - Sat, 2018-04-21 11:14
In previous posts in December 2017, I had demonstrated a CONTEXT Index.

A CONTEXT Index is used for full-text retrieval from large pieces of text (or document formats stored in LOBs)

A CTXCAT Index is best suited for small fragments of text that are to be indexed with other relational data.

Before I begin with the CTXCAT index, in addition to the CTXAPP role (that I had granted during the earlier demonstration), the account also needs the CREATE TRIGGER privilege.

SQL> grant ctxapp to ctxuser;

Grant succeeded.

SQL> grant create trigger to ctxuser;

Grant succeeded.

SQL>


I can now proceed with the CTXUSER demonstration.

SQL> connect ctxuser/ctxuser
Connected.
SQL> create table books
2 (book_id integer primary key,
3 book_title varchar2(250) not null,
4 book_author varchar2(80),
5 book_subject varchar2(25),
6 shelf_id integer)
7 /

Table created.

SQL>
SQL> insert into books values
2 (1,'A Study In Scarlet','Arthur Conan Doyle','Mystery',1);

1 row created.

SQL> insert into books values
2 (2,'The Sign Of Four','Arthur Conan Doyle','Mystery',1);

1 row created.

SQL> insert into books values
2 (3,'Murder On The Orient Express','Agatha Christie','Mystery',1);

1 row created.

SQL> insert into books values
2 (4,'A Brief History of Time','Stephen Hawking','Science - Physics',2);

1 row created.

SQL>
SQL> insert into books values
2 (5,'2001: A Space Odyssey','Arthur C Clarke','Science Fiction',3);

1 row created.

SQL>
SQL> commit;

Commit complete.

SQL>


Next, I specify what is called an Index Set -- which specifies the structured columns that are to be included in the CTXCAT Index.  I then define the CTXCAT Index on the BOOK_TITLE column.

SQL> begin
2 ctx_ddl.create_index_set('books_set');
3 ctx_ddl.add_index('books_set','book_subject');
4 ctx_ddl.add_index('books_set','shelf_id');
5 end;
6 /

PL/SQL procedure successfully completed.

SQL>
SQL> create index books_title_index
2 on books (book_title)
3 indextype is ctxsys.ctxcat
4 parameters ('index set books_set')
5 /

Index created.

SQL>


Now, I can use the Index to query the table, using the CATSEARCH clause instead of the CONTAINS clause. My query includes both BOOK_TITLE and SHELF_ID

SQL> select book_title,book_author,book_subject,shelf_id
2 from books
3 where catsearch (book_title,'History','shelf_id=1') > 0
4 /

no rows selected

SQL> select book_title,book_author,book_subject,shelf_id
2 from books
3 where catsearch (book_title,'History','shelf_id>1') > 0
4 /

BOOK_TITLE
--------------------------------------------------------------------------------
BOOK_AUTHOR
--------------------------------------------------------------------------------
BOOK_SUBJECT SHELF_ID
------------------------- ----------
A Brief History of Time
Stephen Hawking
Science - Physics 2


SQL>


The CTXCAT Index that I built on BOOK_TITLE also includes BOOK_SUBJECT and SHELF_ID as indexed columns by virtue of the INDEX_SET called "BOOKS_SET".

Now, I add another row and verify if I need to Sync the index (as I had to do with the CONTEXT Index earlier).

SQL> insert into books
2 values
3 (6,'The Selfish Gene','Richard Dawkins','Evolution',2);

1 row created.

SQL> commit;
SQL> select book_title,book_author,book_subject,shelf_id
2 from books
3 where catsearch (book_title,'Gene','book_subject > ''S'' ') > 0
4 /

no rows selected

SQL> select book_title,book_author,book_subject,shelf_id
2 from books
3 where catsearch (book_title,'Gene','book_subject > ''E'' ') > 0
4 /

BOOK_TITLE
--------------------------------------------------------------------------------
BOOK_AUTHOR
--------------------------------------------------------------------------------
BOOK_SUBJECT SHELF_ID
------------------------- ----------
The Selfish Gene
Richard Dawkins
Evolution 2


SQL>


Note, specifically, how I could use the BOOK_SUBJECT in the query as if looking up a separate index on BOOK_SUBJECT.
The new book was included in the index without a call to CTX_DDL.SYNC_INDEX as would be required for the CONTEXT IndexType.

The portion of the query that is on the BOOK_TITLE column does a Text search on this column but the portions on BOOK_SUBJECT an SHELF_ID behave as with regular indexes.


(I know  that some readers will dispute the subject categorization "Evolution"  but I deliberately threw that in so that I  could show a query that uses a predicate filter not on "Science").

.
.
.




Categories: DBA Blogs

Oracle VM Server: my first vm: Error: HVM guest support is unavailable

Dietrich Schroff - Sat, 2018-04-21 09:47
All my tests with Oracle VM Server are running inside Oracle Virtualbox. If you want to do some tests yourself with this setup, you can easily get this error message after powering on your VM:

Server error: Command: ['xm', 'create', '/OVS/Repositories/0004fb0000030000dad74d9c43176d2e/VirtualMachines/0004fb00000600005e79798ecb1a63cf/vm.cfg'] failed (1): stderr: Error: HVM guest support is unavailable: is VT/AMD-V supported by your CPU and enabled in your BIOS?
stdout: Using config file "/OVS/Repositories/0004fb0000030000dad74d9c43176d2e/VirtualMachines/0004fb00000600005e79798ecb1a63cf/vm.cfg".To get your system running, you have to change this for your Oracle VM Server node on VirtualBox:


After that you get:

Server error: Command: ['xm', 'create', '/OVS/Repositories/0004fb0000030000dad74d9c43176d2e/VirtualMachines/0004fb0000060000b5dca8dccb8b74f6/vm.cfg'] failed (1): stderr: Error: Boot loader didn't return any data!
stdout: Using config file "/OVS/Repositories/0004fb0000030000dad74d9c43176d2e/VirtualMachines/0004fb0000060000b5dca8dccb8b74f6/vm.cfg".But this is due to specifying no boot media at your VM. Therefore you have to add an ISO image to your Oracle VM Server repository.

Can I do it with PostgreSQL? – 19 – Create user … identified by values

Yann Neuhaus - Sat, 2018-04-21 06:39

Puh, that last post in this series is already half a year old. Time is moving too fast :( Today, while being at a customer again, this question came up: Can I do something comparable in PostgreSQL to what I can do in Oracle, which is: Create a user and provide the hashed password so that the password is the same on the source and the target (which implies not knowing the password at all)? In Oracle you can find the hashed passwords in user$ where can I find that in PostgreSQL? Lets go.

When we look at the “create user” command there is no option which seems to do that:

postgres=# \h create user
Command:     CREATE USER
Description: define a new database role
Syntax:
CREATE USER name [ [ WITH ] option [ ... ] ]

where option can be:

      SUPERUSER | NOSUPERUSER
    | CREATEDB | NOCREATEDB
    | CREATEROLE | NOCREATEROLE
    | INHERIT | NOINHERIT
    | LOGIN | NOLOGIN
    | REPLICATION | NOREPLICATION
    | BYPASSRLS | NOBYPASSRLS
    | CONNECTION LIMIT connlimit
    | [ ENCRYPTED ] PASSWORD 'password'
    | VALID UNTIL 'timestamp'
    | IN ROLE role_name [, ...]
    | IN GROUP role_name [, ...]
    | ROLE role_name [, ...]
    | ADMIN role_name [, ...]
    | USER role_name [, ...]
    | SYSID uid

Maybe we can just pass the hashed password? Lets try be creating a new user:

postgres=# create user u with login password 'u';
CREATE ROLE

The hashed passwords in PostgreSQL are stored in pg_shadow:

postgres=# select passwd from pg_shadow where usename = 'u';
               passwd                
-------------------------------------
 md56277e2a7446059985dc9bcf0a4ac1a8f
(1 row)

Lets use that hash and create a new user:

postgres=# create user w login encrypted password 'md56277e2a7446059985dc9bcf0a4ac1a8f';
CREATE ROLE

Can we login as w using “u” as a password?

postgres@pgbox:/home/postgres/ [PG10] psql -X -h 192.168.22.99 -p $PGPORT -U w postgres -W
Password for user u: 
psql: FATAL:  no pg_hba.conf entry for host "192.168.22.99", user "w", database "postgres", SSL off

Ok, makes sense. After fixing that:

postgres@pgbox:/home/postgres/ [PG10] psql -X -h 192.168.22.99 -p $PGPORT -U w postgres -W
Password for user w: 
psql: FATAL:  password authentication failed for user "w"

So obviously this is not the way to do it. Do we have the same hashes in pg_shadow?

postgres=# select usename,passwd from pg_shadow where usename in ('w','u');
 usename |               passwd                
---------+-------------------------------------
 u       | md56277e2a7446059985dc9bcf0a4ac1a8f
 w       | md56277e2a7446059985dc9bcf0a4ac1a8f
(2 rows)

Hm, exactly the same. Why can’t we login then? The answer is in the documentation:”Because MD5-encrypted passwords use the role name as cryptographic salt, …”. We can verify that be re-creating the “w” user using the same password as that of user “u”:

postgres=# drop user w;
DROP ROLE
postgres=# create user w login password 'u';
CREATE ROLE
postgres=# select usename,passwd from pg_shadow where usename in ('w','u');
 usename |               passwd                
---------+-------------------------------------
 u       | md56277e2a7446059985dc9bcf0a4ac1a8f
 w       | md53eae63594a41739e87141e8333d15f73
(2 rows)

The hashed values are not the same anymore. What of course is working is to re-create the user with that hash:

postgres=# drop role w;
DROP ROLE
postgres=# create user w login password 'md53eae63594a41739e87141e8333d15f73';
CREATE ROLE

Now we should be able to login with the password ‘u':

postgres@pgbox:/home/postgres/ [PG10] psql -X -h 192.168.22.99 -p $PGPORT -U w postgres -W
Password for user w: 
psql (10.0 dbi services build)
Type "help" for help.

postgres=> 

Fine. Another way of getting the password hashes is to use pg_dumpall using the “–globals-only” switch:

postgres@pgbox:/home/postgres/ [PG10] pg_dumpall --globals-only > a.sql
postgres@pgbox:/home/postgres/ [PG10] grep -w w a.sql 
CREATE ROLE w;
ALTER ROLE w WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS PASSWORD 'md53eae63594a41739e87141e8333d15f73';

Hope that helps.

 

Cet article Can I do it with PostgreSQL? – 19 – Create user … identified by values est apparu en premier sur Blog dbi services.

GCP - How to manage SSH keys on VM Instance?

Surachart Opun - Fri, 2018-04-20 23:13
On Google Cloud Platform, adding SSH keys in Metadata (project-wide public SSH keys). It can help to ssh to every VM instances on Compute Engine easily but it's not a good idea. We are able to do for test, but should not use on Production. We should add SSH Key in OS login. 
https://cloud.google.com/compute/docs/instances/adding-removing-ssh-keys#risks



Question:
How can we block SSH Keys from Metadata(project-wide public SSH keys) on VM instance?
Answer: We can block by checking "Block project-wide SSH keys" on each instance.

In case we have SSH Key on metadata. We are able to ssh by using private key and login like.

So, we block it... On "Compute Engine" - "VM Instances", click [instance name] and "Edit". To check "Block project-wide SSH keys" and "Save".


VM instance should refuse Key what 's not in SSH  Keys of VM instance. (You can remove SSH Keys of project owner on instance, but it will be automatic added when you click "SSH" on GUI).

Additional, we should review and remove SSH Keys in metadata(project-wide public SSH keys), if we ensure we have not used. (Don't remove ssh key of project owner).

After removing, We would like to add SSH Key and don't want to add it in OS login. We are able to add it in SSH Keys on Instance like.


Assume: username is "myuser".

First of all, we have to generate Private and Public Keys. Example uses "PuTTY Key Generator". Because I use "Putty.


Then "Save private key" (We have to use when putty to server) and "Save public key".

To use public key on VM instance, click "Add item".



Example: It's [public key] [username]  

 then "Save".
Note: In picture, it's highlight about [username]

Open "putty", select "Private key file for authentication", fill in ip address and connect.

it's easy, right?
myuser@centos7:~$ id
uid=1003(myuser) gid=1004(myuser) groups=1004(myuser),4(adm),30(dip),44(video),46(plugdev),1000(google-sudoers)If we use command "id [user in project-wide SSH keys], we still see it, but it's unable to ssh on this VM instance.
myuser@centos7:~$ id opun
uid=1001(opun) gid=1002(opun) groups=1002(opun),4(adm),30(dip),44(video),46(plugdev),
Reference:
Categories: DBA Blogs

Relocate Goldengate Processes to Other Node with agctl

Pakistan's First Oracle Blog - Fri, 2018-04-20 22:00
Oracle Grid Infrastructure Agents can be used to manage Oracle Goldengate through Oracle GI. agctl is the utility to add, modify and relocate the goldengate. These Oracle GI agents can also be used with other products like weblogic, mysql etc. 


Frits has a good article about installation and general commands regarding GI agents for a non-clustered environment.

Following is the command to relocate Goldengate processes to other node with agctl. 


[gi@hostname ~]$ agctl status goldengate [service_name]
[gi@hostname ~]$ agctl config goldengate [service_name] [gi@hostname ~]$ agctl relocate goldengate [service_name] --node [node_name] [gi@hostname ~]$ agctl config goldengate [service_name] [gi@hostname ~]$ agctl status goldengate [service_name]

Hope that helps.
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator