1. Stream Analytics Documentation
  2. Manage
  3. References
  4. Create References
  5. Creating a Database Reference

4.3.1.2 Creating a Database Reference

To create a Database reference type:

  1. On the Catalog page, click Create New Item.
  2. Hover the mouse over Reference and select Database from the submenu.
  3. On the Type Properties screen, enter the following details:
    • Name: Enter a unique name for the reference. This is a mandatory field.
    • Display Name: Enter a display name for the reference. If left blank, the Name field value is copied.
    • Description
    • Tags
    • Reference Type: The selected reference is displayed.

  4. Provide details for the following fields on the Source Details page and click Next:

    • Connection: Select the connection for the database reference.

    • Enable Caching: Select this option to enable caching. Ignite cache is the default cache for cache-enabled references. So before deploying a pipeline using cache-enabled references, you have to start the cache cluster from the System Settings tab.

      Note:

      The Enable Caching option is not supported in the GGSA marketplace instance.

    • Caching Scheme: Select the cache type from the drop-down list.

      In a Partitioned Cache the data is partitioned among all the machines of the cluster.

      In a Replicated Cache the data is fully replicated to every member of the cluster. Use Replicated Cache when the number of cache entries are relatively low and do not need to be updated often.

    • Expiry Delay: The duration delay from last update that the entries will be kept by the cache before being marked as expired. Any attempt to read an expired entry will result in a reloading of the entry from the configured cache store. This field is enabled only when caching is enabled.

  5. Provide details for the following fields on the Shape page and click Save:

    • Shape Name: Select a shape that you want to use for the reference

When the datatype of the table data is not supported, the table columns do not have auto generated datatype. Only the following datatypes are supported:

  • numeric

  • interval day to second

  • text

  • interval year to month

  • timestamp (without timezone)

  • date time (without timezone)

    Note:

    The date column cannot be mapped to timestamp. This is a limitation in the current release.