A Quick look at Delphix Cross Platform Provisioning

Why Cross Platform Provisioning (XPP)

As a consultant I am fortunate to get the opportunity to work and speak with many customers across the whole of EMEA, a topic which is often discussed is the use of the Linux or the ‘Cloud’ for Development and Test teams. I will cover how you can migrate data to the Cloud in a future Blog post, but today I want to get you ready for the Cloud.

The migration of databases to Linux on commodity hardware on-premise or in the Cloud continues to grown year-on-year as IT departments look to reduce their infrastructure and operational costs and also provide greater Agility to the Business. However Unix is far from dead and not everyone is looking to migrate their Production systems to Linux quite yet. This a great example of where Delphix XPP can be used to provide Virtual Development and Test databases on Linux whilst retaining Production on Unix.

Validate Source

If you have a Unix dSource or VDB you may have noticed the ‘Transform to Linux’ option on your dashboard, this Service-lead feature provides an automated approach to the traditional labour intensive challenge of performing Endianness conversion, e.g. Unix (Big Endian) to Linux (Little Endian).

During the validation Delphix will spin-up a temporary VDB, therefore before you start you need to ensure that your Unix staging server has had the ‘Use as Staging’ enabled from within the Server Environment.

Validate dSource

To get started Open up the dSource or VDB card, and click on the ‘Linux’ tab, from here click on the Green Tick to validate the ‘Linux Transformation’. Delphix will then perform a series of checks against known Oracle restrictions including:

  • No encryption – Columns / Tablespaces
  • Locally managed tablespaces (not dictionary managed)
  • Tablespaces are self-contained
  • Restrictions surrounding XML Types, Spatial Indexes and Advanced Queries

Transform to Linux

 

If the Validation process fails, use the download the ‘Transformation’ text file to assist in identification and correction of the errors reports. Perform required updates and recommended changes to the Transformation script and Upload and repeat Validation step until successful validation.

Successful Validation

Now that you have Validated dSource / VDB the previously greyed out ‘Transform to Linux’ will be available allowing the Provision of Linux VDB’s

Validated dSource

Click on ‘Transform to Linux’ and follow the Delphix Provisioning wizard providing Database name and Mount Point as normal.

Provision Linux VDB

Advertisements

Delphix and DB2 ‘Air Gapped’

Delphix v5.0

Delphix v5.0 introduced many new feature including Secure Replication, SDD (Selective Data Distribution) and Oracle E-Business Suite Multi-Node, but in this Blog I am going to give the new DB2 functionality a test drive.

Delphix and DB2

The Delphix DB2 solution uses DB2 High Availability Disaster Recovery (HADR) capability to synchronise data from a Production DB2 database into a Delphix managed DB2 ‘Standby’ server. Delphix is able to automatically ingest data and keep the standby server in sync with only a minimal impact on the Production system. DB2 HADR is configured to be Super-Asynchronous (SUPERASYNC) so that log writes are considered successfully transmitted when the log records are sent from the primary database and therefore does not cause any Production delay.

DB2 HADR Standby
DB2 HADR Standby

 

 

 

 

 

 

 

 

 

 

 

Delphix strongly recommends the use of DB2 a High Availability Disaster Recovery (HADR) Standby as this provides an far superior RPO (Recovery Point Objective) and provides Delphix a fully automated sync with Production.

Getting Started

Being an Oracle guy with little DB2 experience I thought I was the perfect person to see how easy it is to get going with Delphix and DB2. After checking out the Delphix DB2 Docs, Rahul Nair’s excellent YouTube DB2 video I felt pretty confident to use Delphix and DB2.

DB2 Air Gapped

Whilst working with an existing Delphix customer and providing an update on the exciting support of DB2 within Delphix v5.0 I was given an edge case challenge.

The customer shared that they were unable to implement HADR and we needed to treat Production as ‘Air Gapped’, they were able to take backups and arrange for the transport of these but Delphix would not be able to interact with Production or a Standby server.

To demonstrate the process I performed the below on my Linux DB2 10.5.5 SAMPLE database.

