Structures from MDDR with List

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).