using postgres to slash erp costs

30
1 1 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice. LN-6001 The Infor Open Source Equation Slashing Infor LN’s TCO with Postgres Marc Linster - EDB, Senior Vice President, Products and Services

Upload: enterprisedb

Post on 29-Nov-2014

143 views

Category:

Software


0 download

DESCRIPTION

Infor partnered with EnterpriseDB and Red Hat to create the next-general of Infor LN, a highly performant, cost-effective ERP solution that enables customers to deploy on-premise or in the cloud and more quickly adapt to changing business requirements. Infor LN is now available on an open source based technology stack. EnterpriseDB contributes its Postgres Plus Advanced Server database. EnterpriseDB extends the open source PostgreSQL, the world’s fourth-most popular database, with a series of enterprise-class enhancements to meet the performance, security and manageability demands of mission critical business workloads. Learn more about Postgres Plus and how it came to be the only open source based database capable of powering a full-featured ERP solution.

TRANSCRIPT

Page 1: Using Postgres to Slash ERP Costs

1 1 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

LN-6001 The Infor Open Source Equation Slashing Infor LN’s TCO with Postgres Marc Linster - EDB, Senior Vice President, Products and Services

Page 2: Using Postgres to Slash ERP Costs

2 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Agenda •  What is Infor LN Open Source Solution? •  Why Open Source? •  What is value of Open Source for you? •  Who are Infor Partners on Open Source? •  What is Future of Infor Open Source?

Page 3: Using Postgres to Slash ERP Costs

3 3 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

What is Infor LN Open Source?

Page 4: Using Postgres to Slash ERP Costs

4 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Infor Open Source Solution

ERP LN Business Application

Postgres Plus Database

Red Hat Enterprise Linux OS

Page 5: Using Postgres to Slash ERP Costs

5 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Infor, EnterpriseDB & Red Hat Collaboration •  9+ months engineering testing & performance tuning •  Shared resources & infrastructure (benchmarking, etc.) •  Iterative improvement and testing cycles •  On-site collaboration & cross-training •  Integrated sales & marketing planning in parallel with technical work •  Synergistic channel & go-to-market activities

Page 6: Using Postgres to Slash ERP Costs

6 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Infor LN Open Source Stack Presentation Tier • Red Hat JBoss • Apache Tomcat

Application Tier • LN VM + LN DB Driver Database Tier • Open Client Library (EnterpriseDB) • Postgres Plus Advanced Server (EnterpriseDB)

Operating System Tier • Red Hat Enterprise Linux

Virtualization / Cloud Management • Red Hat Enterprise Virtualization

EDB Postgres Plus Advanced Server

LN UI

LN VM + DB Driver

HARDWARE

Red Hat Enterprise Virtualization [ KVM-based]

Red Hat Enterprise Linux

LN / Infor Ming.le

EDB Database Compatibility Layer

Page 7: Using Postgres to Slash ERP Costs

7 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

LN Migration •  LN platform considerations:

•  LN requires Oracle-like error handling within multi-statement transactions

•  PostgreSQL Community Edition does not support this capability – EDB Postgres Plus Advanced Server does!

•  OCL (Open Client Library) layer adjustments: •  SELECT with row buffering (server side cursors versus client-side cursors)

•  Reuse of declared cursors

•  Unexpected OCL call sequences (legal in legacy DB, but not expected)

•  Oracle-compatible CLOB/BLOB support

•  Total of approximately 12 OCL layer changes needed

•  Core Server changes •  Unicode-compatible collation

Page 8: Using Postgres to Slash ERP Costs

8 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

LN Migration •  Challenges & Adjustments:

•  Some configuration changes on the LN side were necessary such as connect parameters, different varchar datatype null-value semantics, different way of creating users and roles, different way to handle lock timeouts

•  EDB’s proprietary distribution allowed modifications in the libpq (Postgres C Interface) to address LN performance requirements

Page 9: Using Postgres to Slash ERP Costs

9 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Performance Testing

EnterpriseDB – 87.4 transactions/user,

15 minutes

Proprietary DB – 88 transactions/user,

15 minutes

Normalized Transaction Times for 250 Concurrent User Benchmark – 90th percentile

(smaller is better)

0%

20%

40%

60%

80%

100%

120%

EnterpriseDB

Proprietary  RDBMS

Limit

Page 10: Using Postgres to Slash ERP Costs

10 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

LN Migration •  Current status:

•  Ongoing collaboration between Infor Labs and EnterpriseDB

•  Successfully evaluating increasing workload levels

•  Collaborative development of complete solution, including solution certification, go to market approach, and customer evaluation

Page 11: Using Postgres to Slash ERP Costs

11 11 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Why Open Source?

Page 12: Using Postgres to Slash ERP Costs

12 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Business •  Increasing organizational, product

and process complexity •  Accelerating rate of change •  Faster innovation cycles

Addresses Key Customer Challenges IT

•  Legacy applications and heavy customizations

•  Move resources from “lights on” to innovation

IT must become an enabler, rather than inhibitor of business process change and innovation

Page 13: Using Postgres to Slash ERP Costs

13 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Trends Driving Open Source

Big Data Cloud Innovations

Economics TCO

Offer a Choice

Proprietary technology Costs prohibitive

Fast paced innovations In open community

Safe $ Improve margins

Demand is increasing No lock in

Page 14: Using Postgres to Slash ERP Costs

14 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Infor Open Source Strategy

We can deliver a better experience with open source because it allows us to configure a seamless experience with our applications with fewer licensing and distribution

restrictions. We can easily move images between on premise and cloud as customer needs dictate.

- Charles Philips, CEO, Infor

