Skip to main content

New plugins to store files outside your database!

The plugins we release helps you easly upload files to Amazon AWS S3.
Below we have simple installation tutorial and for more you can always visit our DEMO application.

Actually, this plugin is in 2 parts:
- "FMcomponent" part is APEX item. Something like native filebrowser item but fully configurable. You can always customize how it with a sparkle of CSS.
- "FMproviders" part serves as connection to one of the file storage service (eg. Amazon S3, Dropbox, etc)





To use it, you have to grand DBMS_CRYPTO privilege to your Oracle schema:
grant execute on sys.dbms_crypto to <schema>;
Next, install both plugins into your APEX application: FMcomponent and specific FMprovider (currently we provide AWS S3 FMprovider).

At the end you have to install additional package. As a schema owner open your favorite SQL editor and run as first apexutil_fm_aws.pls and second apexutil_fm_aws.plb.

Now you can try to add plugins in your application.
Go to Apex Application builder, create Static Content region. Add to this region items:

  1. Item type FM Provider AWS3 [Plug In]
    You must fill Settings region according your Amazon S3 bucket and credentials. (this wideo will help you)
  2. Item type FM Component [Plug In]
    Settings:
    Provider - select FM Provider AWS3 item
    Collection - APEX collection name to store metadata information (available metadatas: transformed path, original path, download link, mimetype, file size)
    Multiple - switch on/off multi upload file
    Max Files - max. number of uploaded files
    Show Drop Zone - switch on/off drag and drop
    Button label - name of button label
    Transform Path - PL/SQL function body to transform path (you can use it to prevent file overwrite). Read more in our sandbox
    Accept - which file types are accepted (f.ex. image/* audio/* video/*)
    Max Size - maximum size file (client validation)
From now you can try to use it.

More information and demo you can find in our SANDBOX pages.

Comments

Popular posts from this blog

ORACLE APEX with MySQL !

About 10 years ago I tried to build APEX application on MS SQLServer. It was possible but performance was not satisfactory. (You can read this post here)...
Today I will describe how to use APEX with MySQL. Obviusly I don't think it is good idea to build APEX app only on MySQL. It can be used as part of Hybryd solution (Oracle + MySQL or Postrgres).



My description covers integration with MySQL. As a result will be APEX application with Interactive Report and CRUD form based on MySQL data.
Description contains two parts: First part is a MySQL site, Second part is a APEX application part


Prerequisites:
Oracle 11g+APEX 18.1+MySQL/PostgresRestSQL
I. MySQL Part
1. MySQL contains simple apexdb database with one apexutil table.



2. To use this database install RestSQL. What is RestSQL? RestSQL is an open-source, ultra-lightweight data access layer for HTTP clients. RestSQL is a persistence framework or engine in the middle tier of a classic three tier architecture: client, application ser…

TWO-Factor Authentication with APEX application.

Two-factor authentication means that you must have two factors, to access your account. The first factor is something you know, like your login and password combination. The second is something you have, like a mobile device with a security app installed. That second factor — the mobile device with a security app — adds an extra layer of protection to your account. Even if hackers steal your password, they can’t log in, because they don't have your mobile device.



Try 2FA on our SANDBOX environment!
It is the most popular 2FA option based on Times-based One-Time Password (TOTP) alghoritm described in RFC 6238 and RFC 4226. TOTP is supported by Google Authenticator, Microsoft Authenticator, Authy 2-Factor Authentication and many other mobile apps. The most popular online services like Facebook, Google, Twitter use TOTP to protect user's accounts.

TOTP is a standard algorithm based on cryptographic hash method SHA-1. SHA-1 algorithm's implementation is available since Oracle 1…

Oracle APEX – Amazon ALEXA integration WITHOUT Amazon Lambda ! (PART 2)

In the last blog post I prepared Oracle side. In this post I will show, how to prepare ALEXA Skill and how to integrate all layers.

Few weeks ago Amazon implemented new version of Alexa Skill Kit. Alexa Skill Kit is like a APEX builder. Low code technology, so you don't need to write any code :)

Let's start ! Go to Amazon Developer Console

1. Click Get Started on Alexa Skills Kit


2. As you can see on screen below there is already one skill on my list. Click on Create Skill to Create new one.

3. The name of my Skill will be - APEXUTIL Pizza  :) but you can name it as you wish.


4. Select Custom

5. Create Invocation. Users say a skill's invocation name to begin an interaction with a particular custom skill. For example, if the invocation name is "apex pizza", users can say: "Alexa, ask apex pizza ...."

6. One skill can have one or more Intents. An intent represents an action that fulfills a user's spoken request. For demo I'll use only one Intent: &…