Versions Compared

Key

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

Find here general information that is valid for all connections.

...

Info
titleINFO

Connections are a collection of data from different sources such as various types of files and databases. 

See Types of Data Supported for information about the types of data you can use with Datameer.

Once you create the connection, you can import data into it. See Importing Data to learn more.  

Info
titleINFO

If you want to create a connection for a database type such as DB2, MySQL, or Oracle, you need to add the appropriate database drivers to your Datameer X installation. To create a connection for a database type that you don't see listed in the file type list, you need to first add the appropriate database drivers to your Datameer X installation.

Viewing a Connection Details Page

Info
titleINFO

The 'Connection Details' page provides information of:

  • Connection name: e.g. 'Connection Tableau'
  • Description: if you inserted a description during the first configuration
  • Datastore usage: e.g. 'IMPORT_EXPORT'
  • Authentication Mode: e.g. 'TEMPORARY'
  • Url or Uri: connection URL, e.g. 'jdbc:mysql://localhost:3306/dap?tinyInt1isBit=false'
  • Transfer Protocol: e.g. 'Datameer X server filesystem'
  • userName: user name for authentication
  • password: password for authentication
  • Connection type: e.g. 'Database'
  • driverClassName: name of the driver e.g. 'com.mysql.jdbc.Driver'
  • Owner: e.g. 'admin'
  • shared with: the group with the needed right to view, edit or run a connection and your personal user rights, e.g. 'You are allowed to view and edit.'

INFO: Not all entries are available for all connections.

INFO: For connections where authentication options are available (JDBC, SSH and SFTP connections), the valid one out of the two authentication modes is displayed: 'TEMPORARY' or 'PROVIDED'. For JDBC/ MySQL connections, the valid one out of three authentication modes is displayed: 'TEMPORARY', 'PROVIDED' or 'SESSION_BASED'. 'SESSION_BASED' is only displayed when the flag '-Denable.authenticationOnJobRun=true' is set.

...

  1. Right-click on the connection and select "Open"The connection settings tab opens.
  2. Click "Next"The tab 'Connection Details' opens.
  3. Change the entries according to your needs and confirm with "Next"The 'Save' tab opens.
  4. If needed, change the description. Confirm with "Save". Editing the connection is finished.

Renaming a Connection

To rename a connection:

  1. Right-click on the connection and select "Rename"The connection name appears in the edit mode directly in the 'File Browser'.
     
  2. Enter the new connection name and confirm with "Enter"The new connection name is saved. 

...