Supported Relational Databases
Additional relational connections can be enabled and configured for the platform. For more information, see Connection Types.
For any relational source to which you are connecting, the
Please contact your database administrator for the host and port information.
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:
Disable relational publishing
By default, relational connections are read/write, which means that users can create connections that enable writing back to source databases.
As needed, you can disable this feature.
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.
- You cannot ad-hoc publish to a relational target. Relational publishing is only supported through the Run Job page.
- You write to multiple relational outputs from the same job only if they are from the same vendor.
- For example, if you have two SQL Server connections A and B, you can write one set of results to A and another set of results to B for the same job.
- If A and B are from different database vendors, you cannot write to them from the same job.