Page 15: Using Postgres to Slash ERP Costs

15 15 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

What is value of Open Source for you?

Page 16: Using Postgres to Slash ERP Costs

16 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Cost Savings: Single Server TCO Comparison

0

50

100

150

200

250

300

350

400

Open  Source Proprietary

Thou

sand

s

3-­‐Year  TCO  Comparison

OpEx

CapEx

0

50

100

150

200

250

300

350

400

450

500

Open  Source Proprietary

Thou

sand

s

5-­‐Year  TCO  Comparison

OpEx

CapEx

Open source stack TCO is up to 80% less than proprietary stack!

Page 17: Using Postgres to Slash ERP Costs

17 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

•  Proprietary DB •  Postgres Plus Enterprise Edition for

customers wanting to lower TCO

•  Microsoft à Open Source stack TCO savings, both •  SQL Server à Postgres Plus •  Windows à RHEL

LN Customer Opportunities •  BaaN4 à LN upgrade

•  Benefits of LN, plus database TCO •  Cost savings with Postgres Plus

(BaaN4 does not support; LN does)

•  System p (AIX) à RHEL/x86 •  Plus TCO savings switching from

DB2 à Postgres Plus

Page 18: Using Postgres to Slash ERP Costs

18 18 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Who is EnterpriseDB?

Page 19: Using Postgres to Slash ERP Costs

19 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

EnterpriseDB •  Founded in 2004

•  170+ employees •  2,500+ customers

•  Market focus: •  Global enterprise •  Governments

•  North America, Europe & Asia •  Strategic partnerships:

•  Amazon Web Services •  Red Hat •  IBM •  HP

•  60%+ YOY growth in 2012 & 2013

Page 20: Using Postgres to Slash ERP Costs

20

EDB currently has over 2,500 total customers including 50 of the Fortune 500 and 98 of the Forbes Global 2000

Page 21: Using Postgres to Slash ERP Costs

21 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Key Strategic Partners

Only multi-platform DBMS partner; 2013 AllianceOne Partner of the Year

LEAD OSS DBMS for Power Linux (EDB Investor)

Global sales & technology partner (EDB Investor)

Page 22: Using Postgres to Slash ERP Costs

22 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Gartner: EDB is Only RDBMS Challenger to Expensive Proprietary Databases

Gartner Comments • “Postgres is growing rapidly, due to EnterpriseDB

• “We continue to see an increase in usage in mission-critical applications, especially given the added functionality and stability of new releases of Postgres Plus Advanced Server from EnterpriseDB

• “In addition, EnterpriseDB has easy to install versions of PostgreSQL, along with tools to manage installation and the environment.” Gartner Magic Quadrant for Operational DBMS

CHALLENGERS LEADERS

NICHE PLAYERS VISIONARIES

Page 23: Using Postgres to Slash ERP Costs

23 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Postgres: World’s 4th most implemented database

Page 24: Using Postgres to Slash ERP Costs

24 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Postgres Plus Advanced Server World’s most advanced open source based database Oracle Compatibility

• Faster, easier migrations • PL/SQL, OCI support • Oracle SQL extensions • User defined objects • Function packages • Database links • Oracle-like tools:

EDB*Loader, EDB*Plus, EDB*Wrap

Bundled Tools • Oracle, SQL Server &

PostgreSQL to Postgres Plus replication

• Enterprise management, monitoring, and tuning

• Oracle, SQL Server & MySQL to Postgres Plus Migration Tools

Security • Fine Grained Audit Logging • Row Level Security (VPD) • SQL Injection attack guard • Server-side code protection • EAL2 certification

Performance • Faster Partitioning

- 400x faster writes - 76x faster selects

• SQL Profiler – fix slow workloads

• Bulk Data Loader •  Index Advisor - speeds up

inquiries • Query Hints - optimizer control • DynaTune - memory upgrades • Bulk Collect/Fetch/Binding of

arrays • Dynamic runtime statistics

reveals SQL wait bottlenecks

Page 25: Using Postgres to Slash ERP Costs

25

•  Run applications written for Oracle virtually unchanged •  No need to retrain Oracle DBAs and developers •  Support for PL/SQL language and OCI interoperability •  Replication for easy sharing of data

25

Database Compatibility for Oracle®

No disruption to your ongoing operations!

Compatible with:

Oracle Developers

Oracle Applications

Everything works on PPAS!

Your business Your apps Your people

Page 26: Using Postgres to Slash ERP Costs

26 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

What is the future of Infor Open Source?

Page 27: Using Postgres to Slash ERP Costs

27 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Infor LN Open Source Stack Presentation Tier • Web Server • Red Hat JBoss • Apache Tomcat

Application Tier • LN VM + LN DB Driver • Red Hat Enterprise Linux Database Tier • Postgres Plus Cloud Database (EnterpriseDB)

Virtualization / Cloud Management • Red Hat Enterprise Virtualization

• Red Hat CloudForms

Page 28: Using Postgres to Slash ERP Costs

28 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Expand Across Infor Portfolio •  OS … virtualization … middleware •  More Infor product lines

Future Infor Opportunities Deeper Tech Adoption: Cloud, Big Data •  Private … public … hybrid … SaaS •  CloudForms, CloudDB, …

Infor HCM

Infor Analytics Infor HMS Infor

Lawson

Infor EAM

Infor LN

Infor SX.e

Page 29: Using Postgres to Slash ERP Costs

29 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Infor Open Source Summary •  Total cost reduction •  Comparable performance •  Increased agility •  Upgrade to latest LN version for a fraction of the cost •  Migration assessments & assistance available

Page 30: Using Postgres to Slash ERP Costs

30 Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.

Thank You! Any Questions?