createCollection

Produce an user named collection and store in the user defined database. This operation will only create the collection if it doesn't already exist in the database.

Environment/Instance Properties

Property NameProperty CodeRequiredDescription
Oracle Database URLFDORA_URLYesDatabase connection URL. For example,
  • jdbc:oracle:thin:@HOSTNAME:PORT:SID
  • jdbc:oracle:thin:@//HOSTNAME:PORT/SERVICENAME
SODA UsernameFDSODA_USERNAMEYesSODA enabled schema to manage SODA collections.
SODA PasswordFDSODA_PASSWORDYesPassword for SODA Username.
JDBC Driver PathFDJDBC_DRIVER_PATHYes

Location of JDBC driver file. For example,

/u01/app/oracle/product/12.1.0/dbhome_1/jdbc/lib/ojdbc6.jar

Project Properties

Property NameProperty CodeRequiredDescription
Collection NameFDSODA_COLLECTION_NAMEYesThe name of the new collection to be created and stored in the database. Can define more than one collection to be added as a comma separated value. The input collection name will take precedence.

Inputs

Input NameInput CodeRequiredDescription
Collection NameFDSODA_INP_COLLECTION_NAMEYesThe name of the new collection to be created and stored in the database. Can define more than one collection to be added as a comma separated value. Take precedence over project property.

Outputs

Output NameDescription


Artifacts 

This operation consumes artifacts from the artifacts repository.

Endpoint Selection 

This operation will select all available endpoints associated to the environment/instance.

Endpoint Execution 

This operation will execute on any one of the selected endpoints and will be random in the determination of which one.

Special Considerations

This operation will handle cases where an outdated version of SODA is installed on FlexDeploy.