Quality Gates -> Management Settings -> Data Sources -> RDBMS
Next quilliup RDBMS Data Sources can use Kerberos for connection: Hadoop/Hive, MSSQL, Teradata, Impala.
In order to add a new Data Source connection to the system, go to Data Sources grid,
click "Add Data Source" and fill in all needed details:
For example, Hadoop connection:
Name - choose name for the Data Source. It's recommended to choose a name according to the relevant system and not to include the environment (e.g. dev/prod).
Driver - choose HADOOP from the list of the drivers.
Use Kerberos for connection - when marking this check box, the connection details will be based on “Kerberos Details” defined in "System Admin -> System Settings -> General Settings -> System Properties -> Kerberos Details".
Link to detailed System Properties manual: System Properties
Host - IP address or host name for connection server.
Port - relevant port number.
Username - username that will be used for DB connection. It is highly recommended to provide a designated user to the application.
Password - user's password for DB connection.
Database name - relevant DB name that will be used for connection.
Filter by - filter will narrow down the tables list within the connection. Application client is limited to get a list of tables under the connection up to 5000. If your connection accedes that number of tables, you should use the filter and create designated connection (e.g. by schema or prefix).
Test Connection - validates that the connection works properly and returns the correct number of tables.
Assigned Projects - the Data Source must be assigned to relevant Project(s).
Comments
0 comments
Please sign in to leave a comment.