Performed an On-Line backup using the following:

db2 connect to SAMPLE
db2 backup database SAMPLE online compress include logs

I then manually transferred the SAMPLE database backup file using scp with SHH Password less configuration.

Updated my Delphix Engine environment details, and then added a dSource using the Delphix UI.

Adding a DB2 dSource

As we are not planning to use HADR as this solution is ‘Air Gapped’ I have unchecked the HADR box.

I then clicked the ‘+’ to add the additional database information – Database Name and Backup Path

Adding DB2 dSource
Adding DB2 dSource

 

 

 

 

 

 

 

 

 

 

 

 

Click’ next and at the next screen provide a dSource name and click next again.

On the following screen specify the Staging server and Staging Mount Path

Adding Staging details
Adding Staging details

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

We can now ‘Click’ next and finally ‘Finish’ after reviewing the summary.

Delphix will now ingest the backup and create the initial dSource

Provisioning a Virtual Instance

To Provision a new Virtual Instance select either a dSource or existing virtual instance and click on the ‘+’ provision icon.

Select DB2 installation path and environment user, then click next.

Provide vFiles name and select folder, then click next until you get to the summary screen and click ‘Finish’

Provision DB2 Virtual Instance
Provision DB2 Virtual Instance

 

 

 

 

 

 

 

 

 

 

 

 

 

Performing Manual SnapShots

As we are not using HADR, we can’t use Delphix’s in-built policies to schedule and Snapshots so these need to be initiated manually.

This can be triggered via the Delphix CLI or automated using the Delphix SSH password less authentication.

e.g.
Grant access for the target user if not same as source user
db2 grant dbadm on database to user ${TARGETUSR}

Take a Full on-line backup
db2 backup database ${DATABASE} online compress include logs

Initiate backup file transfer
scp ${NEWBACKUP} ${STANDBYUSR}@${STANDBYSVR}:/home/${STANDBYUSR}/

Perform SnapShot
ssh delphix_admin${DELPHIX_ENGINE}”
${SSH_CMD} “version 1.7.0; cd database; select STANDBY; sync; set resync=true; commit; exit;”

Oracle EBS Cloning with Delphix 5.0

History of Delphix and Oracle

Oracle EBS non-Production environments often have complex topologies, usually with separate database and application tiers, often with multiple Application servers. The recent Delphix v5.0 releases addressed this challenging requirement with the introduction of support for multiple Application Servers ‘Multi-Node’.

I thought it was a good time to revisit how Delphix virtualises a complete Oracle EBS environment including dbTech stack, Database and AppsTier and also provide a brief overview of Delphix EBS capabilities per release.

Below is a diagram I frequently use to describe the Delphix EBS Architecture, step-by-step virtualisation details can be found at one of my previous posts Virtualising Oracle EBS R12.1 using Delphix

Delphix EBS Virtulisation

 

Delphix v4.0

Delphix v4.0 was the first release to provide full stack Oracle EBS R12.1.x cloning, R12.1 was selected as it remains one of the most widely EBS deployed versions even though it’s getting quite long in the tooth now as you can see from below.

Amazing to think R12.1 was GA (Generally Available) May 2009.

Oracle EBS Releases

Delphix v4.2

Delphix v4.2 was another important release extending support to include the terminal release of 11i (11.5.10.2) and R12.2.x and it’s use of the WebLogic Application Server.

The latest version of Oracle EBS R12.2.5 went GA Oct 2015, this is also fully supported by Delphix.

Delphix v4.3

Delphix v4.3 provided access to JetStream automation, with it’s Ordered Containers environment level management was now possible as you could specify the sequence of operations e.g.

1) dbTechStack
2) Database
3) AppsTier

Delphix v5.0

Delphix v5.0 now provides Out-of-the-Box support for multiple Application servers ‘Multi-Node’, this has previously been possible but required some development effort outside of Delphix.

You can now add additional Application servers to a Delphix Managed Oracle EBS environment from with the Delphix UI with a few extra clicks during initial provisioning or later on during configuration changes.

