EnterpriseDB

EDB Postgres Developer - Standard (uniCores)

A non-production option for EDB Postgres Standard. PostgreSQL may be used without restrictions. EDB tools are for developing applications, testing them, proof of concepts, sandbox work, staging and other types of work in non-production environments. This product equals EDB Postgres Standard but comes with less stringent support Service Level Agreements.

Features

  • Multi-model support: relational, JSON, Key-Value, Geospatial, Full Text, XML, more.
  • Full ACID Compliance and strong conformance to ANSI-SQL:2011 standard.
  • Server Procedural Languages: Python, Javascript, Java, C, C++, Perl, more.
  • Security: SCRAM-SHA-256, LDAP, SSL, SSPI, GSSAPI, RADIUS, Roles, Row Level.
  • SQL Aggregates with CUBE, ROLLUP and GROUPING SETS.
  • Binary and logical replication with read-only standby databases.
  • External integrations: PostgreSQL, Oracle, SQL Server, MongoDB, MySQL, Hadoop.
  • Monitoring, Management, Tuning, High Availability, Disaster Recovery, Replication, Migration tools.
  • DBaaS, PaaS and DevOps integration.
  • Deploy bare metal, virtual, containers, public, private and hybrid cloud.

Benefits

  • Multi-model data reduces need for niche databases simplifying data architecture.
  • Standards compliant, robust relational foundation for long lasting application portability.
  • Faster development using one language from database to application layer.
  • Easy database integration into modern and popular security architectures.
  • Perform basic analytics at much lower costs.
  • Fast and flexible replication makes data more available and useful.
  • Integration of legacy and digital applications provides holistic data insights.
  • Single source: database, tools, support, consulting, training, and Postgres expertise.
  • Automated self-service provisioning with operational control and customization plus API.
  • Deployment model flexibility and choice of cloud vendors.

Pricing

£553 to £790 per unit per year

Service documents

Framework

G-Cloud 11

Service ID

7 8 9 2 1 1 9 6 1 8 3 6 0 8 0

Contact

EnterpriseDB

Matthew Peachey

44-7801-383565

matt.peachey@enterprisedb.com

Service scope

Software add-on or extension
No
Cloud deployment model
  • Public cloud
  • Private cloud
  • Hybrid cloud
Service constraints
None, Control and configuration is by the customer/their Cloud supplier of choice
System requirements
  • Red Hat Enterprise Linux or CentOS
  • Windows
  • Linux on IBM Power8 Little Endian (LE)
  • Amazon EC2
  • Google Cloud Platform
  • Red Hat OpenShift
  • Pivotal Cloud Foundry

User support

Email or online ticketing support
Email or online ticketing
Support response times
10x5x365 with a 48 hour response time
User can manage status and priority of support tickets
Yes
Online ticketing support accessibility
None or don’t know
Phone support
Yes
Phone support availability
9 to 5 (UK time), Monday to Friday
Web chat support
No
Onsite support
Yes, at extra cost
Support levels
Non-production level support is available on a 10x5x365 basis with a targeted initial response of 48 hours.
All production level support is available on a 24x7x365 basis with a targeted initial response of 30 minutes.
Support available to third parties
Yes

Onboarding and offboarding

Getting started
Two full-length introductory training courses are available online free at: https://www.enterprisedb.com/free-postgres-training . A variety of solution architecture services are available to help organizations plan and execute best practice development, testing and production deployment environments. Additional on site and web based remote training is available at extra cost as are training e-subscriptions and professional certifications.
Service documentation
Yes
Documentation formats
  • HTML
  • PDF
End-of-contract data extraction
The EDB Postgres solution sits within the buyers infrastructure of choice They have their own license for the use of the deployed software and control the ownership and management of the data contained within. Data can be extracted in a wide variety of formats including: Postgres, Oracle, SQL Server, MongoDB, MySQL, Hadoop, CSV and user defined custom formats. This will allow the buyer to port their data to alternative program venues as needed. A variety of extract techniques include: native database dump/restore, native replication to a new database, heterogeneous replication to another database and export by a large number of 3rd party tools.
End-of-contract process
The buyer controls the management of the software and is in complete control of the processes should they decide not to renew licences at the end of the contract. Data needs to be extracted prior to contract ending. EDB can provide professional services at extra cost to help with the transition between solutions. These services are outlined in the attached service description document and are listed under the Cloud Services category.

