I’m trying to use the PatientLevelPrediction package, but I’m getting stuck at the extracting data from server step.
cohortData <- getDbCohortData( connectionDetails = connDetails$dbms, cdmDatabaseSchema = "CDM.dbo", cohortDatabaseSchema = "SCRATCH.dbo", cohortTable = "COHORT", cohortConceptIds = 1)
connDetails$dbms object is a
createConnectionDetails() object of
I get the following error:
Error in paste("jdbc:sqlserver://", server, ";integratedSecurity=true", : argument "server" is missing, with no default
I don’t see any way I can pass it
I also tried using a
connect() object using
connectionDetails. But I get this error:
Error: 'dbGetQuery.ffdf' is not an exported object from 'namespace:DatabaseConnector'
FYI, this cohort is 5,318,577 patients. @Frank mentioned to me that once there was a
ffdf issue with too many rows.