Configuring the Adapter for EXASol

How to:

Reference:

Configuring the adapter consists of specifying connection and authentication information for each of the connections you want to establish.

Procedure: How to Configure the EXASol Adapter

You can configure the adapter from either the Web Console or the Data Management Console.

  1. From the Web Console sidebar, click Connect to Data.

    or

    From the Data Management Console, expand the Adapters folder.

    In the DMC, the Adapters folder opens. In the Web Console, the Adapters page opens showing your configured adapters.

  2. In the Web Console, click the New Datasource button on the menu bar and find the adapter on the drop-down list or, in the DMC, expand the Available folder if it is not already expanded.
    On the Web Console, you can select a category of adapter from the drop-down list or use the search option (magnifying glass) to search for specific characters.
  3. Right-click EXASol and click Configure.
  4. Select edasprof from the drop-down menu to add this connection for all users, or select a user profile.
  5. Click Test. You should see a sample list of objects stored in the EXASol data source you are accessing.
  6. Click Configure.

Reference: EXASol Adapter Configuration Settings

The Adapter for EXASol is under the SQL group folder.

Connection name

Logical name used to identify this particular set of connection attributes. The default is CON01.

System

Is the name of the machine where the EXASol in-memory database is running. The basic syntax is host:port

Security

There are three methods by which a user can be authenticated when connecting to a database server:

  • Explicit. The user ID and password are explicitly specified for each connection and passed to the database, at connection time, for authentication.
  • Password Passthru. The user ID and password received from the client application are passed to the database, at connection time, for authentication.
  • Trusted. The adapter connects to the database using the database rules for an impersonated process that are relevant to the current operating system.
User

Primary authorization ID by which you are known to the data source.

Password

Password associated with the primary authorization ID.

Additional connection string keywords (optional)

Can be used to add options to the connection string, for example, EXASCHEMA.

Select profile

Select a profile from the drop-down menu to indicate the level of profile in which to store the CONNECTION_ATTRIBUTES command. The global profile, edasprof.prf, is the default.

If you wish to create a new profile, either a user profile (user.prf) or a group profile if available on your platform (using the appropriate naming convention), choose New Profile from the drop-down menu and enter a name in the Profile Name field (the extension is added automatically).

Store the connection attributes in the server profile (edasprof).

Reference: Configuring an Auxiliary Connection for Extended Bulk Load

Using Extended Bulk Load with the EXASol adapter requires that intermediate data files are transferred to a server where the EXASol sever can access them.

For this adapter, you must enable the Flat File adapter and create a connection using FTP or SFTP to the server. From the DMC or Web Console, perform the following steps:

  1. Expand the Adapters folder or click the Adapters tab.
  2. Right-click Flat File and click Add Connection.
  3. In the Connection Name box, type the name of the connection for your EXASol server. The connection names must match.
  4. From the Protocol drop-down menu, select FTP or SFTP.
  5. In the Host Name box, type the name of the host for your server.

    Note: For EXASol it should not be the system where it is running, rather it should be some other system that it can access using FTP.

  6. In the Initial Directory box, type the name of a directory that you have write access to, such as your home directory.
  7. In the User and Password boxes, type your user ID and password.
  8. Click Test.

    The following message should appear: User has read access to the FTP server.

    Note: Although not tested at this time, you must also have write access. A future release will add testing for write access.

  9. Click OK.
  10. Click Configure.
  11. Click Close.

WebFOCUS

Feedback