Your Database Experts PRESENTATION MAP 3. About our company 4. - - PowerPoint PPT Presentation

Your Database Experts

Database Consulting was founded in 2009 as an

• utsourcing

and Oracle Database specialised education centre with in-house developed trainings and workshops. We are an Oracle Approved Educational Centre since 2015. Our team is very much comprised of a creative and forward-thinking experts in Oracle technology, specialised in APEX, Forms and Data Warehousing. We subsequently provide services in the following fields

• f

expertise: developers, analytical teams, administrators, tuning experts, project management teams.

PRESENTATION MAP

• 4. Nearshoring
• 12. APEX in the Cloud
• 13. Oracle migration to the Cloud
• 10. APEX Office plugins
• 11. APEX Mobile Applications
• 5. Forms to APEX migration
• 8. APEX Dedicated Applications
• 17. Cooperation models
• 19. Contact us
• 15. Data Warehousing and Big Data
• 3. About our company

Database Consulting 2019

3

Our team is very much comprised of a creative and forward-thinking experts in Oracle technology, specialised in APEX, Forms and Data Warehousing. We subsequently provide services in the following fields of expertise: developers, analytical teams, administrators, tuning experts, project management teams etc. Furthermore, we also offer comprehensive database Managed Services that will ensure the security and stability of our clients business. Database Consulting was founded as an Oracle Database specialised education centre with in-house developed trainings and workshops. We are an Oracle Approved Educational Centre since 2015. For our clients we also provide highly- specialised services coupled with tailor made consulting to meet our client’s

• needs. We have previously cooperated with Swiss, German and Polish: banks,

healthcare companies, insurance, re-insurance companies, retailers and government institutions. We can most assuredly say that Database Consulting offers a very core base of experienced experts who care about their clients throughout Europe, helping and assisting them to succeed through innovative technology.

Average experience per person: 13 years In total: 129 years of professional experience, 10 Oracle Experts All our consultants have over 10 years of experience Company founded in 2009

APEX SQL PL/SQL Database Tuning Big Data & Data Warehousing DBA Business Analyst & PM Forms Database Consulting

Oracle Experts

Database Consulting 2019

4

Outsourcing of IT processes to a company in a nearby country is called nearshoring. Our headquarter is less than 3 hours away with direct flights from English and German speaking countries in Europe.

THE SAME WORKING HOURS HIGHLY SKILLED EXPERTS THE SAME BUSINESS CULTURE SIMILAR LEGAL REGULATIONS SHORT, DIRECT FLIGHTS

Nearshoring

Outsourcing to a nearby country

Database Consulting 2019

5

Forms to APEX migration

Migrate your outdated system to modern, low-code, beautiful, solution with responsive, accessible and mobile design

Reasons to migrate

• Reduces license costs by moving from paid Forms &

Reports to free Oracle Application Express

• Leaves outdated solutions that are hard to maintain and

costly to develop

• Uses the newest technologies and advanced Oracle APEX

components

• Integrate

your application with your

• ther

web applications or mobile solutions You stuck with

• utdated

technology? Maintenance is too expensive? Improvements take too much time?

ORACLE FORMS & REPORTS

No additional license costs Low-Code ease to maintain Web and mobile ready

ORACLE APEX FORMS TO APEX MIGRATION

Forms to APEX migration

Our experienced team in both APEX and Forms and is able to perform a complete migration of your current database solutions, written in Forms 6i, 9i or any newer version of Forms, to Oracle Application Express. APEX is the best replacement for Oracle Forms since it has a similar Rapid Application Development approach and is SQL & PL/SQL-centric.

How it works?

• We plan the entire migration for you
• We rewrite your current business processes from Forms to

Oracle APEX

• We map old Forms components to APEX equivalent when

it is possible

• We utilise the newest APEX capabilities to improve your

system and user experience

• We have extensive experience in Forms and APEX

Learn more at forms2apex.com

5

6

Complete and smooth Forms to APEX migration

