Data export for production database

ZeeForge was retained to solve a significant obstacle blocking effective use of a production database acquired from a third-party for a major pharma. Client personnel spanning a wide range of roles and training needed to export large volumes of data in a variety of file formats for use by a variety of third-party production and research tools. The data export functionality supplied with the database was designed to allow technically sophisticated users to occasionally extract small amounts of data.

ZeeForge identified three categories of client users. Based on "stories" collected from representatives of each category, we identified specific examples of export requests and created test cases that demonstrated the mismatch between the needs of the tool's users and the database's behavior. We gathered specific requirements for query capabilities, file names, file formats, performance, and client workflow integration. We worked with the third-party database supplier to identify specific elements of database access code requiring modification, designed and built a working desktop accessory with interactive graphical user interface, and worked with client technical staff to develop implementation and deployment strategies.

ZeeForge is eager to share more information about this example. We are still preparing that information for publication. Please use the form below to request our pre-publication material.