Software AG > Case Studies > Cemplex Group and CONNX

Cemplex Group and CONNX

Software AG Logo
Company Size
200-1,000
Region
  • America
Country
  • United States
Product
  • Digital Business Platform
  • CONNX DB Adapter
  • 32- to 64-Bit Bridge
Tech Stack
  • Tableau
  • Legacy Accounting Software
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Digital Expertise
  • Productivity Improvements
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
About The 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.
The 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.
The 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.
Operational Impact
  • Simplified solution implementation across the business
  • Relational reporting now possible across data types in Tableau

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.