Configure as normal then click on the green ‘+’

Adding Additional Node

 

Provide Environment, OS User, Hostname, required Services and Display variable details, the Port Pool will be inherited from the primary Apps server

OS User must the same UID (User ID) and GID (Group ID) as the primary Apps server.

Adding additional Node

Click ‘Next and complete the Wizard to finish to your EBS Multi-Node deployment

Fast Backups and Restores

I recently came across an excellent post on Mike Swings’ Blog which does a great job is detailing the impact Delphix can have on Oracle EBS deployments, suggest you check it out – Fast Backups and Restores are Critical during EBS Upgrades, Testing and Development

Oracle EBS R12 and Delphix Agile Data Masking

The Business Challenge

Over the past 25 years I worked for various clients in the Defence, Aerospace and Finance industries, one business challenge which I frequently come across is ‘Data Masking’. During many engagements I frequently have to consider the management and use of many different security classifications and types of data, my experiences suggest that even though everyone agrees and acknowledges the need for ‘Data Masking’ it’s largely been parked or ignored, I believe this could be due to many factors including:

  • Required time to implement traditional Data Masking solutions
  • Experience of failed Data Masking projects
  • Unknown impact on existing process and productivity
  • Lack of application and data knowledge
  • No Data Masking tools and or skills
  • Undocumented database interdependencies, schemas and tables
Data at the centre
Security Onion

Historically the approach taken by many of these organisations to mitigate the lack of Data Masking and the associated risk of data loss was to rely on Physical and Network security.

Organisations have and continue to invest heavily in physical and network security implementing physical and organisational access control system and ‘Hardening’ the outer shell of their corporate networks by deploying Firewalls, De-militarised (DMZ’s), Intrusion Detection Systems (IDS) and Anti Virus (AV) solutions. The Application and Data access layers have remained the poor relation.

 

As we can see from my Security Onion this approach has only addressed part of the problem,  the biggest cause of data loss continues to be internal incidents, be that intentional or accidental. This problem has grown considerable over the last few years with a high number of very public data breaches and will only increase as organisations embrace the ‘Cloud’ and migrate more and more development and test activities to partners, 3rd parties and off-shore teams.

Remember we should need to consider all the layers of data access, do you know everyone who has access to your non-Production data, are you part of their HR on-boarding process ?

This is where Data Masking has a significant role to play in Risk mitigation for Data Loss

Delphix Agile Data Masking

During the summer Delphix announced the Delphix Compliance Engine so I thought I would get the top down and take it out for a Test Drive against an Oracle Vision R12.1 database to see how easy it is to get up and running.

Having worked on Defence ‘Black’ projects I have seen data security issues with Project descriptions, so I thought I would try masking Project descriptions for this posting.

PA_PROJECTS_ALL_Pre

A quick query of the PA_PROJECTS_ALL table before I applied any Masking rules.

After logging onto the Agile Data Masking UI I configuring my database connection, I  uploaded some masked data (a text file with DESCRIPTION1 to DESCRIPTION600) I then selected the ‘PA’ schema and navigated to the ‘PA_PROJECTS_ALL’ table and selected the ‘DESCRIPTION’ column, provided Domain and Algorithm and was ready to create and run my Masking Job

PA Project All

Now a couple of clicks to create the Masking Job

Create Masking Job

 

A check of Job completion summary screen

Overview

 

Now lets validate that the Oracle EBS R12 form shows the Masked Project description.

Project_Search

Now lets re-run the PA_PROJECTS_ALL query to see the Data Masking results in SQL*Plus

PA_PROJECTS_ALL_Post

Conclusion

The Delphix Agile Data Masking feature when combined with Database Virtualisation provides a solution that is able to address all the previous concerns and issues with rolling out an Enterprise Data Masking project.

With the Delphix Agile Masking, Delphix Replication and Amazon Web Services (AWS) support you now have all the tools you need to take your Oracle EBS R12 environment up into the Clouds allowing you to share your data with partners, 3rd parties and anyone else you need to collaborate with.

