APEX Office Print Dimitri Gielis 0.01 5-SEP-2019 APEX Office - - PowerPoint PPT Presentation

SLIDE 1

0.01

APEX Office Print

Dimitri Gielis 5-SEP-2019

SLIDE 2

APEX Office Print

www.apexofficeprint.com

0.02

SLIDE 3

APEX Office Print

www.apexofficeprint.com

0.03

“We make reporting easy.”

• Dimitri Gielis, CEO -

SLIDE 4

APEX Office Print

www.apexofficeprint.com

0.04

Export data in the format YOU want.

SLIDE 5

APEX Office Print

www.apexofficeprint.com

0.05

Anyone can do it.

SLIDE 6

Print in just 4 simple steps!

SLIDE 7

APEX Office Print

www.apexofficeprint.com

0.07

Create a template.

SLIDE 8

APEX Office Print

www.apexofficeprint.com

0.08

Popular

• pen

XML editors

SLIDE 9

APEX Office Print

www.apexofficeprint.com

0.09

Select the data.

SLIDE 10

APEX Office Print

www.apexofficeprint.com

0.010

Choose your

• utput

type.

SLIDE 11

APEX Office Print

www.apexofficeprint.com

0.011

Print!

SLIDE 12

APEX Office Print

www.apexofficeprint.com

0.012

SLIDE 13

APEX Office Print

www.apexofficeprint.com

0.013

SLIDE 14

APEX Office Print

www.apexofficeprint.com

0.014

SLIDE 15

APEX Office Print

www.apexofficeprint.com

0.015

SLIDE 16

APEX Office Print

www.apexofficeprint.com

0.016

SLIDE 17

APEX Office Print

www.apexofficeprint.com

0.017

Interactive Report

SLIDE 18

APEX Office Print

www.apexofficeprint.com

0.018

Barcode and QR Code

SLIDE 19

APEX Office Print

www.apexofficeprint.com

0.019

PDF Tools

SLIDE 20

APEX Office Print

www.apexofficeprint.com

0.020

PowerPoint

SLIDE 21

APEX Office Print

www.apexofficeprint.com

0.021

JET Charts

SLIDE 22

APEX Office Print

www.apexofficeprint.com

0.022

PowerPoint

SLIDE 23

APEX Office Print

www.apexofficeprint.com

0.023

D3

SLIDE 24

APEX Office Print

www.apexofficeprint.com

0.024

Calendar

SLIDE 25

APEX Office Print

www.apexofficeprint.com

0.025

HTML to Word

SLIDE 26

APEX Office Print

www.apexofficeprint.com

0.026

Office Chart

SLIDE 27

APEX Office Print

www.apexofficeprint.com

0.027

URL as Template

SLIDE 28

AOP Templating Engine

SLIDE 29

APEX Office Print

www.apexofficeprint.com

0.029

AOP Template

SLIDE 30

APEX Office Print

www.apexofficeprint.com

0.030

AOP Report (no template needed)

SLIDE 31

APEX Office Print

www.apexofficeprint.com

0.031

Tags for Custom Template

SLIDE 32

Architecture

SLIDE 33

APEX Office Print

www.apexofficeprint.com

0.033

Up and running in minutes.

SLIDE 34

APEX Office Print

www.apexofficeprint.com

0.034

Cloud or On-premises

AOP Architecture

Browser Database Server Web Server

SLIDE 35

APEX Office Print

www.apexofficeprint.com

0.035

REST API

SLIDE 36

APEX Office Print

www.apexofficeprint.com

0.036

PL/SQL API

SLIDE 37

APEX Office Print

www.apexofficeprint.com

0.037

APEX Plug-in

SLIDE 38

APEX Office Print

www.apexofficeprint.com

0.038

APEX Sample App

SLIDE 39

APEX Office Print

www.apexofficeprint.com

0.039

AOP Web Editor

SLIDE 40

APEX Office Print

www.apexofficeprint.com

0.040

Bursting

SLIDE 41

AOP Customers

SLIDE 42

APEX Office Print

www.apexofficeprint.com

0.042

SLIDE 43

APEX Office Print

www.apexofficeprint.com

0.043

Awesome Support

SLIDE 44

APEX Office Print

www.apexofficeprint.com

0.044

AOP Support emails

SLIDE 45

APEX Office Print

www.apexofficeprint.com

0.045

AOP Slack Channel for Free AOP Cloud

