Create Vocabulary Mapping Tables.

This function creates source to source and source to standard vocab mapping tables.

CreateVocabMapTables(connectionDetails, cdmSchema, cdmVersion, sqlOnly = FALSE)

Arguments

connectionDetails

An R object of type
connectionDetails created using the function createConnectionDetails in the DatabaseConnector package.

cdmSchema

The name of the database schema that will contain the Vocab mapping tables. Requires read and write permissions to this database. On SQL Server, this should specify both the database and the schema, so for example 'cdm_instance.dbo'.

cdmVersion

The version of your CDM. Currently "5.3" and "5.4" are supported.

sqlOnly

A boolean that determines whether or not to perform the load or generate SQL scripts. Default is FALSE.

Details

This function assumes
createCDMTables() has already been run and the Vocabulary tables have been loaded.