Adapters

This content describes how to use the Web Console to configure and use adapters. It is intended for server administrators, database administrators, and application developers.

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.
• Adapter for Salesforce.com. Bulk Query can now be enabled for the Adapter for Salesforce.com, providing a more efficient way to query large data sets and reduce the number of API requests.