Switch to standard view 
  Sybase logo
 
 
 



 

Contents


Overview

This report describes each of the products tested and how they were used during testing. Only the platforms and products tested are reflected in this certification, but other possible combinations of these products and platforms may be used. For more information about Sybase products, including known issues not encountered during this certification or those occurring on other platforms, see the Release Bulletin for the specific product, platform and version. For more information about any of the products, please refer to the product literature or manufacturer website.

Click here for trademark and registration information.

For more detailed information about the machines used in this environment, see the section Test Environment later in this report.

The following diagram illustrates the test environment.

Back to Contents


Tests Performed

This section contains a detailed explanation of the tests performed.

Back to Contents


Setup and Configuration

The following information relates to the installation, setup and configuration of the test environment.

The setup and configuration tasks are described in the following sections:

Install and configure Sybase Products

Install and configure the Sybase IQ server

  1. Install the Sybase IQ server onto a 64-bit Sun SPARC Solaris 10 workstation, accepting all default installation options except the target installation directory.
  2. Run the provided script to create the version iqdemo sample database and then ran the sample database and server. See the Sybase IQ Quick Start Guide for more information regarding the creation of an IQ demo database.
  3. Load the Solaris language packs to support the Simplified Chinese data used for multi-byte data testing.

Install and configure the Sybase IQ client software

In the certification test environment, the Sybase IQ Network Client for Windows was installed on the same Windows XP machine where Tableau was installed. The Sybase IQ Network Client includes the IQ ODBC driver required to enable ODBC and native Sybase connectivity between Tableau and Sybase IQ.

  1. Install the Sybase IQ Network Client for Windows on the same Windows XP machine where Tableau is installed. Note that this client software includes 32-bit and 64-bit versions of the IQ ODBC driver as well as drivers for Sybase IQ native connectivity drivers.
  2. To configure ODBC connectivity:
    • Open the 32-bit ODBC Administrator available from the Start | Programs | Sybase | Sybase IQ menu to configure ODBC data sources. 32-bit and 64-bit versions of the IQ ODBC driver. Note that using the version of the ODBC Administrator available on this menu ensures you correctly load the 32-bit Sybase drivers.
    • Configure data source names (DSNs) for Sybase IQ. For information about configuring DSNs, see the Sybase Whitepaper: Basic Connectivity for Sybase IQ, ASE and Sybase RAP - Trading Edition. Note that the Sybase IQ demo databases were configured with the UTF-8 character set. Thus, to connect to the demo databases, you may need to specify "utf8" in the Character Set field of the Advanced tab of the driver configuration dialog box.

Install and configure Tableau Desktop Professional

In the test environment, Tableau was installed on the same 64-bit Windows XP machine that the Sybase IQ Network Client was installed on prior. Note that even though the operating system was 64-bit, both the Sybase IQ Network Client and Tableau were 32-bit applications.

  1. Install Tableau, accepting all the default installations options. After installation, Tableau will be available as a Start menu programs option.
  2. Launch Tableau application by choosing Start | <All> Programs | Tableau 7.0. Tableau opens displaying the Start page

  1. Configure Tableau to connect to the IQ server, using either the ODBC DSN created in the prior step or the Sybase IQ native connectivity methods. Connectivity testing was performed by executing the following steps:
    1. On Start page, select Connect to Data. The Connect to Data window displays.
    2. Select Sybase IQ (connect natively) or Other Databases (ODBC) from the On a Server list. In this example, the Sybase IQ connectivity method is shown. See Test Note 7 for details on using Other Databases (ODBC) to connect to Sybase IQ.

    3. The Sybase IQ Connection window displays.
    4. The descriptions for Step 1 and Step 2 are not reflective of the values that need to be entered within this window. Within Step 1, the "server name" value should be the hostname for the Sybase IQ server machine (ex: aelabsun) and the "Port" should reflect the port number used for the Sybase IQ server (ex: 2638). Within Step 2, the "database on the server" value should be the actual name of the Sybase IQ server (ex: aelabsun_iqdemo154ga).
    5. In Step 3, select Use a specific username and password for connecting and provide a valid Sybase IQ username/password combination.
    6. Select Connect within Step 4 to actively establish a connection to Sybase IQ. Once connected, Step 6 will display a list of tables available from Sybase IQ.

    7. Select Cancel to close the Sybase IQ Connection screen or proceed to Step 6 within the Feature Example section to continue. Tableau is now configured and ready to create views with Sybase IQ data. The next section Feature Example describes the process for creating a basic view (worksheet).

Back to Contents


Feature Example

This section describes how to manually build a view in Tableau to display Sybase data. In the following example, Sybase IQ (native connectivity) will be used for the connectivity, however, ODBC connectivity could also be used. See Test Note 7 for information on connecting within Tableau to Sybase IQ using ODBC connectivity.