Check out the Delphix Agile Data Masking solution to see how Delphix can address your Data Governance, Data Protection and Security requirements.

 

 

Taking Oracle EBS R12 up into the Clouds with Delphix

Getting ‘Cloud Ready’

In my previous Oracle E-Business Suite (EBS) Virtualisation postings I have shown how Delphix can be used to Virtualise your EBS environment, and then how it can be used to to provision new virtual EBS environments.

Part 1: Virtualising Oracle EBS R12.1 using Delphix

Part 2: Creating a Virtual Oracle EBS Environment using Delphix

Now that we are ‘Cloud Ready’ I will show how we can use Delphix Replication to migrate your Oracle EBS environments into the Cloud.

Delphix supports the Amazon Elastic Cloud Compute (EC2) platform, and has also recently announced support for VMware vCloud Air.

i2Family
Amazon i2 Family

Note: When using choosing your Amazon Cloud instance for Delphix select a storage optimised instance type from the I2 family. The larger instances provide greater CPU and memory, the more memory you can give your Delphix Engine the better as this will be used as a cache improving read performance.

 

The I2 This family includes the High Storage Instances that provide very fast SSD-backed instance storage optimized for very high random I/O performance, and provide high IOPS at a low cost. 

Delphix requires that the all the storage attached be Amazon Elastic Block Store (EBS), Delphix does not support the use of instance store volumes

Using the Cloud

EBS Replication
Oracle EBS Replication with Delphix

In the example above the On-Premise Oracle R12 environment (Database, dbTech Stack & Apps Tier) are all replicated to a Delphix E2C instance.

This provides an extremely Agile deployment model where Production, Prod Support, Development, Test, Integration, Acceptance Testing and Training can all be hosted where makes best sense for the business.

It is becoming increasling common to see Production On-Prem and non-Prod in the Cloud, this could be as part of a longer strategic journey to the Cloud, with quick wins being delivered by using ‘Compute On-Demand’ or the final architecture.

When customers look at ‘SaaS’ based solutions a requirement which is frequently overlooked and can be challenging for non-Virtualised solutions is business reporting and integration. Very few organisations rely on a single business solution and often struggle to get their data out of the hosted solution. This is example where a Cloud Delphix Engine could be used to replicate back to On-Prem Delphix Engine, providing the business access to the required data.

Configuring Delphix for the Cloud

To get started logon to your Source Delphix Engine as a Delphix Administrator

EBS_Source

 

Navigate to System -> Replication

 

 

 

 

 

Provide Replication Target IP Address, Username and Password, configure Schedule and Network Options.

Source_Rep1

 

Hit OK

Source_Rep2

 

Click on ‘Run Now’ to start the Replication process

 

Target_Rep1

You can now Logon to the empty Target Server and from the pulldown select the Source Server and check the ‘Active Jobs’ to see the Replication process.

Target_Post

 

Now that you have Virtualised your Oracle EBS environment, configured Delphix Replication and Replicated the dSource and VDB’s to your Target server you are free to ‘Cloud Burst’, expanding and shrinking the number of EBS environments in-line with business demand.

For further information on how Delphix can be used to support your Data Migration projects visit the Delphix web site

 

Creating a Virtual Oracle EBS Environment using Delphix v4.1

Oracle EBS R12.1 Virtualisation

Since v4.0 Delphix has had the ability to Virtualise Oracle E-Business Suite (EBS) environments – (Database, Database Tech Stack & Apps Tier), in this 2nd post I will provide a detailed walkthrough on how you can use Delphix to provision a Virtualised EBS environment.

For this walkthrough I have built an R12.1.1 VIS environment running on a non-RAC Database server and single Application server with the directory structure below.

EBS R12.1
Oracle EBS R12.1 directory structure

