Adapter Enhancements

In this section:



x
SQL Adapters

Release 7.7 Version 05

All SQL Adapters

Adapter for DB2: Truncate Table Added to Existing Table Target Properties. A Prior to Load option has been added for existing tables in DB2 on Windows, UNIX, and zSeries platforms. The Truncate Table target property removes all rows from the target table without logging.

Adapter for EMC Greenplum. The Adapter for EMC Greenplum has been introduced in this release and is available as a named adapter on the Web Console in the SQL folder.

Adapter for Informix: Truncate Table With Prior to Load Option Supported. When Truncate table is selected as the Prior to Load option on a data flow target, the SQL generated now produces the code to execute TRUNCATE TABLE on the Informix database.

Adapter for JBoss Application Server. The JBoss Application Server is now supported, and the Adapter for JBoss is available as a named adapter on the Web Console in the SQL folder. It replaces the Adapter for MetaMatrix.

Adapter for Microsoft SQL Server: Primary Key Order Respected by the Create Synonym Process. A new Create Synonym mechanism ensures that a Primary Key is prioritized, regardless of how and in what order it was created in the DBMS.

Adapters for Microsoft SQL Server and Sybase: TSTOPACK Function: Converting a Microsoft SQL Server or Sybase Timestamp Column to Packed Decimal. Microsoft SQL Server and Sybase have a data type called TIMESTAMP. Rather than containing an actual timestamp, columns with this data type contain a number that is incremented for each record inserted or updated. The value is stored in Binary(8) or Varbinary(8) format in the table, but is returned as a double-wide alphanumeric column (A16). You can use the TSTOPACK function to convert the timestamp value to packed decimal.

Adapter for Oracle

Adapter for PostgreSQL: Support for SERIAL Columns Added. The adapter now supports PostgreSQL tables with SERIAL columns. The column that is produced by Create Synonym is identified as auto increment and read-only.


Top of page

x
OLAP Adapters

Release 7.7 Version 05

Adapter for SQL Server Analysis Services


Top of page

x
Procedure Adapters

Release 7.7 Version 05

Adapter for REST. The Adapter for REST has been introduced in this release and is available as a named adapter on the Web Console in the Procedures folder.

Adapter for Web Services.


Top of page

x
Sequential and Indexed Adapters

Release 7.7 Version 05

Adapter for Excel (via Direct Retrieval): Creating Synonyms for Named Ranges. When creating a synonym and after selecting a workbook, you can now see a list of all the named ranges in the workbook. You will be able to create a synonym for any of those named ranges.


Top of page

x
DBMS Adapters

Release 7.7 Version 05

Adapter for iWay Adapter Framework (IWAF): Single Logon Support. When using the Adapter for iWay Adapter Framework (IWAF) for a connection, such as to salesforce.com, each operation generates a server logon. This could result in a large number of logon attempts. Now this situation can be handled with a single logon.


Top of page

x
Social Media Adapters

Release 7.7 Version 05


WebFOCUS