This content describes the configuration and management of Adapters. It is intended for database administrators and application
developers. Adapters enable clients to manage data from virtually any data source, and on any operating system, through the
use of SQL statements. This content is intended for all users who have configured any of the supported adapters for their
use.
The following Key Features are introduced in Release 7709/8205:
New Adapters:
- Adapter for Snowflake Cloud Data Warehouse. Provides JDBC access to data stored in the Snowflake Cloud through SQL query operations.
- Adapter for Stratio Crossdata. Provides access to data using the Stratio JDBC driver.
- Adapter for Microsoft SQL Server Analysis Services Tabular Data Model. Provides access to Analysis Services data sources that are deployed using the Microsoft SQL Server Analysis Services Tabular
protocol, whose underlying architecture is an in-memory columnar database.
- Adapter for Python. The Adapter for Python defines a connection to the Python interpreter for executing user-written Python scripts that generate
calculated fields (WebFOCUS Computes). These fields can be used in WebFOCUS Workbooks, WebFOCUS InfoGraphics, charts, reports,
dashboards, and WebFOCUS portals.
Enhancements to Existing Adapters:
- Adapter for REST. The OAuth 2.0 authentication protocol for granting access to REST APIs is now supported for the Adapter for REST.
- Adapter for Delimited Files. The synonym creation parameters screen for delimited files now provides an option for indicating the number of rows that
need to be skipped before the header row.
- Adapter for Microsoft SQL Server OLE DB. The configuration page for the Adapter for Microsoft SQL Server OLE DB now has a text box for adding additional connection
keywords.
- Adapter for Excel. Synonyms can now be automatically created in a crosstab format for data in Excel Worksheets.