Using an Existing Schema

You can configure the connector to use a schema definition saved in the database or in a local JSON file.

You provide this information to the connector in the connection URL. For more information about the syntax of the connection URL, see Building the Connection URL

To use an existing schema definition stored in a local file:

  • Set the LocalMetadataFile property to the full path and name of the JSON file containing definition the schema that you want to use, and then connect to the database.

To use an existing schema definition stored in a database table:

  1. Set the MetadataDatabaseTable property to the name of the table containing the schema definition that you want to use.
  2. Specify values for the MetadataReadUnits and MetadataWriteUnits properties.

    3. Important:

    You must specify values for MetadataReadUnits and MetadataWriteUnits. However, specifying a different number of read or write units for an existing table does not update the table. These values are set when the table is created.

  3. Connect to the database.

Related topics