Name: Structures from MDDR with List
Author: Carol Gorst
Version: 2.0
Created: 08/2004
Modified: 08/2007
Purpose: Read data from MDDR via the MDL Direct cartridge (formerly ISIS/Direct) by dynamically generating the SQL select query from the user supplied list of IDs.
Executes an SQL Select statement to select data records from a relational-chemical database that is enabled for MDL Relational Chemistry Server.
Requirements: PP Server 6.1.1, Integration collection, MDL Direct cartridge and installation of MDDR database
O/S: Windows and Linux
Limitations: N/A
Keyword: database MDDR MDL structure ODBC Oracle
Contents: Structures from MDDR with List.xml
Installation:
1. Import the component by dragging and dropping in the Pipeline Pilot client workspace.
2. Change the ODBC DSN, username and password to point to the in-house installation of the MDDR databasee.
3. Cut and paste a list of IDs in the ListID parameter, one on each line.
4. Define what column in the MDDR database your IDs are referring to in the Queryfield parameter (default is CDBREGNO).