<< Click to Display Table of Contents >> Current:  Create Connection  Connection Properties

Data source connection can configure connection properties and advanced properties. This chapter will introduce each configuration property of data source connection one by one.

 

❖Connection parameter

[Select Connection]The database type selected in the homepage is displayed by default. You can also select another database type, for example, ORACLE，DB2， ACCESS and VERTICA. The database provided by Yonghong Z-Suite is DATA MART.

[Driver] You can manually write down or select the required driver type. For example, the driver for Access is sun.jdbc.odbc.JdbcOdbcDriver. The driver provided by Yonghong Z-Suite is  g5.dc.jdbc.GDriver.

[URL] URL of the data source.In the URL fill box, the items are displayed directly to the user. Users can use the data source directly only by modifying the correct server address.

[Fix Time Zone] time zone in which data is stored in database If no time zone is specified when data is being stored in database, it is unnecessary to set this parameter. If you specified the time zone when you saving the data, you need to select the corresponding time zone to convert data.

[Server Login] There are two ways: Username and Password, No Authentication. When the database sets access permissions, the user needs to access the current database using the user name and password.

[User] The username required for connecting the database.The DATA MART data source is the user name for logging in to the system.

[Password] The password required for connecting the database.The DATA MART data source is the password for logging in to the system.

[Database]Control the catalog shown under the data source. When you input a catalog, the data source displays only the specified one, and if not specified here, all catalog will be displayed.

[Schema] Control the schema shown under the data source. When you select a schema, the data source displays only the specified one, and if not specified here, all schema will be displayed.

[Add Basic Properties]The data source can be added in the writing URL when establishing the connection. Some basic connection attributes cannot be added through the URL when establishing the connection. You can customize the attributes during the basic connection.

[Key File Path] KeyTab file path. For example: /opt/xxx/user.keytab .

[Krb5 File Path] Krb5 file path. The name of the Krb5 file in the Linux environment is Krb5.conf; the name in the Windows environment is Krb5.ini. Krb5 files are generally placed in a default location so that you do not need to configure this property. If the customer does not provide this file, they may have been placed in the default location. In general, the default location of Windows is C:\Windows\Krb5.ini or C:\winnt\Krb5.ini; the default location of Linux is /etc/Krb5.conf or /etc/krb5/krb5.conf.

[Jaas File Path] Jaas file path. This configuration file is generally used for Zookeeper security authentication. For example: /opt/xxx/jaas.conf .

 

❖Advanced Settings

Some non - mandatory properties of the data source are put into the advanced settings, and the mouse can trigger the expansion and recovery when the mouse clicks, and the new and saved reopens, all of which are retracted.If the driver fills in the database driver included in the product, the content of the advanced properties will change depending on the driver.

[Turn on Connection Pool]Configure the Turn on Connection Pool. Click the check box to enable the connection pool configuration.

[Effective Connection Time]The effective connection time of the data source. The default is 2 hours. After the configuration is 2 hours, the connection usage of more than 2 hours will not be placed in the connection pool.

[Max Connection]The maximum number of connections for this data source. The default is 30.

[Quote]Defines whether the database execution sql needs to be escaped, whether the back or double quotes are used, and the default is double quotes.

[Fetchsize] controls the number of lines of data that JDBC reads each time. The default is 100. Every time JDBC reads data, it will be cached in memory. It is recommended to configure it properly to ensure sufficient memory.

[Transaction Isolation Level] (new advanced attribute in version 8.8) Controls the transaction isolation level of the data source connection. This attribute contains six option values:

JDBC Default Value (selected by default): Use JDBC processing method;

Close Transaction: Execute the query without enabling the transaction;

Read Dirty Data: Allows to read the data being updated by other transactions;

Prevent dirty data from being read: If the read data is locked, it will wait;

Repeatable read: The data will be locked when reading data to avoid other transaction updates;

Serial: Transactions are executed one by one.

The relationship between transaction isolation level and conn.transaction.level:

1. The transaction isolation level is set for a single data source, and conn.transaction.level is a global property set in bi.properties.

2. Upgrade the version before 8.8 to 8.8 and later: If the property conn.transaction.level is not configured in bi.properties, the transaction isolation level in the advanced properties of the upgraded SQL data source is selected to prevent reading of dirty data; if bi.properties The conn.transaction.level is configured in the upgrade. After the upgrade, the value of this attribute is used to match the selected item of the transaction isolation level in the advanced properties of the data source. For the corresponding value, please refer to the table below.

[Turn on limit]Click Turn on limit, when the data is previewed, the limit will be executed in SQL.

[AutoCommit] Set the auto-commit mode of the data source connection to the given state. If the connection is checked, all its SQL statements will be executed and submitted as a single transaction. Conversely, its SQL statements will be aggregated into the transaction until the commit method or rollback method is called. It is unchecked by default.

[Show Column Alias]After checking,the comment of the column in the database will be obtained as an alias on the dataset side. By default, it is checked when it is newly created.

[Alias Type]The Teradata database has a comment and a title. You can choose to get the comment or title of the column in the database as an alias on the dataset side.

[Charset Conversion]Database Charset is the original database charset.Convert Charset is converted to charset. These two items can be set to transform the charset when the charset is inconsistent.

[DB Character Sets]Database Charset is the original database charset.Convert Charset is converted to charset. These two items can be set to transform the charset when the charset is inconsistent.

[Database version] After the data source test is successfully connected, you can directly obtain the major version number of the data source, and there is a gray text indicating the returned major version number.

[Agent Port]The Essbase Agent port number defaults to 1423. If the database is not installed with port 1423, you need to specify the correct port here to test the connection.

[Add Adavanced Properties] The data source is open to provide the interface for configuring the database configuration properties. Clicking the Add Attributes icon will add a line "Name" and "Value" to the advanced attributes for the user to customize. You can manually add multiple database attribute.

[Name] Attribute name of the database to be configured.

[Value] The value of the database property to be set.

[Visible to users have write permission] Assume that user1 has only read permission to the data source and has read or read/write permission  to the data sets relying on the data source. If you select the option, login as user1, and access the page for data set creation, "Visible to users have write permission" is displayed when you open the data source. If you open a data set that relies on the data source, the data source information is collapsed and cannot be expanded.Description: Yonghong Desktop does not support the property.