Creating a basic Tableau View

    Steps 1 through Step 5 were previously described in detail within Step 3 of the Setup and Configuration section. Refer to this section for further details.

  1. Open the Tableau application. The Getting Started page will display.
  2. On Getting Started page, select Connect to Data. The Connect to Data window displays.
  3. Select Sybase IQ (connect natively) from the On a Server list.
  4. The Sybase IQ Connection window displays. Complete the connectivity fields within this window as described previously.
  5. Select Connect within Step 4 to actively establish a connection to Sybase IQ. Once connected, Step 6 will display a list of tables available from Sybase IQ for the user schema.
  6. Within Step 5, use the drop-down list to change the schema to GROUPO. The list of tables displayed within Step 6 will redisplay and include the sample iqdemo sample tables owned by GROUPO.
  7. Highlight the Products table within the Step 6 display and select the Multiple Tables radio button. Again, Step 6 will redisplay to only include the Products table.
  8. Select Add Table and highlight the SalesOrderItems table. Notice the Join tab contains the join clause for the Products and SalesOrderItems tables. Additionally, the Join Type can be manipulated to be Inner, Left, Right, Full join types. Select OK.
  9. Again, select Add Table and highlight SalesOrders table. Once again, notice the Join tab contains the join clause for the Products and SalesOrders tables. Select OK. Step 6 within the Sybase IQ Connection window will appear as follows:

  10. Select OK to continue. The Data Connection window will appear. Select Connect Live and continue.

  11. The default Book1 worksheet window will display with the Products, SalesOrderItems and Salesorders data source fields. Notice how Tableau automatically organizes the data source fields into the Dimensions and Measures areas. The Dimensions area holds qualitative data (i.e. dates, names etc). The Measures area holds quantitative data (i.e. quantity, prices etc). To change the field classification from Measures to Dimensions, or vice versa, drag and drop the field to the appropriate classification area.
  12. Drag and drop the Name and Description (Products) Dimensions into the Rows shelf at the right. The Name and Description data will display in the View area.

  13. Drag and drop the Quantity (Products) Measure into the Columns shelf at the right. Tableau automatically displays the data in an Aligned Bar view. Hovering over each bar will display the Quantity numerically. NOTE: Tableau automatically aggregates Measure values as a SUM, so this value will not be accurate.

  14. Remove the SUM on the Quantity measure: Highlight SUM(Quantity) within the Column shelf and select Analysis from the Tableau menu bar. Uncheck Aggregate Measures, thus removing the SUM on the Quantity measure. Hovering over the bar will display the correct Quantity value for each product.

  15. Create a Filter based on the product Name.
    1. Right click the Name data field, located in the Rows shelf, and select Filter from the drop down menu

    2. The Filter window displays. De-select the Baseball Cap and Visor data fields

    3. Select OK to apply the filtered results.

This completes the basic feature demonstration of Tableau Desktop Professional. Refer to Tableau for the many other view options available.

Back to Contents


Test Notes

This section contains information gained during testing, which may be helpful.

Test Note 1: When Connecting to Multiple Tables, Tableau automatically assigns alias field names to the ambiguous fields
Test Note 2: Using Format to modify how a numeric field is displayed
Test Note 3: Creating a "Custom SQL" Tableau view to include tables owned by multiple Creators
Test Note 4: Create or edit multiple table joins in Tableau
Test Note 5: Displaying NULL values in a Measures data field
Test Note 6: Tableau reports error "Username or Password incorrect" while connecting using Sybase IQ connection.
Test Note 7: Connecting within Tableau using "Other Databases (ODBC)" connectivity to Sybase IQ
Test Note 9: Data Types tested and related notes

Test Note 1: When Connecting to Multiple Tables, Tableau automatically assigns alias field names to the ambiguous fields

There may be cases, when joining multiple tables, where an identical field name is used within both tables. Tableau handles this issue by automatically assigning a field alias, combining the table name and field name, to the ambiguous field. In our example, the ID fields in the Products and SalesOrderItems tables are ambiguous. Tableau completes the connection creating an alias (SalesOrderItems_ID) for the SalesOrderItems ID data field. See example below.

Test Note 2: Using Format to modify how a numeric field is displayed

The data stored in IQ and retrieved for inclusion in a Tableau workbook has a larger decimal remainder than the default display setting in Tableau.

The appearance of the numeric values can be changed by formatting the field using the field Format option. For example, the default display for decimals is set to 0. To change the way decimals are display, right-click on the field, and select Format from the drop-down menu.

The Format Measure Values area is displayed. Select the Pane tab, click Numbers, choose Currency (Custom) from the pull-down menu. Using the up/down arrows scroll to the number of decimal places you wish to display. See Issue 1 for information regarding maximum precision supported by Tableau.

