datarobot (version 2.16.0)

SetupProjectFromOracle: Function to set up a new DataRobot project using data from Oracle table (deprecated)

Description

This function is deprecated. Use SetupProjectFromDataSource instead.

Usage

SetupProjectFromOracle(dbq, table, username, fetchBufferSize = NULL,
  projectName = NULL, password = NULL, encryptedPassword = NULL,
  maxWait = 60 * 60)

Arguments

dbq

character. tnsnames.ora entry in host:port/sid format

table

character. The name of the table to fetch.

username

character. The username to use to access the database

fetchBufferSize

integer. Optional. If specified, specifies the size of buffer that will be used to stream data from the database. Otherwise will use DataRobot default value.

projectName

character. Optional String specifying a project name.

password

character. Optional. The plaintext password to be used to access MySQL database. Will be first encrypted with DataRobot. Only use this or encryptedPassword, not both.

encryptedPassword

character. Optional. The encrypted password to be used to access MySQL database. Only use this or password, not both.

maxWait

integer. The maximum time to wait for each of two steps: (1) The initial project creation request, and (2) data processing that occurs after receiving the response to this initial request.

Value

This function returns a list with the following four components:

projectName

The name assigned to the DataRobot project

projectId

The unique alphanumeric project identifier for this DataRobot project

fileName

The name of the CSV modeling file uploaded for this project

created

Character string containing the time and date of project creation

Details

This function returns the projectName specified in the calling sequence, the unique alphanumeric identifier projectId for the new project, the name of the modeling dataset uploaded to create this project, and the project creation time and date.

Examples

# NOT RUN {
  SetupProjectFromOracle(dbq = 'localhost:4001/sid',
                         table = 'myTable',
                         user = 'oracleUser')
# }