• n apex.world (#orclapex)

SLIDE 46

APEX Office Print

www.apexofficeprint.com

0.046

OTN APEX Forum

SLIDE 47

APEX Office Print

www.apexofficeprint.com

0.047

DM or Public Messages

• n Twitter

SLIDE 48

APEX Office Print

www.apexofficeprint.com

0.048

APEX Community

SLIDE 49

APEX Office Print

www.apexofficeprint.com

0.049

AOP Features

SLIDE 50

APEX Office Print

www.apexofficeprint.com

0.050

Table/View, SQL Query or PL/SQL Returning SQL

Remote Database

REST Web service

Web Source

Table/View, SQL Query or PL/SQL Returning SQL

Local Database

Supported APEX Features

WYSIWYG and extra settings

Calendar

New screenshot mechanism to load SVG, Canvas or

• ther elements

Charts

WYSIWYG for IR, added server-side conditions

Interactive Report & Grid

AOP Features

SLIDE 51

APEX Office Print

www.apexofficeprint.com

0.051

Split into one page per file

• r merge into one file

Split & Merge

Ideal for POS system, one- page-pdf without page size

One-Page-PDF

Add files before and after your document

Prepend & Append Files

PDF Features

Word, Excel, PowerPoint, HTML, Markdown, Text

Any document to PDF

png, jpg, gif, bmp, ...

Images to PDF

AOP Features

Enter password to read and/or modify

Secure PDF

SLIDE 52

APEX Office Print

www.apexofficeprint.com

0.052

Sample app for APEX 5.x/18.x/19.x

AOP Sample App

Include D3.js objects and let AOP render them

D3 support

Even easier to debug and see what AOP is doing behind the scenes

Web Editor

Other Key Features

TOC, Page numbers, table improvements, HTML conversion, ...

Word Enhancements

Dropbox, Amazon S3, One Drive

Cloud Integration

Horizontal loops, pivot, cell styles, ...

Excel Enhancements

Support more tags, HTML integration

Markdown Enhancements

Modular development and maximal reuse

Sub-Templates in Word

Output to text, printer and POS support

Text Support

Easy to include page or application items

Reference APEX Items

AOP Features

SLIDE 53

APEX Office Print

www.apexofficeprint.com

0.053

Showcase for new features

AOP Sample App

Ability to add dynamic texts in PDF blob, Repeat output x number of times

PDF Enhancements

Export without having to define a template (for IR/IG/Classic Report)

AOP Report Export

AOP 19.2

Translated Headers, Percent Graph

Report Enhancements

FTP/ SFTP

Cloud Integration

Ability to export classic report with {&report&} tag

Classic Report

More control over the exported native charts

Chart Enhancements

AOP Features

GraphQL, JSON, XML

New Data Sources

SLIDE 54

2014

2015 2016 2017 2018 2019 APEX 5.0 Apr 2015 0.9 Public Beta Jul 2015 AOP 1.0 Sep 2015 1.4 Oct 2015 1.5 Nov 2015 1.6 Dec 2015 AOP 2.0 Mar 2016 2.1 May 2016 2.2 Sep 2016 2.3 Nov 2016 2.4 Dec 2016 APEX 5.1 Dec 2016 2.5 Mar 2017 AOP 3.0 Jun 2017 3.1 Oct 2017 3.2 Nov 2017 3.3 Jan 2018 3.4 Feb 2018 3.5 Mar 2018 APEX 18.1 May 2018 AOP 18.1 Sep 2018 APEX 18.2 Sep 2018 18.2 Oct 2018 AOP 19.1 Jan 2019 APEX 19.1 Mar 2019 19.2 Jul 2019 APEX 19.2 Sep 2019 19.3 Oct 2019 AOP 0.1 Private Beta Mar 2015

2020

AOP Dev Begins Sep 2014 Dec 2014 apexofficeprint.com Sunil’s 1st Day Feb 2015 Cloudofficeprint.com Feb 2018 Sample Application APEX Process Plug-in AOP PL/SQL API Ability to override PDF converter Interactive & Classic Report support Word, Excel, PDF support Dynamic Action Plug-in IR highlight, filter, group by, pivot, chart & computation support Bar, column, line, pie, stacked column, bar, area, radar charts Remote Debug Rich Text Editor (HTML) to Word Documentation available in HTML IR to Excel Support Multiple IR Support Automated Tests Tabular Form Support Interactive Grid Support Enterprise license available AOP Cloud is clustered AOP Web Editor Introduced HTML, Markdown, & Text Templates Output to in-line region Logging ability added (--logging) Image support from URL Run AOP in Cluster Mode IP Printer support Barcodes Docker Image HTTPS support RTL support Excel Sheet generation Ability to specify Failover URL Scatter, Bubble, Stock, 3D Pie, Combined charts supported High performance PDF generation for Enterprise Edition Spanish Documentation Free Cloud Tier Rest Datasource Support All Calendar Views available Lossless screenshots PDF Enhancements – merge, split, one-page (receipt) Convert Plug-in Introduced Word Table of Contents support New Sample Application Word Sub-Templates D3 Support Export to any cloud provider (Dropbox, S3, etc) Pay-as-you-go Plan New Cloud Plan & Pricing CSV support Unlimited Development Credits URL as a template Macro-Enabled Office File support iCal format Font Awesome support AOP in Oracle Cloud Jul 2019 AOP hook in APEX Jackie’s 1st Day Mar 2019

AOP Roadmap

Business Plan Apr 2015

SLIDE 55

Momentum

SLIDE 56

SLIDE 57

SLIDE 58

SLIDE 59

Questions?

SLIDE 60

Pricing

SLIDE 61

Cloud pricing as of May 2019

SLIDE 62

On-premise pricing as of May 2019