Software AG Case Studies Cemplex Group and CONNX

Edit This Case Study Record

	Cemplex Group and CONNX Software AG

Cemplex Group and CONNX

Software AG

Technology Category	Application Infrastructure & Middleware - Database Management & Storage Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries	Construction & Infrastructure
Applicable Functions	Business Operation
Use Cases	Inventory Management
Services	System Integration
Challenge	Cemplex Group, a leader in the specialty concrete market, was implementing Tableau reporting software for its enterprise needs. The goal was to connect all the data company-wide into one reportable data set. However, Cemplex uses a legacy, indexed file-based, accounting software for accounting, inventory, and payroll. Nine of the different subcontracting Cemplex companies use this legacy software. Each company has its version of the software with the summaries aggregated at the corporate level. To drill down to the employee level requires access to each of the nine legacy accounting software’s indexed files. This complicated structure made reporting tedious and time-consuming. Read More
About Customer	Cemplex Group is a leader in the specialty concrete market, providing the knowledge and ability to solve complex project needs. The company specializes in multi-family and elevated deck waterproofing, gypsum underlayment, sound attenuation, self-leveling underlayment, moisture remediation, and corrective concrete applications. Cemplex Group consists of subcontracting companies with corporate offices in Oklahoma City, Oklahoma. The company's operational footprint covers Texas, Georgia, Florida, and Ohio. Cemplex has more than 30 years of experience supplying and installing quality products to general contractors and end users in the construction field. Whether for renovation reconfigurations or new construction, Cemplex Group performs projects safely, on time, and within budget. Read More
Solution	The underlying data is stored in legacy 32-bit indexed files. CONNX provides 32- to 64-bit bridge software and a relational view of the indexed files that Tableau uses to report on the data. CONNX DB Adapter connects to combine the nine different companies’ data and presents a relational view of the data so that Tableau can report on it in the same way as existing Cemplex Enterprise relational data. IT Systems Administrator Donald Counts said: “Our CIO wanted to use Tableau for reporting on enterprise relational data and legacy data stored in Indexed files. CONNX made this possible, walking through the install and helping us diagnose permissions issues accessing the files in different locations.” Both the DB Adapter and the 32- to 64-Bit Bridge enabled the CIO to use Tableau for all of their reporting and analytical needs. Read More Log in to view content
Contents

Technology Category

Application Infrastructure & Middleware - Database Management & Storage

Platform as a Service (PaaS) - Data Management Platforms

Applicable Industries

Construction & Infrastructure

Applicable Functions

Business Operation

Use Cases

Inventory Management

Services

System Integration

Challenge

Cemplex Group, a leader in the specialty concrete market, was implementing Tableau reporting software for its enterprise needs. The goal was to connect all the data company-wide into one reportable data set. However, Cemplex uses a legacy, indexed file-based, accounting software for accounting, inventory, and payroll. Nine of the different subcontracting Cemplex companies use this legacy software. Each company has its version of the software with the summaries aggregated at the corporate level. To drill down to the employee level requires access to each of the nine legacy accounting software’s indexed files. This complicated structure made reporting tedious and time-consuming.

About Customer

Cemplex Group is a leader in the specialty concrete market, providing the knowledge and ability to solve complex project needs. The company specializes in multi-family and elevated deck waterproofing, gypsum underlayment, sound attenuation, self-leveling underlayment, moisture remediation, and corrective concrete applications. Cemplex Group consists of subcontracting companies with corporate offices in Oklahoma City, Oklahoma. The company's operational footprint covers Texas, Georgia, Florida, and Ohio. Cemplex has more than 30 years of experience supplying and installing quality products to general contractors and end users in the construction field. Whether for renovation reconfigurations or new construction, Cemplex Group performs projects safely, on time, and within budget.

Solution

The underlying data is stored in legacy 32-bit indexed files. CONNX provides 32- to 64-bit bridge software and a relational view of the indexed files that Tableau uses to report on the data. CONNX DB Adapter connects to combine the nine different companies’ data and presents a relational view of the data so that Tableau can report on it in the same way as existing Cemplex Enterprise relational data. IT Systems Administrator Donald Counts said: “Our CIO wanted to use Tableau for reporting on enterprise relational data and legacy data stored in Indexed files. CONNX made this possible, walking through the install and helping us diagnose permissions issues accessing the files in different locations.” Both the DB Adapter and the 32- to 64-Bit Bridge enabled the CIO to use Tableau for all of their reporting and analytical needs.

Impact #1	Simplified solution implementation across the business
Impact #2	Relational reporting now possible across data types in Tableau

Impact #1

Simplified solution implementation across the business

Impact #2

Relational reporting now possible across data types in Tableau

Download PDF Version

Overview

Cemplex Group and CONNX

Operational Impact