Portfolio

ETL solutions for publishing

Global publishers gain a 360-degree view of business with our ETL management

Influential Software delivered a ETL solution for a publishers that collected data from global servers and transformed it into intuitive reports.

A graphic showing people working. This represents influential softwares ETL solutions for publishers representing influential software

Executive brief

Unifying global systems with ETL solutions for publishers

Our client is a global academic publishing house with offices in the UK, the US, Asia, and Australia. Influential Software’s integration experts delivered database management that transformed data from global servers into easy-to-read reports. This solution enabled the business to:

cut software license costs

reduce manual data tasks

centralise data management

see accurate sales predictions

Curious about how we achieved this with our ETL services? Read on to find out more.

The full story

Purple arrow encouraging readers to scroll down for the rest of the GDPR data solutions case study

The challenge

Legacy software was hindering data flow

At the time of this project the publisher had begun to embrace online publishing, as well as acquiring several smaller publishers. This growth meant the company was producing greater volumes of data than ever before. And in a world where data is the new oil, the company couldn’t afford to let this data go idle. Seeing how other publishers were using data to cut costs and boost revenue, our client wanted to achieve the same.

 

However, the publisher’s existing technology was not able to handle the volumes of data being produced. Not only did they have thousands of employees spread across offices worldwide, but they had a mountain of data to control. Staff needed an easy way to report on everything from stock to customers and payments to standing orders.

 

The lack of a central access point for managing and reporting on company data had the following drawbacks:

 

  • duplicated data was producing inaccurate reports
  • costly licensing fees due to multiple types of software
  • high risk of human error caused by manual data entry
  • difficulty managing data due to lack of central access

 

To maintain its competitive position in the publishing market, our client needed to find a modern data integration solution.

The solution

Uniting global data through ETL solutions

The publisher approached us on the basis of our work for well-known publishers such as Hachette and Oxford University Press. And with our in-depth data integration experience, we had the skills to help them turn their data into reports.

 

Instead of starting from scratch, we decided to build on the client’s existing system. This approach would ensure maximum value with minimum disruption. We identified Oracle as the ideal ETL tool due to its ability to manage multiple databases on a single server.

 

For the reporting side, we integrated Oracle with an SAP BusinessObjects tool. The client used these intuitive BusinessObjects reports for everything from accounting to predicting purchasing trends and measuring customer loyalty.

The benefits

Boosting productivity and efficiency with ETL integration

The primary goal of this data solution was to collate all the company’s global data into one central location. This unified data platform brought a host of benefits for the company, from cutting costs to improving sales.

 

A central data access point meant the company could now consolidate multiple software licences into a single, cost-effective licence. The company also reduced the number of work hours spent on manual data entry.

 

Overall, the business benefits of this ETL data integration project were:

 

  • centralised, easy access for all employees
  • reduced manual data entry and licensing costs
  • the ability to predict future sales trends
  • increased flexibility thanks to scalable solution

 

Based on our consistent and successful delivery, the publisher has kept us as their go-to systems integrator throughout their journey. Since starting the project, the client’s business data has grown 10 times in size. And our ETL solutions for publishers have scaled with them, proving the long-term value.

We’re the solution to your digital integration challenges.

This publishing house is one of dozens that benefit from our data integration expertise. We provide end-to-end support to ensure you’re getting the best value for your money. To find out how we can help you, see our ETL solutions page.

Info

6th November 2020
data integration, customer data, etl

Privacy Preference Center

Necessary

Advertising

Analytics

Analytics cookies collect information that is used either in aggregate form to help us understand how our Websites are being used or how effective our marketing campaigns are, or to help us customise our Websites for you.

Google Analytics
The cookie _gcl_au is used by Google Analytics to understand user interaction with the website.

For example, in order for Google Analytics to determine that two distinct hits belong to the same user, a unique identifier, associated with that particular user, must be sent with each hit.

The analytics.js library accomplishes this via the Client ID field, a unique, randomly generated string that gets stored in the browsers cookies, so subsequent visits to the same site can be associated with the same user.

By default, analytics.js uses a single, first-party cookie named _ga to store the Client ID, but the cookie's name, domain, and expiration time can all be customized. Other cookies created by analytics.js include _gid, AMP_TOKEN and _gac_. These cookies store other randomly generated ids and campaign information about the user.

Google Analytics
_gcl_au, _gid, _ga, gtm_preview

Other

WordPress uses cookies for authentication. That means that in order to log in to our WordPress site, you must have cookies enabled in your browser.

There are two types of cookies set by WordPress.
1 — Session cookies — These are ‘strictly necessary’ cookies as WordPress will not be able to function without it.
2 — Comment cookies — These are not ‘strictly necessary’ cookies and are set when users leave a comment on a post.

Wordpress Session cookies:
Users are those people who have registered an account with the WordPress site.
wordpress_[hash]
wordpress_logged_in_[hash]
wordpress_test_cookie
wp-settings-{time}-[UID]

Wordpress comments:
Comments are usually turned off by default.
If by chance they are still active on a post, asides being turned off when spotted, data from these are not saved by Influential.
- When visitors comment on a post, they too get cookies stored on their computer. This is purely a convenience so that the visitor won’t need to re-type all their information again when they want to leave another comment. Three cookies are set for commenters:
comment_author_{HASH}
comment_author_email_{HASH}
comment_author_url_{HASH}

Wordpress, Intercom
comment_author_{HASH} comment_author_email_{HASH} comment_author_url_{HASH} wordpress_[hash] wordpress_logged_in_[hash] wordpress_test_cookie wp-settings-{time}-[UID]
intercom-id-[app_id],intercom-session-[add-id]