3 ways how to connect Oracle to Snowflake – the technical overview

Wouldn’t it be great if you could bring Snowflake into the Oracle database ecosystem? Or, you may need to add Oracle database to the Snowflake ecosystem. What about pushing down the Oracle database ETL to the Snowflake layer?  Or maybe, you have Oracle legacy system and you want to query Oracle data from Snowflake with all changes in data visible in real time. And finally, would you like to incorporate Snowflake data into Oracle PL/SQL ETL code?

Let’s take a look at 3 ways how to connect Oracle to Snowflake.

Continue reading

Posted in Oracle, Snowflake | Tagged , , , , | Comments Off on 3 ways how to connect Oracle to Snowflake – the technical overview

APEX Connect 2021

We are glad to announce, that we will be present on APEX Connect 2021

Continue reading

Posted in Nieokreślona | Comments Off on APEX Connect 2021

Funkcja agregująca COLLECT – część pierwsza

W tym wpisie przyjrzymy się funkcji agregującej COLLECT. Funkcja ta przyjmuje jako argument kolumnę, zwracając w wyniku zagnieżdżoną tabelę dla każdej grupy, po której odbywa się grupowanie. Tabela ta zawiera wiersze złożone z wartości kolumny, która została podana jako argument. Wiersze zawarte w zagnieżdżonej tabeli, przynależą do grupy, dla której wywołana została funkcja (rys. 1.)  

Continue reading

Posted in Oracle, Oracle APEX, Oracle SQL, Oracle SQL Zaawansowany | Tagged , | Comments Off on Funkcja agregująca COLLECT – część pierwsza

Analytic SQL | Snowflake

Analytic SQL Examples: Download

 

Posted in Snowflake | Comments Off on Analytic SQL | Snowflake

Expose Big Data using the Oracle Application Express (APEX)

In this article we will describe how to expose Big Data in Oracle Application Express (APEX) using tools/mechanisms provided by Oracle.

Examples are based on:

  • Oracle Big Data Lite Virtual Machine – For testing and educational purposes only you can get Big Data Lite virtual machine here.
  • Examples in this article are based on data from the Department of Transportation (DOT):  https://www.transtats.bts.gov. Please download csv file from here: Prezipped file for January 2018.
Continue reading
Posted in Nieokreślona | Tagged , , , , , , | Comments Off on Expose Big Data using the Oracle Application Express (APEX)

Load Balancer with Oracle APEX in the Amazon Cloud (AWS)

We provide multiple products related to Oracle APEX in the AWS Amazon Marketplace. One of this product allows you to run Oracle APEX and ORDS on top of Oracle Standard Edition with license provided by Amazon in Pay-As-you-Go model. Our product: Oracle APEX 19c with ORDS 19.1 for Amazon Oracle RDS on CentOS 7 bundles ORDS, Tomcat, APEX 19c and other software components in single AMI pre-configured for usage with external Amazon RDS for Oracle

Due to fact that database instance is external to ORDS/APEX/Tomcat instance there is possibility to run multiple ORDS linked to single database. It allows you to serve your APEX application by multiple ORDS instances connected to single database. There are dedicated Amazon AWS settings in EC2 dashboard called Load Balancer that can cooperate with multiple instances of
Oracle APEX 19c with ORDS 19.1 for Amazon Oracle RDS on CentOS 7 to leverage traffic.

At the end architecture for load balancing would look like that:

Continue reading
Posted in Amazon AWS Marketplace, AWS, Oracle APEX, Oracle APEX Advanced, Oracle DBA | Tagged , , , , , , | Comments Off on Load Balancer with Oracle APEX in the Amazon Cloud (AWS)

svnAPEX BETA demo server is public now

We’ve published svnAPEX BETA version (aka APEX Version Control) on our public DEMO server.

svnAPEX allows you to follow industry standard workflow and increase efficiency of your APEX development process by integration the Application Builder with SVN version control system. To find more about our tool see http://datacons.co.uk/apex-version-control/. To get access to DEMO server – continue reading please.

Our DEMO server allows you to check functionality of svnAPEX tool, see its behavior and review interface.

Continue reading

Posted in Oracle APEX, Oracle APEX Advanced | Tagged , , , , , , | Comments Off on svnAPEX BETA demo server is public now

AOUG presentation: JavaScript, CSS and jQuery in APEX 19c

We presented an interested topic on the Austrian Oracle User Group event: AOUG Anwenderkonferenz 2019 – “Vienna calling. Technical but fun!”. The presentation title was “JavaScript, CSS and jQuery in APEX 19c” and it describes how to go beyond declarative options of Oracle APEX.

You can review a sample application on https://apex.oracle.com/pls/apex/ (workspace: datacons, username: datacons, password: datacons) and you can run it at https://apex.oracle.com/pls/apex/f?p=124894. The presentation and source code of the sample application can be also downloaded here.

Posted in Nieokreślona | Comments Off on AOUG presentation: JavaScript, CSS and jQuery in APEX 19c

APEX 19c in AWS Amazon Cloud

APEX 19c is already available in AWS Amazon Cloud. See more at https://aws.amazon.com/marketplace/pp/B07QC2LMM2

News in this AMI release:

  • Oracle Application Express is upgraded to version 19.1c (19.1.0.00.15) and license and documentation links in Amazon Marketplace were updated accordingly. For more details: see Product Overview at https://aws.amazon.com/marketplace/pp/B07QC2LMM2
  • Default APEX Instance ADMIN password generation on initial boot was changed to be based on Machine Instance ID. For more details: see Usage Instructions at https://aws.amazon.com/marketplace/pp/B07QC2LMM2
  • Default disk size, during launch of AMI, was increased to 25 GB

See also Oracle APEX 19c Release Notes

Posted in Nieokreślona | Comments Off on APEX 19c in AWS Amazon Cloud

JavaScript, CSS and jQuery in APEX 19c

We have been on OUG Irealand 2019 and we presented very interesting topic about going beyond APEX declarative options:  “JavaScript, CSS and jQuery in APEX 19c“. Here you can download our presentation and Sample Application with working examples.

Posted in Oracle APEX Advanced | Tagged , , , , , | Comments Off on JavaScript, CSS and jQuery in APEX 19c