Denodo 5.0 is post-certified with Strategy Analytics Enterprise 9.4.1. This post-certification status currently applies to Strategy Intelligence Server 9.4.1 running on Linux operating system - it does not apply to Strategy Intelligence Server 9.4.1 running on AIX, HP-UX or Sun Solaris operating systems. Also, this post-certification status currently applies to Warehouse configurations only - it does not apply to Metadata, Statistics or Strategy Narrowcast Server.
This is a post-certification since the testing was performed after the release of Strategy Analytics Enterprise 9.4.1. Therefore, the certification information (tabulated below) is not present in the Strategy Analytics Enterprise 9.4.1 General Information Readme file.
The following is the certification information on Linux for Strategy Analytics Enterprise 9.4.1:
R01_Y1999_SALES R01_Y2000_SALES R02_Y1999_SALES R02_Y2000_SALES YEAR_IDMONTH_IDREGION_IDSTORE_IDSALES_AMT19991999011000150199919990110002200MONTH_IDSTORE_IDSALES_AMT1999010001501999010002200
CLIENTMACHINE
COUNT(*)
Server Machine: 23.4.3.146 Client Machine:
8
CLIENTMACHINEEVENTSOURCECOUNT(*)Server Machine: 11.30.17.243 Client Machine:264Server Machine: 11.30.17.243 Client Machine:132 Denodo 5.0 Strategy ODBC Drive for PostgreSQL Wire ProtocolCertified
|
R01_Y1999_SALES R01_Y2000_SALES R02_Y1999_SALES R02_Y2000_SALES YEAR_IDMONTH_IDREGION_IDSTORE_IDSALES_AMT19991999011000150199919990110002200MONTH_IDSTORE_IDSALES_AMT1999010001501999010002200
CLIENTMACHINE
COUNT(*)
Server Machine: 23.4.3.146 Client Machine:
8
CLIENTMACHINEEVENTSOURCECOUNT(*)Server Machine: 11.30.17.243 Client Machine:264Server Machine: 11.30.17.243 Client Machine:132 Denodo 5.0 Strategy ODBC Drive for PostgreSQL Wire ProtocolCertified
|
R01_Y1999_SALES R01_Y2000_SALES R02_Y1999_SALES R02_Y2000_SALES YEAR_IDMONTH_IDREGION_IDSTORE_IDSALES_AMT19991999011000150199919990110002200MONTH_IDSTORE_IDSALES_AMT1999010001501999010002200
CLIENTMACHINE
COUNT(*)
Server Machine: 23.4.3.146 Client Machine:
8
CLIENTMACHINEEVENTSOURCECOUNT(*)Server Machine: 11.30.17.243 Client Machine:264Server Machine: 11.30.17.243 Client Machine:132 Denodo 5.0 Strategy ODBC Drive for PostgreSQL Wire ProtocolCertified
|
In order to use Denodo as a warehouse with Strategy Intelligence Server 9.4.1, users must use the 'Denodo 5.0' object in the 'Database Connection Type' window (located at Configuration Managers > Database Instance Manager > Database Instance) in Strategy Developer 9.4.1.
Refer to the following Technical note for steps to obtain and install the PDS object.
KB43537 - How to install DBMS objects provided by Strategy Technical Support
Known Issues
- Denodo 5.0 with Strategy ODBC Driver for PostgreSQL Wire Protocol will not work well with data import on Strategy Web since Strategy ODBC Driver for PostgreSQL Wire Protocol cannot recognize DBMS type ‘Denodo 5.0’ in Data Import. The issue will be fixed in the next release of Strategy.
- Query Builder/Freeform SQL report editors will hang there when trying to expand a table to get table structure from the Object Browser list. The issue will be fixed in the next release of Strategy.
- Reports executed against Parameterized Query enabled DB Instance will get “Socket Closed” error with Strategy ODBC Driver for PostgreSQL Wire Protocol. Please contact Denodo to get Denodo compiled Native PostregSQL ODBC Driver to work around it.
Third Party Software Installation WARNING
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.