See Issue 1 for further details on numeric issues encountered.

Test Note 3: Creating a "Custom SQL" Tableau view to include tables owned by multiple Creators.

The following example demonstrates the steps used to build a view using custom SQL and including tables from multiple creators (table owners).

From within the Sybase IQ Connection window, select the Custom SQL option. Enter the custom SQL and select OK to continue. NOTE: tabes owned by different users should be fully-qualified by adding the owner name prefix in front of the table name, as shown in the SQL below.

Test Note 4: Create or edit multiple table joins in Tableau

Establish a connection to Sybase IQ within the Sybase IQ Connections window.

Select the Single Table radio button and highlight a table within the table list. This table will be the primary table in which all other tables must be associated with. For example, within the iqdemo database, the Products table, is a good starting point. Then select the Multiple Tables option.

In the example below, the Products table was selected while the Single Table radio button was selected. Then the Multiple Tables radio button was selected thus changing the table list to the following:

Select Add Table. The Add Table dialog box opens.

Highlight the table desired for addition. From the pull down menu, select the table you want to add. Notice the Table Fields panel will reflect the table selected to add.

Select the Join tab to display the join. Edit the Join Type or modify the Join Clause if necessary.

Select OK to save, returning to the Sybase IQ Connection window. The Step 6 table list will now include the newly added table. Repeat the Add Table process until all desired tables have been added. The objects within these tables will be available within worksheets.

Test Note 5: Displaying NULL values in a Measures data field.

The following details the steps used to display null data field values.

Open the Format view and select the Pane tab. Click on the Fields pull-down menu and select the measures field you wish to format.

From within the Special Values area, select Show at Indicator from the pull-down menu.

The Null values in the SUM(Quantity) data field will now be included in your view.

Test Note 6: Tableau reports error "username or password incorrect" while connecting via a Sybase IQ connection

Once you have verified the username and password provided are correct, check the Sybase IQ server message log. This error may be reported in cases where the Sybase IQ server has exceeded the defined number of connections allowed. To correct this, increase the number of user connections within Sybase IQ or if the server is inactive, a restart of the server will free all connections.

Test Note 7: Connecting within Tableau using "Other Databases (ODBC)" connectivity to Sybase IQ

The following information details utilizing the Tableau "Other Databases (ODBC)" connectivity within Tableau.

  1. Within the Connect to Data window, select Other Databases (ODBC). The Generic ODBC Connection window displays.
  2. Select the DSN data source from pull down menu.
  3. Select Connect. Connection to database succeeds. Click OK to close window.
  4. Select a Creator from the pull down menu. For this example, GROUPO was selected as the Creator. Tableau's Creator name is equivalent to Sybase's table owner name. GROUPO is the Sybase database table owner's name for the IQ demo tables.

  5. Click on the Find window displays.

  6. Highlight the desired table and click Select. The Select Table window closes and the selected table will appear in the Table section of the connection window.

Test Note 9: Data Types tested and related notes

This section contains a table listing the data types tested for IQ. Following the table are test notes and workarounds for possible data type issues.

Data Types tested

The following Sybase IQ data types were tested. Maximum values (or large values where maximum values are theoretical and restricted by hardware) and small values as well as null and not null values were tested. See Test Note 2 for information about formatting data, such as decimal values, and see the notes following the table below for additional information about data types.

Types Sybase IQ Results
Exact Numeric Integer (int) Types

Tinyint, smallint, int, unsigned int, bigint, and unsigned bigint

Bigint and unsigned bigint

all displayed properly

#Error returned

Exact Numeric Decimal Types

decimal(10,4) and (8,8) , numeric(18,0), smallmoney.

Decimal (19,4) and (31,0)

Format decimal (19,4) and (31,0) field as Number (custom), set decimal to 0.

 

Money

See Test Note 2 for information about formatting numeric data.

Decimal (19,4) and (31,0) returned as scientific notations See Issue 1.

Results in the rounding up to an accuracy of 15. For example formatting decimal (31,0) 999,999,999,999,999,999,999,999,999,999 rounds up to 10,000,000,000,000,000,000,000,000,000,000

rounding occurs. 922,337,203,685,477.5807 truncates the decimals places Rounds up to a precision of 15 displaying 922,337,203,685,478.

Approximate Numeric Float Types

Float, real and double

Real

Float returns scientific notation. Displays maximum decimal precision of 15. Numeric data with precision greater than 15 are rounded up.

Real values display as scientific notation. Reformat data as a Number (custom) data type. Results in the rounding up to an accuracy of 15.

