The can be configured to access data stored in relational database sources over JDBC protocol. When this connection method is used, individual database tables and views can be imported as datasets.
Supported Relational Databases
The can natively connect to these relational database platforms. Natively supported versions are the following:
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 must be able to access it through the specified host and port value.
Please contact your database administrator for the host and port information.
This feature is enabled automatically.
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: Unless otherwise noted, authentication to a relational connection requires basic authentication (username/password) credentials.
There are some differences in behavior between reading tables and views. See Using Databases.
Limitations on relational publishing:
When the relational publishing feature is enabled, it is automatically enabled for all platform-native connection types. You cannot disable relational publishing for Oracle, SQL Server, PostgreSQL, or Teradata connection types. Before you enable, please verify that all user accounts accessing databases of these types have appropriate permissions.
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.
Jobs for large-scale relational sources can be executed on the Spark running environment. After the data source has been imported and wrangled, no additional configuration is required to execute at scale.
NOTE: End-to-end performance is likely to be impacted by:
When the job is completed, any temporary files are automatically removed from HDFS.
For more information, see Run Job Page.
Relational database passwords are encrypted using key files: