Table of Contents


  1. Preface
  2. Part 1: Hadoop Integration
  3. Part 2: Databricks Integration
  4. Appendix A: Connections

External Hive Metastore Details

External Hive Metastore Details

You can specify the properties to enable the cluster to connect to a Hive metastore database that is external to the cluster.
You can use an external relational database like MySQL or Amazon RDS as the Hive metastore database. The external database must be on the same cloud platform as the cluster to create.
If you do not specify an existing external database in this dialog box, the cluster creates its own database on the cluster. This database is terminated when the cluster is terminated.
The following table describes the Hive metastore database properties that you configure:
Database Name
Name of the Hive metastore database.
Database Server Name
Server on which the database resides.
The database server name on the Azure web console commonly includes the suffix
. For example:
. You can specify the database server name without the suffix and Informatica will automatically append the suffix. For example, you can specify
Database User Name
User name of the account for the domain to use to access the database.
Database Password
Password for the user account.


We’d like to hear from you!