Like what you see? Have a play with our trial version.

Versions Compared

Old Version 25

changes.mady.by.user user-3484a

Saved on

compared with

New Version Current

changes.mady.by.user Nadine Hinojosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Section


Column
width40


Column


NameDescription

Connection Method

Shows the type of connection that was specified when creating a connection. Cannot be changed.

Authentication Adapter 

Specify an authentication method for the database adapter. Options include:

  • Standard authentication: connects to the database with a specified user. The user details need to be provided with this option. Also employs the user of the connection pool by establishing permanent connections, i.e, they are not deleted after use.
  • Pass-through authentication: connects to the database using the security implemented at the database, i.e. there is no need to specify a database user account here. Creates a new connection for each query, while honouring the connection pool limit.
  • Standard authentication (no pooling): similar to the standard authentication that connects to the database using a specified user. However the connection pool works differently: connections are still created as per the pool’s limits, but idle connections are deleted, only to be created again when needed./=

Database Type

Change the database type. This is only suitable for situations where your data has moved to a different source. Ensure that the new data source has the same table structure as the previous one.

Database Mode*

Select the mode for your database.

Database Name*

Specify or update the name for your database.

Username

Username of the user account to connect to the database with.

Password

Allows to you change the saved password to the database account, by clicking on the Click here to change password link.

Schema

Specify the schema to be used with this database connection, if your database contains multiple schemas. 

Isolation Level

Choose an isolation level to use for this database connection; this refers to the degree to which a transaction is isolated from being modified by transactions. Options include:

Note

The supported levels of isolation depend on your database type.

 

  • Read Uncommitted: Includes modified data that is not yet committed in the database when running transactions. Not ideal, as the uncommitted data might get deleted or modified further.
  • Read Committed: Only reads data that has been committed. Ignores uncommitted data.
  • Repeatable Reads: Does not read modified data that has not been committed, however includes new values even if they’re uncommitted.
  • Serializable: Treats transactions as they occur, i.e. serially rather than concurrently.

Learn more about this here.

*These are database specific parameters.



...

This section allows you to define some general settings related to the use of this data source.

Section


Column
width40

Image RemovedImage Added


Column


Name

Description

Max rows returned

Enable this toggle to limit the total rows returned by a database query. This ensures system performance is not compromised in case a query returns a large result. 

Max rows returned (limit)

Specify a maximum number of rows that can be returned from a database base, if the above parameter is enabled. This limit can also be viewed and modified in the report builder.

Custom Row Limit

Specify maximum row limit for specific users or groups to restrict or extend Max Rows Returned. This limit overrides all other row limits.

Analysis max rows returned

Enable this toggle to limit the total rows returned by a database query during automated analysis.

This configuration works similarly to the one above, however it is only specific to queries performed during automated analysis, i.e for Signals and Assisted Insights.

Analysis max rows returned (limit)

Specify a maximum number of rows that can be returned from a database base, if the above parameter is enabled. This limit can also be viewed and modified in the report builder when editing an auto analysis report.

Writable

Enable this to make your database writable so data can be saved into it. This is suitable for Caching and Data Transformations that require the result to be outputted to a source. 

Note: This is not supported by all databases. Yellowfin performs a test after saving to ensure your database is writable.

CSV default

Choose this data source to be the default one to load CSV data into. This can only be possible if the source is writable. Note that only a single source can be assigned as the default at a time.

Time zone

Select a suitable time zone for this data source connection. This is ideal for scheduling.

Broadcast

Enable this to permit broadcasting data based on this data source connection. Content broadcasting will only be supported, if this is enabled.

Subscribe 

Enable this to permit personal broadcasting data based on this data source connection.

Data profiling 

Enable this to permit data profiling at the view level.

Inherit Access Filters from client source

Enable this to inherit access filters configured in client organizations. This is suitable if your client org has its own database repository, and you have access filters to restrict data access.





Views & Content

This allows you to view a list of content that has been created based on this data source connection.

...