Character (char) Types Char in lengths 1 and 254 and varchar in lengths 10 and 254 all displayed properly
Text Types Not supported in IQ. Not supported in IQ.
Date/Time Types Date, time, smalldatetime, datetime and timestamp Tableau does not offer an option to display milliseconds.
Binary (bin) Types Binary and varbinary all displays properly
Bit Array Types Not supported in IQ. Not supported in IQ.
Image Binary Large Object (BLOB) and Image Types BLOB and image BLOB data is displayed as raw data. Image/document content is rendered properly.
Character Large Object Types (CLOB) and Long Varchar Types CLOB and long varchar in length 1 and 300 all displays properly
Multi-byte Data Multi-byte data tested in the form of Simplified Chinese data inserted into a varchar column in a UTF8 database all displayed properly

Back to top of Notes section | Back to Contents


Issues and Incompatibilities

This section describes the issue(s) found during testing.

Issue 1: Limits of size and precision on numerical data

Tableau has display limitations affecting minimum and maximum values for the following datatypes.

Bigint: Sybase IQ is capable of storing integers with a magnitude of 9.22x10^18, and with an accuracy of about 18 digits. Unsigned bigint's are not supported in Tableau. The data returned is displayed as #Error.

Real: Sybase IQ is capable of storing real numbers with a magnitude of nearly 3.4x10^38, and with an accuracy of about 18 digits. Tableau converts large real numbers to scientific notations, and only displays an accuracy to 15 digits.

Float: Sybase IQ is capable of storing floating point numbers as large as 76 digits before the decimal point, or as small as 96 digits after the decimal point. Tableau will convert large floating point numbers to scientific notation, and only displays an accuracy to 15 digits.

Issue 2: Limitations for the ODBC data source

When connecting to the ODBC data source, utilizing Tableau’s Generic ODBC Connection option, the following error is received:



Listed below are the details of the unsupported capabilities:

Tableau identified the following warnings for the ODBC data source named 'TEST_FLOAT (DBA)':
Tableau was unable to determine support for the following: SELECT ... INTO
This aggregation is unsupported: Median
This function is unsupported: DATETIME with parameter types 'integer'
This function is unsupported: POWER with parameter types 'float, integer'
This function is unsupported: The date part named 'day' for the date function: DATEDIFF(date_part, start_date, end_date)
This function is unsupported: The date part named 'dayofyear' for the date function: DATEDIFF(date_part, start_date, end_date)
This function is unsupported: The date part named 'hour' for the date function: DATEDIFF(date_part, start_date, end_date)
This function is unsupported: The date part named 'minute' for the date function: DATEDIFF(date_part, start_date, end_date)
This function is unsupported: The date part named 'month' for the date function: DATEDIFF(date_part, start_date, end_date)
This function is unsupported: The date part named 'quarter' for the date function: DATEDIFF(date_part, start_date, end_date)
This function is unsupported: The date part named 'second' for the date function: DATEDIFF(date_part, start_date, end_date)
This function is unsupported: The date part named 'week' for the date function: DATEDIFF(date_part, start_date, end_date)
This function is unsupported: The date part named 'weekday' for the date function: DATEDIFF(date_part, start_date, end_date)
This function is unsupported: The date part named 'year' for the date function: DATEDIFF(date_part, start_date, end_date)

Issue 3: Stored Procedures are not supported by Tableau.

Tableau does not currently support stored procedures. .

Back to Contents


Test Environment

This section provides details about the test environment.

Client Machine

Hardware or Software Description or Version

Operating Environment

Two Intel(R) Xeon(R) CPUs, 2.13 GHz each, 64-bit VM running VMWare ESX Server version 3.5
Memory

4 GB

Disk 40 GB
Operating System 64-bit Microsoft Windows 7 Professional
Tableau Desktop Professional Edition version 7.0.1
Sybase IQ Network Client

32-bit, version 15.4

Server Machine

Hardware or Software Description or Version

Operating Environment

Sun Ultra SPARC IV (64-bit) running four 1.8 GHz processors
Memory

32 GB

Disk 1 TB
Operating System 64-bit Sun Solaris 10 with language packs installed
Sybase IQ Enterprise Server

version 15.4

Back to Contents


Other Sources of Information

Sybase IQ Resource Page

Sybase provides a site dedicated to the Sybase IQ product. On this page, there are links to Data Sheets, White Papers, Webcasts / Podcasts, News, Case Studies (customer success stories), Events, Analyst Reports, the Sybase Analytics Blog, Videos, Awards, Newsletters, and Migration Resources. There is also a link on this site to a free download trial of Sybase IQ.

The Sybase IQ Resource Page is located at: http://www.sybase.com/IQ

Sybase Partner Program

For more information about the Sybase Partner Program, please visit the Sybase Partner Program website.
http://www.sybase.com/partner

Back to Contents


Vendor Contact Information

Vendor Name: Tableau Software
Website: www.tableausoftware.com

Back to Contents




Back to Top
© Copyright 2010, Sybase Inc.