Using the service

Web browser interface
Yes
Supported browsers
  • Internet Explorer 11
  • Microsoft Edge
  • Firefox
  • Chrome
  • Safari 9+
  • Opera
Application to install
Yes
Compatible operating systems
  • Linux or Unix
  • MacOS
  • Windows
Designed for use on mobile devices
Yes
Differences between the mobile and desktop service
Users can access the software management through mobile browsers. However given screen size restrictions this is not recommended.
Service interface
No
API
Yes
What users can and can't do using the API
Application programmers' client programs of all types may access the database service using any of the following supported language APIs: libpq, JDBC, ODBC, C, C++, Perl, Python, Ruby, Scheme, PHP, .Net, lisp, and Qt. A customizable database template system and self-service provisioning capability is also accessible via the EDB Postgres Ark cloud API.
API documentation
Yes
API documentation formats
  • HTML
  • PDF
API sandbox or test environment
Yes
Customisation available
Yes
Description of customisation
EDB Postgres Enterprise is built around EDB Postgres Advanced Server - enhanced version of PostgresSQL that adds additional security, performance tools, Developer tools, DBA tools and Oracle compatibility. The database and tools is designed to be deployed in any cloud infrastructure of choice. The database can be customised to address all varieties of applications including transaction oriented, read mostly/only, mixed or specialized for document or key-value processing.

A wide variety of extensions can be added to the database to give it additional capabilities such as best in class geo-spatial processing, logical replication, backup and restore capabilities and more. The database includes a replication tool that can exchange data with other Postgres, Oracle, and SQL Server databases. Additional data adapters connect to MongoDB, MySQL and Hadoop data allowing for custom integrations of data throughout the enterprise for 360 degree views of key data sets.

Scaling

Independence of resources
The EDB Postgres solution sits within the buyers cloud infrastructure of choice. All cloud instances for EDB solutions are private instances and respect the isolation and processing independence such instances are afforded by the cloud infrastructure provider. EDB Postgres instances are not shared with other users outside of those authorized by the buyer.

Analytics

Service usage metrics
No

Resellers

Supplier type
Not a reseller

Staff security

Staff security clearance
Conforms to BS7858:2012
Government security clearance
Up to Developed Vetting (DV)

Asset protection

Knowledge of data storage and processing locations
Yes
Data storage and processing locations
United Kingdom
User control over data storage and processing locations
Yes
Datacentre security standards
Managed by a third party
Penetration testing frequency
Never
Protecting data at rest
  • Physical access control, complying with another standard
  • Encryption of all physical media
  • Scale, obfuscating techniques, or data storage sharding
  • Other
Other data at rest protection approach
The EDB Postgres solution sits within the buyers infrastructure of choice. They or their cloud supplier of choice have complete control of their data and its security including the encryption of data on disk or encrypting selected columns of data in the database.
Data sanitisation process
Yes
Data sanitisation type
Deleted data can’t be directly accessed
Equipment disposal approach
A third-party destruction service

Data importing and exporting

Data export approach
The EDB Postgres solution sits within the buyers infrastructure of choice They have their own licence for the use of the deployed software and control the management of the data contained within. Data can be extracted in a wide variety of formats including: Postgres, Oracle, SQL Server, MongoDB, MySQL, Hadoop, CSV and user defined custom formats. This will allow the buyer to port their data to an alternative solution should this be necessary.
Data export formats
Other
Other data export formats
SQL
Data import formats
Other
Other data import formats
  • SQL
  • Import directly into database using the EDB Migration Portal

Data-in-transit protection

Data protection between buyer and supplier networks
Other
Other protection between networks
The buyer controls the connectivity of the solution and there is no requirement for connection to EDB as the supplier. Buyers can deploy the database to their private/public cloud of choice and connect to it using existing security protocols for their applications.
Data protection within supplier network
Other
Other protection within supplier network
Not applicable. EDB as a supplier does not provide the connectivity to the buyer's public or private cloud of choice to deploy the database.

Availability and resilience

