Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0681

...

Excerpt

Supported Relational Databases

The 

D s platform
 can natively connect to these relational database platforms. Supported Natively supported versions are the following:

  • Oracle 12.1.0.2
  • SQL Server 12.0.4
  • PostgreSQL 9.3.10
  • Teradata 14.10+

    Info

    NOTE: To enable Teradata connections, you must download and install Teradata drivers first. For more information, see Enable Teradata Connections.

Additional relational connections can be enabled and configured for the platform. For more information, see Connection Types.

Ports

For any relational source to which you are connecting, the 

D s node
 must be able to access it through the specified host and port value.

Please contact your database administrator for the host and port information.

Enable

This feature is enabled automatically. 

Info

NOTE: Disabling this feature hides existing relational connections.

Disable relational publishing

By default, relational connections are read/write, which means that users can create connections that enable writing back to source databases.

  • When this feature is enabled, writeback is enabled for all natively supported relational connection types. See Connection Types.
  • Depending on the connection type, the
    D s platform
    writes its data to different field types in the target database. For more information, see Type Conversions.
  • Some limitations apply to relational writeback. See Limitations below.

As needed, you can disable this feature.

Steps:

  1. D s config
  2. Locate the following parameter and set it to false:

    Code Block
    "webapp.connectivity.relationalWriteback.enabled": true,
  3. Save changes and restart the platform.

Publishing through relational connections is disabled.

Limitations

Info

NOTE: Unless otherwise noted, authentication to a relational connection requires basic authentication (username/password) credentials.

  • You cannot swap relational sources if they are from databases provided by different vendors. See Flow View Page.
  • There are some differences in behavior between reading tables and views. See Using Databases.

...