Tag: Database Cloud Service

Quest Forum Digital Event 2020

With the help of SpearMC and Oracle Cloud Infrastructure, First Financial Northwest Bank (FFNWB) migrated their accounting, asset management, and accounts payable functions to PeopleSoft FSCM in four months — all with minimal internal resources and no in-house infrastructure.  Come learn how OCI enabled this rapid implementation and supports efficient production support.

CHALLENGE PRESENTED: FFNWB’s Financial Accounting Solution was not scaling with their needs. It was slow, lacked security and functionality, and left their team powerless to enhance the system or add new features.

PROPOSED SOLUTION: SpearMC guided FFNWB through the process of migrating to PeopleSoft on Oracle Cloud Infrastructure (OCI). This new solution includes scalable computing power and storage, disaster recovery, and network-to-network connectivity.

Quest Forum Digital Event 2020

In this session hear how SPPS and Collier IT (CIT) collaborated to build and support Oracle’s PeopleSoft Human Resources and PeopleSoft Financials in Oracle Cloud Infrastructure. SPPS is a Minnesota-based public school system and CIT is a technology consulting company, and the two have partnered to successfully migrate SPPS’s PeopleSoft workload to Oracle Cloud Infrastructure. Learn about its success strategies and lessons learned about the implementation and transition phases. Learn how SPPS leveraged the expertise of CIT to move to Oracle Cloud Infrastructure. Hear how CIT provided ongoing infrastructure support services to keep SPPS infrastructure up and running.

Quest Forum Digital Event 2020

Enterprise organizations need a modern protection and recovery solution that is capable of quickly recovering databases to any point in time with the least amount of administrative effort from DBAs and backup administrators without impacting the required RPOs/RTOs. This session will focus on how to architect modern business continuity and disaster recovery solutions for business-critical Oracle workloads on VMware Hybrid Cloud environment. This session will also inculcate best practices that need to be taken into consideration when setting BC and DR for critical workloads. In addition to providing disaster recovery, license compliance is another important aspect of setting up an Oracle environment and this session will address how to effectively stay compliant using industry-standard License Management tool.

Quest Forum Digital Event 2020

Organizations today are looking to free themselves from the constraints of on-premises databases and leverage the power of fully managed databases in the cloud. Amazon RDS for Oracle is a fully managed relational database service that automates time-consuming database administration tasks while cost-effectively running your choice of Oracle database engine in AWS. This session dives deep into the new features and best practices that make your Oracle database deployments secure, scalable, and highly available.

Quest Forum Digital Event 2020

Oracle Log Analytics Cloud Service offers an easy way to monitor, aggregate, analyze, and correlate log events from across your database and Exadata environment. In this session learn how DBAs can easily configure log collection and efficiently analyze logs from their database environment to rapidly troubleshoot problems. See how to use plain language analysis to easily find errors across different log sources. Experience the power of machine learning techniques to rapidly identify anomalies that can lead to a problem’s root cause and eliminate finger-pointing.

Quest Forum Digital Event 2020

Use the latest technology on robotics, machine learning & Oracle chatbots to create the future with AI.  We will explore how to leverage and integrate robotics & machine learning into your companies tech plan.  We'll show the state of robotics and how you can test and use this technology to create the future.

Quest Forum Digital Event 2020

In this session, Blaine Carter will demonstrate how to REST enable your database using Oracle Rest Data Services (ORDS). He will demonstrate how to use SQL Developer to create and deploy REST services in ORDS. First, Blaine will "Auto Rest" enable a table and a PL/SQL package. Then, he will secure the API and create an OAuth2 client that can be used to access the service. Next, he will walk through the steps of creating a custom REST API using the REST Data Services wizard. This API will be used to POST image files into a BLOB column in the database and the GET handler will serve the image directly in a web page. You will leave this session with an understanding of how to quickly create REST services on your own database.

Quest Forum Digital Event 2020

The IOUG Cloud Computing (and Virtualization) Special Interest Group (SIG) is dedicated to communication and information interchange around the subject matter of Cloud Computing. The SIG provides a vendor-neutral perspective to the private and public database cloud and delivery mechanisms for Database-As-A-Service (DBaaS), Infrastructure-As-A-Serice (IaaS) and select Platform-As-A-Service (PaaS) technologies. Join us at this Cloud SIG session at Quest Forum Digital Event   Community Education Weeks for a panel discussion on the latest cloud technology topics such as Oracle Gen 2 Cloud, Database-as-a-Service, and Oracle Autonomous Databases Cloud service, etc. The panel will also discuss how the cloud may impact you and how your applications & databases along with your skills and career can adapt to the cloud age.

Quest Forum Digital Event 2020

Setting up Cloud Environments using the Web UI is only the second-best option. The method of choice is Scripting. While HashiCorps Terraform has become the lingua franca for defining large setups, it appears to be a bit unwieldy for small changes. Oracle provides the OCI Command Line Interface (CLI) as OpenSource on GitHub, which is ideal for those small changes.

This talk introduces to Scripting with the OCI CLI. It walks through the process of setting it up. A quick orientation is followed by a deep dive in the command line and JSON Parameters. Tips and Tricks as well as common caveats an how to avoid them lead to the conclusion. The presentation contains a live demo. All Demos are available for download.

Quest Forum Digital Event 2020

Complex performance situations are not always quickly diagnosable using an AWR time-based analysis or an ASH sample-based analysis. And certainly, the diagnosis will not be completed the second new data becomes available or before a support ticket has been received!

A solution is to use a supervised learning classification machine learning model. We can train the model to recognize and "understand" a virtually unlimited number of Oracle performance and business-related data.

Once trained, we will present the model with just-available data asking, for example, if a support ticket will likely be submitted. Or perhaps, if the performance will likely be green, yellow, or red.

Join me as I build a "Poor Performance" indicator using 100% free industry-standard tools, such as Python and the "Always Free" Oracle Autonomous Database with Oracle ML SQL Notebooks. All presentation slides, scripts, and a recording of the demonstration are available!