Smoothness of the migration is almost so important as the entire transition process TESTING SMART DECISION ANALYSIS PLAN PREPARATION FORMS2APEX BRIDGE REDESIGN RECODING

Decisions about migration are crucial. Migration of complex database systems brings a lot of benefits but it is a demanding process that requires commitment and involves a lot of resources.

01 02

We start the transition from business and technical analysis to determine the scope of migration, business requirements, use cases as well as current technical solutions and future constraints. Based on an analysis step we prepare the plan of migration with well-defined milestones, estimation of required efforts and timelines. 04 Migration is a good moment to take a wide look at on system design and improve it or change when it is necessary. 06 This is very important step that is based on results from analysis. We automate testing as much as its possible to make the testing scope wider and deeper.

03

This optional step is to make the transition

• smoother. It is possible to

migrate application modules separately and connect them with the old part of the system while

• ther modules migration

is still in progress and in parallel.

05

During the recoding phase we try to reuse as many Oracle Forms code as it’s possible. To do that we use our tools to make development easier and faster.

07

Learn more at forms2apex.com

Database Consulting 2019

7

Forms to APEX bridge – a way to evolve from Forms to APEX

Integrate new APEX modules with old Forms system to make migration smoother

Migration is too big step to make it at once?

Oracle Forms & Reports Oracle APEX

Forms to APEX bridge

Keep old Forms application working and integrate it with new modules written in APEX. Forms to APEX bridge gives you the possibility to continue the usage of Forms where necessary and create new application modules in the modern APEX environment. It allows you to communicate between old Forms which are part of the system and new APEX modules. That keeps old code almost untouched and lets you to develop new parts of the system with all the fancy APEX features, Low-Code and RAD approach. Forms to APEX bridge can also be used as a temporarily solution to make the complete migration to APEX smoother. It is possible to migrate application modules separately and connect them with old parts of the system while other modules migration is still in progress and in parallel

Links between modules Exchange session state

U

Single sign-on Learn more at forms2apex.com

7

Database Consulting 2019

8

Web and mobile

Oracle APEX allow you to work with data on desktop computers and portable

• devices. It has responsive,

accessible, modern design and set of mobile components to make your application available for people anywhere. That means that your system can be used faster, better and without boundaries of your

• ffice space.

Oracle APEX Dedicated Applications

Customized software is key for success of your Business

APEX technology

Oracle APEX can be used to build a wide variety of apps for any industry. From the simplest app that turns a spreadsheet into a web app, creating a secure single source of information, to a mission critical app that is accessed daily by tens of thousands of users. Oracle APEX can also be used to build internal apps, for a few users, the department, or the whole organization, or to build public-facing apps for customers and partners.

Rapid Low-Code

Business processes in your Company need to be agile and flexible. That means that software changes and implementation of new requirements need to be really fast. APEX is unique in the market Rapid Application Development tool that allow you to create applications very fast, based

• n data you store in Oracle
• database. With Low-Code

approach it is faster to create solution that is easy to modify in future.

Customized software

Customized Software is key for your success. Every Business is different and requires limitless tools that allow you to input, process, interact and analyse your data in a way suitable for your needs. APEX allows you to utilize all advantages of Oracle, SQL and PL/SQL. Dozens of components and region types, analytic SQL, SQL, pattern matching, statistic functions and other tools allow you to interact and analyse your data as you wish.

Secure and Safe

Oracle APEX is Powered By

• Oracle. the most complete,

integrated, and secure database solution for any scale deployment. However APEX gives you much more than data integrity and security – business stability. APEX is a mature solution with over 18 years of development and clear statement of direction what makes its usage very secure for your business.

System Integration

Oracle APEX and Oracle Database have multiple

• ptions for integration with
• ther systems or data

sources . With external tables, SQL Loader, Data Pump, REST, WebService

• support. BigData SQL,

Oracle Gateway and other techniques it is perfect choice for customized database applications used for data collection, processing.

M

9

Oracle APEX Dedicated Applications

Customized software development key-points

PLANNING & ANALYSIS

