Load data and discrepancies from a non-InForm clinical data system
Clinical data systems other than InForm must load data and discrepancies into Oracle DMW in data files. Each load must include an additional file. The file must:
-
Be named exactly as specified in the DISC_LOAD_TBL column of the DME_EXTERNAL_MODEL_ATTRIBS table in your database.
-
The file must be formatted the same way as data files (SAS files or for text: fixed or delimited format, and if delimited, either using enclosing characters or not).
-
Be in the same .zip file as the data and discrepancy files for text files or the same XPort, CPort, or SAS datasets.
-
Include values in three columns for each record as shown in the following table. These values are written to an internal table in the input clinical data model.
Table 7-1 Columns in the Generated Clinical Data Model Forms Table
Order | Column Name | Datatype | Length | Description |
---|---|---|---|---|
1 |
TABLE_NAME |
VARCHAR2 |
30 |
The Oracle name of the table in the external system that contains the record. |
2 |
KEY_VALUES |
VARCHAR2 |
4000 |
The unique key values for the record, separated by tildes (~), without quotation marks, and in column order. DMW checks these values against the surrogate key value it generates for each record for use in data lineage tracing. |
3 |
PARTIAL_URL |
VARCHAR2 |
4000 |
The ID or other string required to uniquely identify the record in the external system. |
For more information, see Using the Generic Connector to Integrate DMW with a Clinical Data System, My Oracle Support article 2172786.1, or the documentation provided by the integration vendor.
Parent topic: Load data from a file