1. Administrator's Guide
  2. Tools and Utilities
  3. Using Oracle NoSQL Database Migrator
  4. Sources and Sinks
  5. Parameters

Parameters

The NoSQL Database Migrator requires a configuration file where you define all the parameters to perform the migration activity. A few parameters are common across several sources and sinks. This topic provides a list of these common parameters. For the list of other parameters that are unique to individual sources or sinks, see the corresponding configuration template sections.

Common Configuration Parameters

The following are the common configuration parameters. See the individual configuration template sections for examples.

bucket

  • Purpose: Specifies the name of the OCI Object Storage bucket, which contains the source/sink objects.

    Ensure that the required bucket already exists in the OCI Object Storage instance and has read/write permissions.

  • Data Type: string
  • Mandatory (Y/N): Y

chunkSize

  • Purpose: Specifies the maximum size of a chunk of table data to be stored at the sink. The value is in MB. During migration, a table is split into chunkSize chunks and each chunk is written as a separate file to the sink. A new file is created when the source data that is being migrated exceeds the chunkSize value.

    If not specified, defaults to 32MB. The valid value is an integer between 1 to 1024.

  • Data Type: integer
  • Mandatory (Y/N): N

credentials

  • Purpose: Specifies the absolute path to a file containing OCI credentials. The NoSQL Database Migrator uses this file to connect to the OCI service such as Oracle NoSQL Database Cloud Service, OCI Object Storage, and so on.

    The default value is $HOME/.oci/config

    See Example Configuration for an example of the credentials file.

    Note:

    You must specify either credentials or useInstancePrincipal parameter in the configuration template.
  • Data Type: string
  • Mandatory (Y/N): N

credentialsProfile

  • Purpose: Specifies the name of the configuration profile to be used to connect to the OCI service such as Oracle NoSQL Database Cloud Service, OCI Object Storage, and so on. User account credentials are referred to as a profile.

    If you do not specify this value, the NoSQL Database Migrator uses the DEFAULT profile.

    Note:

    This parameter is valid only if the credentials parameter is specified.
  • Data Type: string
  • Mandatory (Y/N): N

endpoint

  • Purpose: Specifies one of the following:
    • The Service endpoint URL or the Region ID for the OCI Object Storage service.

      For the list of OCI Object Storage service endpoints, see Object Storage Endpoints.

    • The Service endpoint URL or the Region ID for the Oracle NoSQL Database Cloud Service.

      You can either specify the complete URL or the Region ID alone. For the list of data regions supported for Oracle NoSQL Database Cloud Service, see Data Regions and Associated Service URLs in the Oracle NoSQL Database Cloud Service document.

  • Data Type: string
  • Mandatory (Y/N): Y

format

  • Purpose: Specifies the source/sink format.
  • Data Type: string
  • Mandatory (Y/N): Y

namespace

  • Purpose: Specifies the namespace of the OCI Object Storage service. This is an optional parameter. If you don't specify this parameter, the default namespace of the tenancy is used.

  • Data Type: string
  • Mandatory (Y/N): N

prefix

  • Purpose: The prefix acts as a logical container or directory for storing data in the OCI Object Storage bucket.

    • Source configuration template: If the prefix parameter in specified, all the objects from the directory named in the prefix parameter are migrated. Else, all the objects present in the bucket are migrated.
    • Sink configuration template: If the prefix parameter is specified, a directory with the given prefix is created in the bucket and the objects are migrated into this directory. Else, the table name from the source is used as the prefix. If any object with the same name already exists in the bucket, it is overwritten.

    For more information about prefixes, see Object Naming Using Prefixes and Hierarchies.

  • Data Type: string
  • Mandatory (Y/N): N

requestTimeoutMs

  • Purpose: Specifies the time to wait for each read/write operation from/to the store to complete. This is provided in milliseconds. The default value is 5000. The value can be any positive integer.

  • Data Type: integer
  • Mandatory (Y/N): N

security

  • Purpose: Specifies the absolute path to the security login file that contains your store credentials if your store is a secure store. For more information about the security login file, see Configuring Security with Remote Access in the Administrator's Guide.

    You can use either password file based authentication or wallet based authentication. However, the wallet based authentication is supported only in the Enterprise Edition (EE) of Oracle NoSQL Database. For more information on wallet-based authentication, see Source and Sink Security.

    The Community Edition(CE) edition supports password file based authentication only.

  • Data Type: string
  • Mandatory (Y/N): Y, for a secure store

type

  • Purpose: Identifies the source/sink type.
  • Data Type: string
  • Mandatory (Y/N): Y

useInstancePrincipal

  • Purpose: Specifies whether or not the NoSQL Database Migrator tool uses instance principal authentication to connect to the OCI service such as Oracle NoSQL Database Cloud Service, OCI Object Storage, and so on. For more information on Instance Principal authentication method, see Source and Sink Security.

    The default value is false.

    Note:

    • The authentication with Instance Principals is supported only when the NoSQL Database Migrator tool is running within an OCI compute instance, for example, the NoSQL Database Migrator tool running in a VM hosted on OCI.
    • You must specify either credentials or useInstancePrincipal parameter in the configuration template.
  • Data Type: boolean
  • Mandatory (Y/N): N