To understand business needs and define technical boundaries our Consultants cooperate closely with your End Business Users.

KNOW-HOW TRANSFER & CUSTOMER SUPPORT

After successful deployment of new, customized APEX software we offer you technical and business support with the possibility to extend or upgrade. Our Oracle Trainers can prepare customized Workshops both in business and technical fields.

SOFTWARE DEPLOYMENT

As a part of APEX Application Development Process our Senior Oracle Developers assist you during new Software Deployment stage.

SOFTWARE DEVELOPMENT

Our Team of Senior Oracle APEX Developers implements APEX application according to technical specification. To ensure high code quality our Developers follow the best programming practices.

APEX SOLUTION DESIGN

Our Software Architects prepare a project

• f solution to fulfil strictly defined

requirements and to integrate new system with your existing infrastructure.

TESTS & PERFORMANCE OPTIMIZATION

To improve Software quality and eliminate bugs we prepare and execute functional and performance tests on QA environment. Performance optimization is performed when needed.

Planning & Analysis APEX Solution Design

.

Software Development Tests & Performance Optimization Software Deployment Know-how transfer & Customer Support

APEX Application

y

Database Consulting 2019

10

APEX Office Plugins

Generate MS Word and MS Excel documents directly from APEX

APEX OFFICE PLUGINS

APEX DOCX Plugin

Our DOCX APEX Plugin allows you to generate text oriented reports that are readable by MS Office. Templates are stored in DOCX files so they can be customized in MS Word - tool known to everyone. You can use SQL query results and generate fine customized documents directly from Oracle APEX. This is perfect solution for Developers who want easily configurable tool, available in APEX without any server setup needed.

APEX XLSX Plugin

Our XLSX Plugin to Oracle APEX allows you to easily generate Excel files based

• n data returned by SQL query and XLSX template files without any additional

tool or server component This unique solution in the market gives you the possibility to edit template files using an Excel application (e.g. to apply formatting) and provide a query that fills this template during runtime XLSX generation. Query can have bind variables (parameters) that allow you to reference APEX session variables

Generate Office files directly from APEX Setup without shell

• r SYS access

Excel or Word customisable templates Installable by Developer from App Builder Standalone solution

11

ORACLE APEX Mobile applications

Make your APEX application mobile with Database Consulting

IMAGE

Allow your business users to work effectively with mobile access to your critical business data and business activities.

TOP PERFORMANCE AND EFFICIENCY ACCESSIBLE AND SECURED

We utilise beautiful, powerful, responsive capabilities of built in APEX mobile components designed for small screen devices extended with mobile plugins when necessary.

POWERFUL FRONTEND DESIGN

Mobile devices usage and hardware access brings new possibilities to your system. Whenever your APEX app processes pictures or geographical data

• r you just simply need to have instant input –

mobile APEX application to make data collection easier.

INTELLIGENT FEATURES

The same security capabilities as for regular Oracle Database and APEX applications with LDAP and Single Sign-On possibilities what keeps your data accessible and secured.

11

We can make your APEX application available also on mobile devices (tablets and smartphones) what make your data and business processes available to your End Users from everywhere APEX mobile app will be fully integrated with your current business solution and standard workflow, secured in the same way as your database and regular APEX application We go beyond web-browser sandbox. Your APEX application can be installable mobile application that has access to phone hardware (GPS, camera or accelerometer), local filesystem, calls and SMS capability

Database Consulting 2019

12

ORACLE APEX 18c IN THE CLOUD

Run new APEX instances in less than 10 minutes. With Cloud usage you can avoid installation and configuration of Oracle Database and APEX software stack but rather focus on its usage for your business needs. Whenever you want just to try the newest APEX for only one hour or you need hundreds of APEX instances for months – yes you can! An Amazon Machine Image (AMI) is an easy way to run your private, dedicated APEX instances in the Amazon Cloud with total control. If you want to use scalability, security and flexibility of the Amazon Web Services – you can therefore use our pre-installed, pre-configured and highly secured virtual machine templates. It has all you need: OS, dedicated Oracle database instance, APEX and ORDS with Apache Tomcat. You can even