Guaranteed availability
The EDB Postgres solution sits within the buyers infrastructure of choice. Availability is controlled by their own network resilience software configuration as well as by the Service Level Agreements of their cloud provider of choice.
Approach to resilience
The EDB Postgres solution sits within the buyers infrastructure of choice. Resilience is controlled by their own network resilience and software configuration as well as by the resilience of the infrastructure of their cloud provider of choice. Database resilience is enhanced with clustered implementations using EDB Postgres tools.
Outage reporting
In addition to any infrastructure outage reporting by the cloud provider, the EDB Postgres Enterprise Manager (PEM) is included and may be deployed by the buyer in the cloud infrastructure of their choice. PEM provides over 100 ready to run monitoring probes that can utilize SMTP or SNMP to alert operations staff of out of bounds conditions. PEM has a sophisticated graphical user interface with pre-defined and customizable at-a-glance dashboards to monitor large scale Postgres installations.

Identity and authentication

User authentication needed
Yes
User authentication
  • 2-factor authentication
  • Public key authentication (including by TLS client certificate)
  • Identity federation with existing provider (for example Google Apps)
  • Dedicated link (for example VPN)
  • Username or password
  • Other
Other user authentication
Database access can be secured via a variety of authentication schemes including: SCRAM-SHA, LDAP, SSL, SSPI, GSSAPI, RADIUS and other schemes.
Access restrictions in management interfaces and support channels
Not applicable. The EDB Postgres solution sits within the buyers infrastructure of choice. They have their own licence for the use of the deployed software and therefore access management and support channels are managed internally or by their cloud provider of choice.
Access restriction testing frequency
At least once a year
Management access authentication
  • 2-factor authentication
  • Public key authentication (including by TLS client certificate)
  • Identity federation with existing provider (for example Google Apps)
  • Dedicated link (for example VPN)
  • Username or password

Audit information for users

Access to user activity audit information
Users have access to real-time audit information
How long user audit data is stored for
User-defined
Access to supplier activity audit information
No audit information available
How long system logs are stored for
User-defined

Standards and certifications

ISO/IEC 27001 certification
No
ISO 28000:2007 certification
No
CSA STAR certification
No
PCI certification
No
Other security certifications
No

Security governance

Named board-level person responsible for service security
Yes
Security governance certified
No
Security governance approach
Security is governed by the cloud service provider and/or the customer's internal network.
Information security policies and processes
EDB does not maintain the buyers data. Primary security policy and process is the responsibility of the buyers network or the chosen cloud provider supplemented by a wide variety of security measures available inside the database including roles, row level security, view security barriers, SQL injection protection, SQL GRANT/REVOKE, and Column Level Permissions.

Operational security

Configuration and change management standard
Supplier-defined controls
Configuration and change management approach
The buyer deploys the EDB solution in their network of choice. Therefore the issues of configuration and change management for the database software are their responsibility or the responsibility of their chosen cloud provider.
Vulnerability management type
Supplier-defined controls
Vulnerability management approach
The software is deployed in the buyers network or on the infrastructure of their chosen cloud provider. Vulnerability management is the responsibility of the buyer and/or their cloud provider. For the database, EDB maintains a watch on the marketplace and the PostgreSQL user community for emerging vulnerabilities using the CVE standard and will issue patches for customers to apply as needed. Additional tools inside the database are also available for added security such as roles, row level security, view security barriers, SQL injection protection, SQL GRANT/REVOKE, and Column Level Permissions.
Protective monitoring type
Supplier-defined controls
Protective monitoring approach
This EDB software offering is to be deployed in the buyer's network or their cloud provider of choice. Protective monitoring will be carried out by their relevant NOC/SOC activities, and optionally supplemented with EDB's management and monitoring software.
Incident management type
Supplier-defined controls
Incident management approach
This EDB software offering is to be deployed in the buyer's network or their cloud provider of choice. Incident Management activities will be carried out by their relevant NOC/SOC activities, and optionally supplemented with EDB's management and monitoring software.

Secure development

Approach to secure software development best practice
Supplier-defined process

Public sector networks

Connection to public sector networks
No

Pricing

Price
£553 to £790 per unit per year
Discount for educational organisations
Yes
Free trial available
Yes
Description of free trial
PostgreSQL is free to trial and use. The EDB Limited Use License allows 60 day evaluation of EDB Postgres management, monitoring, tuning, high availability, disaster recovery, replication and migration tools in non-production environments. Please see supporting service description documentation and link below to terms and conditions of Limited Use Licence.
Link to free trial
https://www.enterprisedb.com/enterprisedb-software-downloads

Service documents

Return to top ↑