Supported Relational Databases

The 

• 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 

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

Enable

This feature is enabled automatically. 

To disable:

To prevent users from connecting to relational datasources for importing datasets and writing results, please complete the following configuration changes:

1. D s config
   method ws

2. Locate the following setting:
   
   

   Code Block
   Connectivity feature

   
   

3. Set this value to Disabled.

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.

NOTE: Writing back to the database utilizes the same user credentials and therefore permissions as reading from it. Please verify that the users who are creating read/write relational connections have appropriate access.