• rder

hundreds

• f

instances in more than 20 regions around the World (including Ireland, London, Frankfurt, Paris and Stockholm). Each APEX instance can be ready for you in less than 10 minutes.

80%

• f workloads will

move to the Cloud*

85%

• f Client interactions

will be automated*

70%

• f IT functions will

be fully automated*

400%

improvement in developer productivity* *After Oracle’s Top 10 Cloud Predictions 2019 (https://www.oracle.com/us/solutions/cloud/oracle-cloud-predictions-2019-5244106.pdf)

• World-wide locations available for APEX in the Cloud

Check our proposal for Amazon Cloud on http://datacons.co.uk/apex-cloud/

Database Consulting 2019

13

Oracle migration to the Cloud

Migrate your Database and applications to the Cloud

DATABASE MIGRATIONS APEX MIGRATIONS Migration of your data is a crucial process. We have extensive knowledge and experience to support you with that.

MIGRATE YOUR DATABASE TO THE CLOUD

You can use our pre-installed, pre-configured and highly secured virtual machine templates with OS, dedicated Oracle instances, APEX and ORDS.

DATABASE VM TEMPLATES

Cloud give you scalability, security and flexibility not available when running on-premises.

THE WORLDS SPINNING IN CLOUDS

Well configured APEX is much more than just a Database. We know all about APEX migration.

MIGRATE YOUR APEX APPs TO THE CLOUD

Depending on the scope of migration there are different techniques and tools available for

• migration. We can help you choose the correct one.

PROPER MIGRATION METHOD IMPROVE YOUR BUSINESS

ORACLE DATABASE AND APEX MIGRATION TO CLOUD SERVICES

Whenever you need Database or APEX for only one hour or you need to run hundreds of machines – the Cloud lets you do that.

Cloud Migration is a service created to support you in transformation on-premises environments to the Cloud. We support you in all the stages: most suitable choice of Cloud Vendor, through to the set-up and configuration up to the final data transfer. To make the process of transfer smoother we offer a preconfigured VMs ready to be run in the Cloud. We also can help you with all questions related to Oracle Database or APEX application migration.

80%

• f workloads will

move to the Cloud

70%

• f IT functions will

be fully automated* *After Oracle’s Top 10 Cloud Predictions 2019 (https://www.oracle.com/us/solutions/cloud/oracle-cloud-predictions-2019-5244106.pdf)

Database Consulting 2019

14

Oracle Forms & Reports maintenance and modernization

Many Oracle Forms systems still require care and support For many years Oracle Forms and Reports have been chosen as the best tools and used as a platform to build Oracle Database-centric applications and systems crucial for most of the Companies with Oracle. Many of these systems are dozens of years old and at the moment of its creation Forms & Reports were the only reasonable solution. Even now ease of database application creation, given by these tools, is not so common. Years later many of these core systems are still up and running. They are often irreplaceable and essential for the most important business processes. We built these kind of systems in the past and we have many years of experience in Oracle Forms and Reports. Currently we

• ffer support and care for our Customers using Forms & Reports

technology.

Oracle Forms and Reports system in-house? UNIQUE KNOW-HOW FORMS MAINTENANCE & DEVELOPMENT FORMS OPTIMIZATION & INTEGRATION FORMS UPGRADES & MIGRATIONS

Y

We offer you our unique knowledge and many years of experience in Oracle Forms and Reports development We can take care about your system and support you with maintenance

• r development of new functionalities in Forms and Reports

We upgrade and migrate all previous version of Forms to Forms 12c with possible redesign of UI We can improve and optimize your Forms & Reports application or integrate it with other systems in your Company

Database Consulting 2019

15

15

How we can help you?

Performance Tuning

We have Consultants expertise in Performance Tuning with broad knowledge in SQL Query and Instance Tuning.

Consulting Services

Our approach is to help you with assessments, audits and advisory services.

Data Analyses

We can support you with data analysis techniques and help you accurately assure data quality.

Solution Architecture and Design

We can design, develop and implement Data Warehouse for your Organisation.

Data Model and ETL Design

Our Consultants can help you design ETL processes and create data models.

Existing DWH Projects

We can improve existing DWH projects. Data warehousing is a set of techniques and mechanisms for collecting and managing business data gathered from different sources. It is designed for data analysis allows business users to better understand their organization business performance and support decision-making activities.

Data Warehousing

Improve organization business performance

Data Warehousing

Database Consulting 2019

16

Access BIG DATA from within Data Warehouse

CONNECT DWH TO BIG DATA ECOSYSTEM

Explore the potential of the Oracle DB working with Big Data

BIG DATA ANALYTIC IN DATA WAREHOUSE

Enable users to explore Big Data using their favourite tools

INTEGRATE EXISTING DATA WAREHOUSE WITH BIG DATA

Enable Oracle DB security for Big Data processing

PROVIDE SECURE ACCESS TO BIG DATA

Currently more and more data is generated by businesses and being collected. Integration with Big Data allows you to bring all of the different types of data in to one place and answer completely new business questions. We can integrate your big data with existing applications and reports based on Data Warehousing environment with reliable Oracle authorization mechanism. We can help you collect data, clean it, prepare it and transform to make it available in a existing it solutions.

Connecting to Big Data

Source your Data Warehousing

Database Consulting 2019

17

Cooperation models

QA MEMBERS TEAM LEADS DEVELOPERS BUSINESS ANALYSTS PROJECT MANAGERS BUSINESS USERS ARCHITECTS/DESIGNERS TESTERS QA MEMBERS TEAM LEADS DEVELOPERS BUSINESS ANALYSTS PROJECT MANAGERS BUSINESS USERS ARCHITECTS/DESIGNERS TESTERS QA MEMBERS TEAM LEADS DEVELOPERS BUSINESS ANALYSTS PROJECT MANAGERS BUSINESS USERS ARCHITECTS/DESIGNERS TESTERS

MANAGED SERVICE

Supplier handles the complete software development process. On the Client’s side it remains in defining business needs and software acceptance

DEVELOPER TIME-ORIENTED

Client buys work time of developer and uses his expert knowledge. This cooperation model is recommended when expert an developer is required to complete client’s developer team.

TASK-ORIENTED

In this model many development tasks are handled by the Supplier. On the Client’s side there remains business analyses, providing business requirements and high level project management

We propose different cooperation models (or mixture of them)

Database Consulting 2019

18

Managed Service

Let us implement your business needs Managed Services cooperation model is great alternative for Clients who just wants to focus on their business. In this model supplier provides, organize, and manage work

• f business analytics and developers. This solution is convenient way for Client to avoid building huge technical team. Business users can just focus on business

requirements and the final product acceptance. Simple as that.

QA MEMBERS TEAM LEADS ARCHITECTS/DESIGNERS BUSINESS ANALYSTS PROJECT MANAGERS BUSINESS USERS DEVELOPERS TESTERS Do you need an IT system to meet your business needs?

Let us take care of it. We will handle the whole development cycle. All you need is to have a business needs.

Database Consulting 2019

19

Contact us

Learn more Head Office:

• al. Jana Pawla II 11

00-828 Warszawa Poland

Visit us:

Legal Office: Unit 4, Enterprise Court, Farfield Park Rotherham, S63 5DB, England

• ffice@datacons.co.uk

https://www.facebook.com/databaseconsulting/ https://twitter.com/DataCons_PL www.datacons.co.uk +44 114 360 3050 +48 22 398 47 81

ORACLE APEX APEX Cloud & Hosting APEX and Forms Development Forms to APEX datacons.co.uk/apex ORACLE CONSULTING Oracle Managed Services datacons.co.uk/consulting Oracle Outsourcing Oracle Consulting ORACLE SERVICES Oracle Tuning Data Warehousing & Big Data Oracle To Cloud Migrations datacons.co.uk/services