Governor’s
Commissioned by
Because the State of Maryland’s law enforcement data exists across multiple databases and platforms, DPSCS sought a tool that would simplify the data mining and querying of each database. They chose the Oracle Business Intelligence Suite Enterprise Edition to provide the BI platform and Web portal for the Law Enforcement Dashboard. Secondly, they needed a middleware tool that could provide standards-based access to mainframe data in real-time as opposed to warehousing the data. DataDirect Shadow was selected because of its ability to provide direct SQL access to the data stored in legacy Information Management Systems (IMS) and Virtual Storage Access Method (VSAM) databases. DataDirect Shadow helped lower the latency time of the joint solution through its ability to transform non-relational mainframe data into a relational format compatible with the Oracle BI platform – thus eliminating the need for a data repository.
“We did not want to pull dedicated IT and development resources away
from existing projects by requiring system owners to write interfaces or
standard APIs for various applications,” said
The foundation of the Law Enforcement Dashboard includes high performance, call-level interfaces to data on the mainframe and other databases that feed directly into the Oracle BI solution and Web portal. With DataDirect Shadow in place, the underlying mainframe-data mapping is transparent to the developer who simply codes standard SQL calls. Prior to the creation of the Law Enforcement Dashboard, response times for each queried database averaged upwards of six minutes. With the combined Oracle and DataDirect Technologies’ solution implemented, response time has dropped 90 percent, averaging just seconds, even though results are still coming from multiple databases across various state agencies and departments.
“By working together early in this project, Oracle and DataDirect
Technologies were able to architect a solution that best met the State
of Maryland’s business needs,” said
“With the increasing role of IT in law enforcement and the considerable
presence of mainframe systems in use, organizations are seeking
innovative middleware technology to simplify the complexity of mainframe
integration and make better use of existing assets,” said
DataDirect Technologies is a member of the Oracle PartnerNetwork, Oracle’s global business network of more than 20,000 companies who deliver innovative software solutions based on Oracle software.
About DataDirect Technologies
DataDirect Technologies is the software industry’s only comprehensive
provider of software for connecting the world’s most critical business
applications to data and services, running on any platform, using proven
and emerging standards. Developers worldwide depend on DataDirect®
products to connect their applications to an unparalleled range of data
sources using standards-based interfaces such as ODBC, JDBC™ and
ADO.NET, XQuery and SOAP. More than 300 leading independent software
vendors and thousands of enterprises rely on DataDirect Technologies to
simplify and streamline data connectivity for distributed systems and to
reduce the complexity of mainframe integration. DataDirect Technologies
is an operating company of
DataDirect and Shadow are trademarks or registered trademarks of
Source: DataDirect Technologies
DataDirect Technologies
April Harned, 646-246-0484
april.harned@datadirect.com