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

APEX in the Cloud

We enabled APEX 18c to the Amazon Cloud

Whenever you want just to try the newest APEX for only one hour or you need hundreds of APEX instances for months – with the AWS Cloud (and us :)) – you can! Full pre-configured stack of software: Oracle DB, APEX, ORDS, Tomcat and Nginx on dedicated secured instance is ready for you in less than 10 minutes.

Check more at https://aws.amazon.com/marketplace/pp/B07NDJFCVV

Continue reading

Posted in Oracle APEX, Oracle DBA | Tagged , , , , | Comments Off on APEX in the Cloud

Oracle XE 18c is available for download

We’ve been waiting a very long time but finally it is:
New version of Oracle XE: Oracle XE 18c is available for download (only for Linux now).

What is even more important:
– limits are extended to 12GB of user data, 2GB of RAM and 2 cores
– a lot of new options disabled in 11g XE are now available for example: compression, spatial, partitioning, multitenant/pluggable databases, advanced analytics

Don’t wait and download Oracle XE 18c now.

Posted in Oracle, Oracle DBA | Tagged , , , | Comments Off on Oracle XE 18c is available for download

Oracle APEX 18.2c is available for download

Oracle APEX 18.2c is available for download. Check this link: https://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

There are great new features like REST Enabled SQL, JET charts improvements, Interactive Grid improvements, JavaScript API documentation for widgets, better master-detail, improvements if APEX Font and App Builder interface. See new features at https://docs.oracle.com/database/apex-18.2/HTMRN/toc.htm#HTMRN-GUID-D6D545CB-3ECD-468A-9E7F-8CC09F7F478B and all features at: https://apex.oracle.com/en/platform/features/

Posted in Oracle APEX | Tagged , , , , , | Comments Off on Oracle APEX 18.2c is available for download

New Oracle APEX 5.2 for Christmas!

There is APEX 5.2 Early Adopter available on https://apexea.oracle.com. Release 5.2 brings a suite of new features including REST enabled SQL, improvements to REST Service Consumption, an all new Create App Wizard, new chart types, APEX Spotlight Search, and a whole lot more

Posted in Oracle APEX | Tagged , , | Leave a comment