In my previous post Virtualising Oracle EBS with Delphix  I showed how to injest an Oracle R12.1 EBS environment into Delphix, I will now walkthrough the steps to provision a full Oracle EBS R12.1 environment (Database, Database Tech Stack & Apps Tier onto a non-RAC database server and single Application server.

Provision Database Tech Stack

From the Delphix console select your Environment dbTech Stack we created in part 1 of the Blog and select your Target Oracle EBS Database server and update the fields as required, if like me you prefer to have each EBS environment running as a different OS user select the ‘Environment User’ from the pick list.

dbTech Stack - Target Environment
dbTech Stack – Target Environment

 

 

 

 

 

 

 

 

 

 

 

 

Select your Target ‘Group’ and ‘Snapshot Policy’

dbTech Stack - vFiles Configuration
dbTech Stack – vFiles Configuration

 

 

 

 

 

 

 

 

 

 

 

 

 

Click ‘Next’

dbTech Stack - Hooks
dbTech Stack – Hooks

 

 

 

 

 

 

 

 

 

 

 

 

Review and Click ‘Finish’

dbTech Stack - Summary
dbTech Stack – Summary

 

 

 

 

 

 

 

 

 

 

 

  Provision EBS Virtual Database (VDB)

During the previous step we provision an EBS Oracle Home on the Target Database server, we can now use our new Virtual Oracle Home to provision our Virtual EBS Database (VDB). Enter database name and set the ‘Environment User’ to the same value as the previous step.

Provision VDB - Target Environment
Provision VDB – Target Environment

 

 

 

 

 

 

 

 

 

 

 

 

Provide VDB name and Group, Click Next

Provision VDB - VDB Configuration
Provision VDB – VDB Configuration

 

 

 

 

 

 

 

 

 

 

 

 

 

Click ‘Next’ on the Hooks screen.

Review Summary and Click ‘Finish’ to start the VDB provision process.

Provision Apps Tier

We should now have our EBS Virtual database running on our Target Database Server out of it’s own Virtual Oracle Home, the next step is to provision the Apps Tier.

Select the Target EBS Apps Server and complete the ‘Target Environment’ form providing the ‘applmg’ account name the other details which will be used by the Oracle EBS adcfgclone process

Provision Apps Tier - Target Environment
Provision Apps Tier – Target Environment

 

 

 

 

 

 

 

 

 

 

 

 

 

Click ‘Next’

Provide Name and Group and Click ‘Next’

Provision Apps Tier - vFiles Configuration
Provision Apps Tier- vFiles Configuration

 

 

 

 

 

 

 

 

 

 

 

 

 

Click ‘Next’ on the Hooks screen

Review the Summary and click ‘Finish’ to launch the provision of the AppsTier

Provision Apps Tier - Hooks
Provision Apps Tier – Hooks

We have a now a provisioned a full Virtual EBS environment from our Delphix server running on our Target Database & Apps Server

In the final part of this Trilogy I will show how you can use Delphix to provision an EBS environment in the Cloud

Virtualising Oracle EBS R12.1 using Delphix v.4.1

Oracle EBS R12.1 Virtualisation

Since v4.0 Delphix has had the ability to Virtualise Oracle E-Business Suite (EBS) environments – (Database, Database Tech Stack & Apps Tier), in this post I will provide a quick walkthrough on how you can configure Delphix to Virtualise your EBS environment.

For this walkthrough I have built an R12.1.1 VIS environment running on a non-RAC Database server and single Application server with the directory structure below.

EBS R12.1
Oracle EBS R12.1 Directory Structure

Before you can begin Virtualising your EBS environment you need to register the Source & Target EBS Database and Application Server and Operating System user accounts within Delphix, you can do this by using the Delphix UI thus:

Manage -> Environments -> Add Environments providing your Oracle EBS database (oracle) and Application owner (applmgr) accounts details for the Source and Target Servers.

Virtualising Oracle EBS Database Tech Stack

We are now ready to start Virtualising the Oracle EBS environment, in this example I am going to start with the EBS dbTech Stack.

As you can see below I have set the Data Type to ‘builtin:ebs-db’, this lets Delphix know that you are planning to manage an EBS Oracle Home,  the ‘Environment User’ is set to my Oracle EBS database owner and ‘Data Path’ to the top level directory.

Delphix provides the ability to exclude directories from the dSource, as I have my Oracle database files located under my top level directory I have excluded db/apps_st/data (relative path) as my datafiles will be managed by the database dSource and do not want to import them twice.

I have also excluded ‘bump’, ‘cdump’, ‘udump’ and the ‘diag’ directories as I do not want the log files in my Virtual clones

Add dSource - Source
Add dSource – Source





 

 

 

 

 

 

 

 

 

 

 

Check your entries and if OK click ‘Next’

It’s good practice to give your dSource a meaningful name, I have included the environment name and type in the dSource name to help with the description

Add dSource - dSource Configuration
Add dSource – dSource Configuration

 

 

 

 

 

 

 

 

 

 

 

 

 

Select your ‘Target Group’ and then click ‘Next’

Add dSource - Summary
Add dSource – Summary

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Review the summary screen and if OK click ‘Finish’

Delphix will now kick off a Job to ingest the Oracle Tech Stack, the time taken will be dependent upon your network and infrastructre. My 9.28GB Oracle Tech Stack compressed down to 5.57GB (1.6:1 ratio)

Virtualising Oracle EBS Database

If you have used Delphix to Virtualise a Database before you will be familar with the next steps but I have included them here for completeness.

Click on ‘Add dSource’ select your source EBS Database, and enter the Delphix database username and password.

db1

 

 

 

 

 

 

 

Verify the credentials and if all OK click ‘Next’

db2

 

 

 

 

 

 

Select ‘Target Group’ and click ‘Next’

db3

 

 

 

 

 

 

Take defaults to perform an immediate Load

db4

 

 

 

 

 

Review the settings and click ‘Finish’, Delphix will now kick of a Job to ingest the Oracle Database, the time taken will be dependent upon database size, network and infrastructure.

Virtualising Oracle EBS Apps Tier

It’s now time to Virtualise the Oracle EBS apps Tier.

Here I have set the Data Type to ‘builtin:ebs-app’, this lets Delphix know that you are planning to manage an EBS Oracle Apps Tier the ‘Environment User’ is set to my Oracle EBS Application owner and ‘Data Path’ to the top level directory.

As the Oracle post clone process will recreate the $INST_TOP we can exclude that from the Apps Tier dSource, provide the relative path to $INST_TOP if located under your top level directory.

ap1

 

 

 

 

 

 

 

 

 

 

 

 

Check you ‘Environment User’, ‘Data Path’ and ‘Paths to exlude’ and click ‘Next’

Enter a meaningful dSource Name and select Group as before

ap2

 

 

 

 

 

 

 

 

 

 

 

 

Review and click ‘Next’

ap3

 

 

 

 

 

 

 

 

 

 

 

 

Click ‘Next’ to take the defaults

ap4

 

 

 

 

 

 

 

 

 

 

 

Review the summary screen and if all OK click ‘Finish’

Delphix will now kick of a Job to ingest the Oracle Apps Tier, the time taken will be dependent upon your network and infrastructre.

We have now Virtualised our entire Oracle EBS environment (DB Tech Stack, Database and Apps Tier) within Delphix, in my next post I will walkthrough how can use it to create multiple Virtual Oracle EBS environments on premises or in the Cloud.

 

Delphix ‘Self Service’ upgrade

Delphix Self Service upgrade

One on the cool new features in Delphix V4 is the ability to perform a Delphix Engine upgrade without having to engage with support, thought I would give it a go.

Download latest Patch set

Visit https://download.delphix.com and navigate to the required version e.g. 4.0.4.0

Select ‘Media’ and click on the delphix compressed TAR file e.g. delphix_4.0.4.0_2014-06-10-07-31.upgrade.tar.gz and  equivalent MD5 checksum file to download to you local desktop.

Once downloaded, compare the MD5 hash value of the download file with that in the MD5 text file 

There is no need to unzip or untar the file as the Delphix Engine performs that for you.

Upload Patch Set

Engine Set-up Login to the Delphix Engine Set-Up and click on ‘View’ with the System Upgrade Management panel.

 

 

 

 

 

 

Version

You will then presented with a screen showing current version and any staged versions.

Click on the ‘UP’ arrow in the top left corner and navigate to the compressed TAR file.

 

 

 

File Upload

 

A progress bar will shown during the ‘File Upload’

Once the upload is complete hit the ‘Refresh’ icon to watch the ‘unpacking’ complete.

 

* NOTE: Due to the way Safari has implemented Flash you will need to use Firefox, Chrome or another browser

Lets do it!

Applying Upgrade

We are now ready to upgrade the Delphix Engine.

Click on ‘Apply Upgrade’ when your ready to go

 

 

As this process may require the Delphix Engine to be reboot, it’s good practice prior to the upgrade to shutdown all the virtual databases and take a VMware / storage layer snapshot.

Post Upgrade Once upgraded you should be able to see the ‘Running’ and ‘Previous’ versions

 

 

 

 

 

The Data Supply Chain

The Data Supply Chain

 

During the late 80’s early 90’s I worked in the high tech electronics industry, more precisely ‘Manufacturing Supply Chain’. This was a time of great change with IT systems delivering integrated Finance and MRP solutions and the start of the ubiquitous use of desktop computing, who remembers using Lotus 123, Harvard Graphics & WordPerfect ?

 

But the biggest change in the manufacturing supply chain came from Japan, with ‘Kanban’, ‘Jidoka’, ‘Andon’ and other and Japanese processes and manufacturing terms  becoming common place.

As a MRP (material resource planning) engineer I had objectives all based around productivity, reducing costs and improving the time taken to deliver products to customers. eg.

  • Reduce inventory costs by $$$
  • Reduce delivery time to customers by X weeks
  • Increase throughput / productivity by Y
  • Improve customer satisfaction and quality x%

The objectives were challenging but attainable, by analysing the end-to-end supply chain and working with key stakeholders (suppliers, buyers, stores, assembly lines and QA) I was able to identify opportunities to reduce the overall product lead times.

These included:

  • Process re-engineering e.g. moving to ‘JIT’ Just-In-Time manufacturing
  • Collapsing BOM’s (Bill of Materials) and introducing phantom part numbers to reduce lead times by avoid the need to repeatedly book items in and out of stores.
  • The creation of local assembly line stores for commonly used items to reduce the volume of stores transactions.
  • Negotiating regular deliveries of materials and components in line with demand reducing the value of the inventory and WIP (Work In Progress).

The Delphix Data Supply Chain

Roll forward 25+ years and the IT industry has changed and matured to something unrecognisable, however IT has been playing catch-up to address some of the same challenges that manufacturing had all those years ago.

Cost Reduction

With Delphix customers are realising significant cost benefits typically seeing a 10x reduction in non-production storage,  a reduction in the number of database server and licences by improved asset utilisation and management, as well as numerous agility savings.

Accelerated Time to Market

The Delphix ‘Self Service’ features are enabling application development teams to reduce project time scales and accelerate time to market, by taking all the wait times and delays due to the hand-offs between the various IT teams e.g. system administrators, storage admininstrators & DBA’s out of the process.

Increase Productivity and Throughput

With Delphix application development and test teams are accelerating their movement from Waterfall to Agile, Scrum or Kanban based SDLC’s (software development lifecycle), increasing productivity and throughput. This is achieved by removing the delays and storage constraints enabling developers to get timely access to their own full size copy database rather than having to share databases and coordinate testing with multiple teams.

Improved Quality and Customer Satisfaction

Application development teams that have embraced Delphix are seeing the benefits of using full size data sets, with visible improvements in quality and customer satisfaction measures, a reduction in the volume of Production incidents and enhanced MTTR (mean time to resolve) for data related problems. 

Manufacturing & Data Supply Chain

In the table below you can see the business drivers and objectives are common for both Manufacturing and the Data Supply Chain, what’s change now is for the first time we have the tools and processes in place to deliver an end to end Data Supply Chain solution.

Data Supply Chain