About DataTechnics




DataTechnics exists to help you understand and realise the Value of Data Warehouse Automation

Our goals?
Reduce Cost & Complexity
Increase Productivity & Increase Flexibility.

We have over 15 years of experience in enterprise software, helping our clients

• analyse their requirements,
• build investment cases and
• successfully deliver critical business value through the application of technology.


Based in Heidelberg and covering Germany, Austria and Switzerland, we have the localised skills to help you drive the next phase of innovation in your Information Management strategy. We partner with some of the regions’leading providers of BI and Data expertise to help our customers overcome any knowledge or strategy gaps in your workforce. This careful blend of skills and technology will give your business the edge in the daily competitive battle.

Why DataTechnics?



Your Success - As Fast as Possible

DataTechnics is interested in only one thing: Your Success - As Fast as Possible.

As a leader in your I.T. organization it is your responsibility to your business to ensure optimal efficiency for every hour and Euro you spend. In our first 30-minute meeting, Data Technics will quickly show you another way to deliver all the information your business will ever need at a fraction of the cost you need today.

We are not looking to build youanother archaic, monolithic Data Warehouse. We are not interested in projects that last for years or billing you thousands of hours of “consultancy and advice” – we pride ourselves on being quick and efficient (almost ruthless) in our process.


We want to make I.T.
Agile, Responsive & Collaborative
with the Business.


Data Warehouse Automation is one of the best innovations within your Information Management Strategy and DataTechnics is ideally placed to help you drive this Innovation. Our services will help you understand this technology and its resultant Return On Investment (ROI).


DataTechnics - Light, Fast & Focused

ROI Challenge



Return on Investment (ROI)
We all want it - I.T. very seldom achieves it


DataTechnics has over 15 years experience in helping I.T. and Business come together to maximise the opportunity for value and success. Data Warehouse Automation, in the vast majority of cases, pays for itself within 12 months! DataTechnics has developed a Return on Investment Calculator, which in moments will show you the ROI of Data Warehouse Automation.


Enough with “analysis paralysis” and endless excuses
surely you have the time to consider
something that could save your business millions of dollars.


We will prove to you the benefits of Data Warehouse Automation.

Frankly, all we need is a project, a few days of effort and we’ll build you a POC that blows all your pre-conceptions of Data Warehousing out of the last century and squarely into the future.....


.....because one thing is certain, Big Data is here to stay and
you cannot let your competition get their first....
So come Challenge us

Top Ten Benefits of Data Warehouse Automation Technology



  1. “ELT not ETL” – ELT – Extract, Load, Transform – uses the underlying DB capabilities to extract and load data into the DB. It uses native functions to transform the source data. By removing the need for separate “transformation tools” you remove a potentially massive cost in architecture, applications, required skills and process complications.
  2. “Source Data Profiling” – Data in any source system can be profiled against a set of metrics to provide data quality assurance. Delta reports can be generated to understand the differences between 2 versions of any single source system.
  3. “No vendor Lock-In” – With the right automation technology you are producing DB native code and do not require third party tools, architectures and skills
  1. “Data Vault supported” – DataVault without automation comes at a very high management and maintenance cost. DataVault is also exceptionally suited to automation – with the correct rules in place, it is possible to completely automate the building of hubs, satellites and links.
  2. "Data Lineage function – Out of the Box.” – With automation technology the DW team would be able to answer business users’ questions easily around data lineage and incident management would be more predictable and more efficiently accomplished.
  3. “Performance Gains, Cost Reduction” – Automation technologies use native code optimised to your underlying DB to generate the Data Warehouse. Every developer in your team will produce the same quality code.
  1. “Automated Documentation" – Automation Technology documents and audits every part of the DW, from Development through to Production.
  2. “Version Control” – Deployment is an easy task to manage and the options for roll-back, testing, etc. are easier to manage.
  3. “Better support for Reporting Layers” – Automation technologies come with front-end support out of the box and will often provide all of the cube creation functionality you’ll ever need.
  4. “Automation drives standards” – How often have you had to unpick thousands of lines of code to find the fault? How many times have you tried unsuccessfully to manage standard naming conventions that decrease your flexibility and increase cost and dependency. I.T. should be about simplicity. Automation technology means there is NO BAD CODE and all standards are automatically managed.

Data Warehousing Myths



Myth #1:

Your Project Must be Fully Defined at Outset

Truth: You’ve made your life easy, well done; but the business doesn’t care and when the inevitable “Change Request” appears, your plans are for naught. Your “project” will be different tomorrow because your requirements and data sources will have either expanded or changed, or both. If you cannot change a definition without significant pain (cost & time) then your approach is wrong.


Embrace the Inevitability of Change rather than trying to Eliminate the Potential for Change


Solution: If you find yourself trying to define everything before you start, STOP. Your approach is doomed to failure at a high cost. Work incrementally, deliver value early and reduce the cost and risk of failure per delivery. Continuous Delivery is Key.

Myth #2:

The Business Needs a Data Warehouse

Truth: Nobody in the Business ever asked for a Data Warehouse. A Data Warehouse is just something to enable IT to deliver the information a business needs to operate. By talking in “Data Warehouse” language, IT further dissolves the communication between IT and Business. As data proliferates and information requirements become more complex, a broken dialogue will only make things worse.


The Business doesn’t care how, it just cares NOW!


Solution: An Agile delivery methodology, coupled with more visual and “Business ready” technology, increases the participation of the customer in your execution and increases the chances of success.

Myth #3:

The Business doesn’t know what it wants!

Truth: If the Business didn’t know what it wanted, it wouldn’t be in business for very long! This is the classic complaint within IT that is a result of Myths 1 and 2.
Frankly, it is irrelevant if they know what they want or when they find out, the goal is to deliver it and if you are set-up to only deliver WHEN they know.....then you’re going to fail.


If the Business doesn’t understand its data, how can it be an effective partner to IT?


Solution: By using technology and methodology that allow you to visually collaborate with your Business leaders, you will both understand what is needed and the requirements can be driven in partnership. Effective communication is a critical success factor in BI projects and sadly lacking in the world today.  

Any Source - Anywhere including SAP



Your Business doesn’t particularly care where the data comes from – as long as it is clean and reliable. They are not interested in the technical difficulty of bringing together data from multiple sources, in different structures and the overhead of transforming all this into something coherent and reliable.

Neither should you be. It’s 2015 and you don’t need to be.

With a Data Warehouse Automation tool like WhereScape RED any source system is supported and now with a partnership with the world’s leading SAP integration technology, even your hitherto painful integrations with SAP are a breeze.

Not only are these sources supported, each and every one can be profiled and documented in minutes! Now you’ll have a baseline of structure, quality and metadata for every single one of your source systems in less time that it takes to analyse one using traditional methods. If you have a Master Data Management project, this capability alone could save you a fortune.

DATA SOURCES SUPPORTED:

Delimited files on UNIX, Linux and Windows.
Fixed width files on UNIX, Linux and Windows.
XML Files.
Excel spreadsheets.
Native database connections supported by the data warehouse database (e.g. Linked Servers or SQL Server Integration Services).
ODBC: any data source that has an ODBC 3.0 or later compatible driver available.
Hadoop.

These include, but are not restricted to:

Microsoft SQL Server.
Oracle.
Teradata.
DB2.
Informix.
Sybase.
MySQL.
Progress.
PostgreSQL.