The following supported environments have been added to TIBCO ActiveMatrix (R) Adapter for Database 7.0.0 since its general availability. Please refer to the attached amended readme for the details regarding these additions.

- TIBCO ActiveMatrix(R) Proxy Implementation Type for TIBCO Adapters 1.0.0

- Cloud Database: 

     Amazon RedShift

     Amazon RDS for MySQL (MySQL 5.1, 5.5 and 5.6 (Community Edition) with InnoDB)

     Amazon RDS for SQL Server (Microsoft SQL Server 2008 R2, SQL Server 2012)

     Amazon RDS for Oracle (Oracle Database 11gR2)

     Microsoft Azure SQL Server (Windows Server 2012 R2)

     Oracle On Demand

- Microsoft Windows Server 2012

- Microsoft Windows Server 2012 R2

- MySQL Community Server version 5.5 and 5.6

- Teradata RDBMS V14.10

- Oracle Database 12c 12.1.x

- Oracle Database 12c RAC 12.1.x

- Oracle Enterprise Linux 5.x, 6.x

-TIBCO Runtime Agent(TM) 5.9.0 - 5.9.x

-TIBCO ActiveMatrix BusinessWorks(TM) 5.12.0

-TIBCO ActiveMatrix BusinessWorks(TM) 5.13.x

-TIBCO ActiveMatrix BusinessWorks(TM) 6

-TIBCO Database Drivers Supplement 2.0.1

-TIBCO ActiveMatrix Adapter Framework 1.1.2 - 1.2.0

-TIBCO Runtime Agent(TM) 5.10.x

-Red Hat Enterprise Linux 7.x

Any limitations and restrictions and known issues are detailed below

Please note that any new features or functionality available with these additional environments are not necessarily supported by TIBCO ActiveMatrix (R) Adapter for Database 7.0.0.  Please contact Support if there are any questions regarding whether a certain feature is supported by TIBCO ActiveMatrix (R) Adapter for Database 7.0.0

================================

TIBCO ActiveMatrix(R) Proxy Implementation Type for TIBCO Adapters 1.0.0

[Added 21-Nov-2013]

Limitations and Restrictions: None

Configuration Changes: 

For details on using TIBCO ActiveMatrix (R) Adapter for Database 7.0.0 with TIBCO ActiveMatrix(R) Proxy Implementation Type for TIBCO Adapters 1.0.0, please refer to TIBCO ActiveMatrix (R) Adapter for Database 7.0.0 product documentation.

Known Issues:

AADB-4530. Need TIBCO ActiveMatrix(R) Proxy Implementation Type for TIBCO Adapters to change code.

================================

Cloud Database: 

[Added 21-Nov-2013]

     Amazon RedShift

     Amazon RDS for MySQL (MySQL 5.1, 5.5 and 5.6 (Community Edition) with InnoDB)

     Amazon RDS for SQL Server (Microsoft SQL Server 2008 R2, SQL Server 2012)

     Amazon RDS for Oracle (Oracle Database 11gR2)

     Microsoft Azure SQL Server (Windows Server 2012 R2)

     Oracle On Demand

Limitations and Restrictions: None

Configuration Changes: None

Known Issues: 

For Amazon Redshift,

*********************************************************************

AADB-5214: When run Sub Load Balance with three instances, two instances will stop and throw exception:org.postgresql.util.PSQLException: ERROR: 1023

AADB-5231: ADB7.0 don't support Bytea/Time Data types for Amazon Redshift DB

(database limitation, Amazon Redshift doesn't support)

AADB-5186: The Opaque Exception table cannot be created

(database limitation, Amazon Redshift doesn't support Bytea data type and opaque table has Bytea column)

AADB-5199: The Sub feature of Pre Commit Stored Procedure doesn't work with Amazon Redshift DB

(database limitation, Amazon Redshift doesn't support stored procedure)

AADB-5185: The publisher service cannot be created successfully

(database limitation, Amazon Redshift doesn't support trigger, index)

AADB-5200: The RPC custom service doesn't work with Amazon Redshift DB

(database limitation, Amazon Redshift doesn't support stored procedure or function

*********************************************************************

For Microsoft Azure,

*********************************************************************

AADB-5127: The "Upsert" is invalid in Azure, Reason: Azure requires clustered index

Workaround: For pub service, we need to use workaround to generate DB objects in database, including publishing table, trigger and indexes.

Uncheck the checkbox "Write to Database on Save" in the adapter instance configuration After configuring the publication service, find the SQL script generated for the instance, modify it as follow:

-Comment or delete the "grant" statement in the script, for example, --GRANT INSERT ON P_yswtest TO tibco-user@tm7n425uby --go -Modify the index statement for "ADB_SEQUENCE" column, add CLUSTERED keyword between UNIQUE and INDEX, for example, CREATE UNIQUE CLUSTERED INDEX IDX1_P_yswtest ON P_yswtest (ADB_SEQUENCE) -Execute all the modified SQL script in SQL server client tool, for example, SQL server management studio -Test the pub service

AADB-5135: The ADB will pop up exception if does not set clustered index exception table or opaque exception table(Azure required clustered index)

Workaround: For the sub service, if you want to use the exception table/child exception table/opaque exception table, you also need to follow the workaround below:

-Uncheck the checkbox "Write to Database on Save" in the adapter instance configuration -After configuring the subscription service, find the SQL script generated for the instance, modify it as follow:

-Add clustered index for exception/opaque exception table, for example:

create clustered index yswtest1_excp_cluster_idx on yswtest1_excp (ADB_TRACKINGID) go where yswtest1_excp is the exception table name, yswtest1_excp_cluster_idx is the constraint name

*********************************************************************

================================

Microsoft Windows Server 2012

[Added 14-May-2014]

Limitations and Restrictions: None

Configuration Changes: None

Known Issues: None

================================

Microsoft Windows Server 2012 R2

[Added 22-Aug-2014]

Limitations and Restrictions: None

Configuration Changes: None

Known Issues: None

================================

================================

Database Teradata 14.10

[Added 31-Oct-2014]

Limitations and Restrictions: None

Configuration Changes: None

Known Issues: None

================================

================================

TIBCO ActiveMatrix BusinessWorks(TM) 5.12.0

[Added 31-Oct-2014]

Limitations and Restrictions: None

Configuration Changes: None

Known Issues: None

================================

TIBCO Runtime Agent(TM) 5.9.0

[Added 31-Oct-2014]

Limitations and Restrictions: None

Configuration Changes: None

Known Issues: None

================================

MySQL Community Server version 5.5 and 5.6

[Added Feb-05-2015]

Limitations and Restrictions: 

Support of MySQL Community Edition requires native MySQL Community Edition JDBC drivers. 

Configuration Changes: 

In the Configuration tab, select MySQL in the Vendor list. In the Design-time Connection tab the JDBC Driver property should be changed to 'com.mysql.jdbc.Driver', and the JDBC URL property should be changed to 'jdbc:mysql://<servername>:3306/<databasename>'. The counterparts in the Run-time Connection tab are the same as these properties.

Known Issues:

Since the default transaction isolation level on MySQL Community Edition is Repeatable Read, it will affect the polling result. Using this command 'set global tx_isolation='read-committed';' to change the transaction isolation level to Read Committed could avoid this problem.

This issue is also addressed in AADB-6477 and fixed in ADB 7.1 HF3. So upgrading to ADB Adapter 7.1 HF3 or higher Hotfix release version, or ADB 7.2 the latest one is also a resolution.