Continue in 2 seconds

CONNX is the Engine that Provides Access to Tyco's Legacy Data Files

Published
  • January 01 1999, 1:00am EST

BACKGROUND: Tyco Printed Circuit Group, a division of Tyco International Ltd., is a multi-billion dollar publicly traded company headquartered in Exeter, New Hampshire, and operates in over 70 countries worldwide. Tyco's products and services fall into four major categories, including fire and security services, disposable and specialty products, flow control, and electrical and electronic components. Tyco Printed Circuit Group is based in Stafford Springs, Connecticut, where they build custom electronic assemblies, printed circuit boards, turnkey enclosures and sophisticated heat sink assemblies.

PLATFORMS: We are using CONNX on a Digital Alpha system running Open VMS. We are currently using the software to access our RMS data and have plans to utilize CONNX on additional platforms and databases including RDB, Oracle and DB2.

PROBLEM SOLVED: Quite simply, CONNX is the engine that provides us access to our legacy data files. We have built custom GUI modules to address functionality not present in the existing system. So we needed a tool that would allow us to open up the legacy system via the Web. We are utilizing ASP (active server pages) and Windows CE technologies on portable palm top computers to access the data sources via RF (radio frequency). CONNX has empowered our users to create data views that fit their specific needs, so they can get the information they need both when and where they need it. CONNX has effectively filled the gap between our PCs (both portable and desktop) and our enterprise data.

PRODUCT FUNCTIONALITY: CONNX has performed very well for us. Its speed and ease of use have been the most appreciated features, and it has simply done everything we have expected it to do. We are also planning on taking advantage of CONNX's ability to join disparate data sources and combine them into a single view. Because RMS has no support for triggers or stored procedures, we have created ActiveX objects running on IIS 4 that serve as triggers and procedures. Using CONNX, our users will have access to the information they need in a single report, regardless of which database it is stored in.

STRENGTHS: The performance and ease of creating the common data dictionary are very strong features. In fact, CONNX's functionality and ease of use were unmatched in benchmarks we performed against competitive products. And considering the performance of the software, it is very reasonably priced.

WEAKNESSES: The setup for a DEC Alpha running Windows NT was a little difficult at first, but we were able to get the complete system working in very little time with SolutionsIQ's technical staff support.

SELECTION CRITERIA: We needed to utilize our existing manufacturing system more and extend our past technology investments. CONNX gave us the engine that made all our data access requirements a reality. We looked at many products, but CONNX was the easiest to set up and deploy, one of the fastest and priced less than half of some of the competing packages. After doing a series of comprehensive benchmarks, the decision to buy CONNX was fairly easy.

DELIVERABLES: CONNX has given us the ability to generate reports via the Web quickly and with familiar interfaces to users. We have tested the software with multiple 4GL front-end applications (including Visual J++, Visual Basic 5 and 6, Delphi 3 and 4 and Visual Interdev) and have had great success using CONNX in all cases.

VENDOR SUPPORT: The support for CONNX from SolutionsIQ has been excellent. Whenever we have had any issues, the tech support specialists have been easy to contact and exceptionally proactive in making sure our questions were answered. If the person we talked to did not have an immediate solution, they were prompt in getting us connected with someone that did.

DOCUMENTATION: The documentation with the software was very well laid out and easy to follow. CONNX could be up and running without making a single call if it needed to be.


Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access