There is a fundamental shift underway in IT to include open, software defined, distributed systems like Hadoop. As a result, every Oracle professional should strive to learn these new technologies or risk being left behind. This session is designed specifically for Oracle database professionals so they can better understand SQL on Hadoop, both on-premises and…

Going "serverless" is the latest technology trend for enterprises moving their processing to the cloud, including data integration and ETL tools. But what does that mean and when should I use serverless ETL? In this session, we'll dive into the world of Amazon's fully managed data processing service called AWS Glue. With no server to provision or resources to allocate, and an easy to populate metadata catalog, AWS Glue allows the data engineer to focus on his or her craft; building data transformations and pipelines. Gaining an understanding of the similarities and differences between traditional ETL tools, such as Oracle Data Integrator, and Glue will prepare attendees for the new world of data integration.

In forever changing Technology world, What an Oracle DBA should know to support every day activities in MySQL database! This presentation is focused on fast tracking the traditional Oracle DBA into the world of MySQL. Rapidly changing technology makes an Oracle DBA’s daily tasks as challenging as it can be. Instead of supporting only Oracle…

Nearly every conversation with Oracle surrounding hardware includes a discussion about their various cloud offerings.  In the Exadata world, there are typically three choices: the traditional arrangement, an Oracle-hosted Exadata Cloud service, and the Exadata Cloud Machine.  The latter option, also known as "Cloud @ Customer," proclaims to offer the flexibility of a cloud offering,…

  Apache Kafka is a massively scalable message queue used for building real-time data pipelines and streaming applications that are high-performing and fault tolerant. This presentation will introduce Kafka from the perspective of a mere mortal Oracle DBA and share the experience of (and challenges with) getting events from relational databases to Kafka. We’ll demonstrate…

The open source streaming data platform, Kafka, is taking the world by storm. In their own predictions for 2017 Oracle even asserted that “Kafka looks to be the runaway Big Data technology of 2017”. A powerful platform in its own right, Kafka is designed, from the ground up, as a fast, scalable, durable, distributed system.…

As the complexities of Oracle solutions continue to grow, providing IT environments a simplified way to automate key processes of software delivery and changes within IT infrastructure is of utmost importance. With the use of containers, system administrators, database administrators, and software developers can take advantage of delivering Oracle databases and their closely tied applications…

Let’s revisit the ways to programmatically load data into an on-premise or Cloud Oracle database.  Many applications need to load data from external sources as some part of the workflow. What is the best data load option for your environment and your requirements?  Is your spreadsheet data CSV or true XLSX? Are you loading CLOBs or LOBs? What are the APEX data load options? Which data load methods work in a Cloud database? What methods make most sense for your users, for your environment, for your budget? This presentation reviews a collection of data load options, including the APEX Data Load wizard, external tables, ORDS bulk data load, open source interfaces, plugins and APEX APIs helpful for custom coding.

Demonstrations and examples are geared toward APEX applications, yet most of the techniques described can be used in any PL/SQL application. Attendees gain sufficient knowledge to make an intelligent choice for their application data loading needs.

Oracle Databases are a target of cyber-attacks by hackers looking to obtain sensitive data such as credit card numbers and personally identifiable information used in identify theft. Even though databases are not externally accessible, they are still a target as most cyber-attacks penetrate the network perimeter and look for high value targets within your internal network. Based on lessons learned from recent high-profile cyber-attacks, a framework and techniques for detection and prevention of these cyber-attacks against database will be presented.