SQL and Analytics
Discussion List
-
to integrate MS SQL Server dB with ADWContent Can we integrate SQL Server dB with Oracle ADW using Oracle Application Integration where operations like POST,GET,PUT can take place between ADW and SQL Server … -
Accessing ADW without using APEX or SQL Dev tool to create REST APIsContent Hi team, Can we access Oracle ADW through some other tools and by not using its own components like Oracle APEX or Oracle SQL Web Developer tool to make REST API…
-
To extract hostname, port name, service name from Oracle Autonomous Data WarehouseContent How can we extract hostname, portname , service name of Oracle ADW cloud as we are trying to connect a database using Python scripts and the Python script is dem…
-
To generate each rows with unique IDs (primary key) in ascending orderContent I am inserting values inside ADW in Oracle Apex through REST API parameters. I am able to get unique values but the order is getting random after inserting two r…
-
GA ANNOUNCEMENT - Oracle Cloud Infrastructure Operations InsightsContent Oracle Cloud Infrastructure Operations Insights provides 360-degree insight into database resource utilization and capacity. It is FREE to use with ADW and ATP -…Keith Laker-Oracle 24 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database -
GA ANNOUNCEMENT - APEX 20.2 Now Available In Autonomous Database-SharedContent The version of APEX within Autonomous Database has been upgraded to version 20.2. This release of APEX introduces several new features and enhancements to help d…Keith Laker-Oracle 15 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - Oracle Cloud Infrastructure SDK for PL/SQLContent The Oracle Cloud Infrastructure SDK for PL/SQL enables you to write code to interact with Oracle Cloud Infrastructure resources, including Autonomous Database. T…Keith Laker-Oracle 14 views 0 comments 1 point Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - SQL Macros now available in Autonomous Data WarehouseContent What is a SQL Macro? It is a new and unique way for SQL developers to encapsulate complex processing which can then be reused within SQL statements. Unlike bespo…Keith Laker-Oracle 8 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Autonomous Database Newsletter - September 03, 2020Content Welcome to our latest customer newsletter for Autonomous Database on Shared Exadata Infrastructure. This newsletter covers the following new features and topics:…Keith Laker-Oracle 16 views 0 comments 1 point Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - ADW now supports ORC filesContent ADB has expanded object storage support in two important ways: it can now query ORC files as well as complex data types found in Parquet, ORC and Avro files. ORC…Keith Laker-Oracle 12 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - SQL access to tenancy details for ADBContent When you file a service request for Autonomous Database, you need to provide the tenancy details for your instance. Tenancy details for the instance are availabl…Keith Laker-Oracle 25 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - Support for SODA Documents and CollectionsSummary Autonomous Database now supports loading and using Simple Oracle Document Architecture (SODA) documents and collections. SODA allows developers to store, search,…Keith Laker-Oracle 15 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - Oracle Graph Server and Client 20.1 Support ADWContent Oracle Graph Server and Client 20.1 is a software package that works with Autonomous Database. It includes the in-memory analytics server (PGX) and client librar…Keith Laker-Oracle 14 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - Send Emails Using ADBContent Autonomous Database now includes the UTL_SMTP package. This makes it possible to send emails via PL/SQL from within Autonomous Database. However, note that the o…Keith Laker-Oracle 35 views 0 comments 3 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - REST APIs Added to DBMS_CLOUDContent The DBMS_CLOUD REST API functions provide a generic API that lets you call any REST API with the following supported cloud services: * Oracle Cloud Infrastructur…Keith Laker-Oracle 21 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - Partitioned External Tables now support Parquet and Avro FilesSummary CREATE_EXTERNAL_PART_TABLE procedure now supports both Parquet and Avro files formats.Content CREATE_EXTERNAL_PART_TABLE procedure now supports both Parquet and …Keith Laker-Oracle 23 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
New! AskTOM Oracle Machine Learning Office HoursSummary In this first Office Hours session for Oracle Machine Learning, Mark Hornick provides an introduction to the Oracle Machine Learning (OML) family of products, bo…Marcos Arancibia-Oracle 21 views 0 comments 1 point Most recent by Marcos Arancibia-Oracle Autonomous Database -
GA Announcement - 19c Preview for ADB now availableSummary You create a preview version of Autonomous Database either by provisioning a new database or by cloning an existing databaseContent You create a "19c Preview" ve…Keith Laker-Oracle 17 views 0 comments 1 point Most recent by Keith Laker-Oracle Autonomous Database
-
Oracle Autonomous Data Warehouse - Access Parquet Files in Object StoresSummary ADW can now access the data directly from the object store – providing people the ability to access data as soon as it lands – and then for optimized access load…Keith Laker-Oracle 11 views 2 comments 1 point Most recent by Keith Laker-Oracle Autonomous Database
-
OCI Performance Hub real-time monitoring now available for ADBSummary You can now get a real-time and historical view of performance data directly on the OCI console using Performance Hub.Content You can now get a real-time and his…Keith Laker-Oracle 25 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA Announcement - ADW is now available with Auto ScalingSummary You can select auto scaling during provisioning or later using the Scale Up/Down button on the Oracle Cloud console.Content ADW is now available with Auto Scalin…Keith Laker-Oracle 16 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA Announcement - ADW now supports Oracle Text.Summary Autonomous Data Warehouse now supports Oracle Text. This makes it possible to perform linguistic analysis and search text using a variety of strategies.Content A…Keith Laker-Oracle 23 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA Announcement - ADW now enabled with spatial intelligenceSummary Autonomous Data Warehouse has enabled the core set of Spatial functionality including the native spatial type, index, and associated core analysis operators and …Keith Laker-Oracle 14 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA Announcement : Management Cloud now supports Autonomous DatabaseSummary Oracle Management Cloud now supports monitoring Autonomous Databases via its Oracle Database Management console.Content Oracle Management Cloud now supports moni…Keith Laker-Oracle 13 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA Announcement : Oracle XML DB features are now supported in Autonomous Data WarehouseSummary Oracle XML DB features are now supported in Autonomous Database.Content Oracle XML DB features are now supported in Autonomous Database. This enables existing cu…Keith Laker-Oracle 3 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Ability to Change License Type is Now LIVE!Summary You can now quickly and easily change the type licensing for your Autonomous Database from BYOL to a new cloud subscription or vice-versa.Content As of today (We…Keith Laker-Oracle 12 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Cloning is now live for Autonomous Data WarehouseSummary The new cloning feature of autonomous data warehouse provides a way in a few mouse clicks to make exact copies of your data warehouse, either including or exclud…Keith Laker-Oracle 13 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Data integration using database dump files instead of connectors & SQLContent Need advice or examples for data migration and/or integration at the full database level, a bit like ELT from cloud transactional to cloud analytic. I saw there'…
-
Free Comprehensive Review of Big Data Warehousing at #OOW18Summary This review is for everyone who either missed this year’s conference or just wants to relive the amazing experience all over again (but focusing on just the best…Keith Laker-Oracle 12 views 0 comments 2 points Most recent by Keith Laker-Oracle Autonomous Database
-
Fast way to get started with ADWSummary We have launched a refreshed "Getting Started" hands-on lab for Autonomous Data WarehouseContent We have launched a refreshed "Getting Started" hands-on lab for …Keith Laker-Oracle 27 views 0 comments 1 point Most recent by Keith Laker-Oracle Autonomous Database