Read Me Online Logo

Connectivities


General Information
Documentation
Limitations


General Information

Configuration Support

The Product Availability Report (PAR) contains detailed up-to-date information on supported:

New IBM Product Nomenclature

Restrictive Connections

This connection type is using the BusinessObjects @Variable function BOUSERPROMPT to ensure that the user are prompted to enter the database login parameters when trying to access the data and refresh the report. Refer to the section "Defining restrictive connections" in the Designer's Guide for more information.


Documentation

All database access guides are available in pdf format on the CD; however, only IBM DB2, Oracle, Informix, Microsoft SQL Server, Sybase, Oracle Rdb, Shadow Direct, Star SQL, Red Brick, and Teradata are provided as printed guides.


Limitations

Overview
IBM DB2 UDB
IBM DB2/390 (zSeries)
IBM DB2/400 (iSeries)
Informix
MS Access
MS OLE-DB
MS SQL Server
Neon Systems Shadow Direct
ODBC
Oracle
Oracle Rdb
Red Brick
StarSQL

Sybase ASE 
Sybase ASIQ 12
Teradata

Overview

IBM DB2 UDB

IBM DB2/390 (zSeries)

IBM DB2/400 (iSeries)

Informix

  1. Double-click an object in the Object Browser.
    The Edit Properties of Object dialog box appears.

  2. Click the Advanced tab.
    The Advanced page appears.

  3. Clear the Condition checkbox in the Can be Used In groupbox.

  4. Click OK

  1. Double-click an object in the Object Browser
    The Edit Properties of Object dialog box appears.

  2. Click the Advanced tab.
    The Advanced page appears.

  3. Type 'YYYY-MM-DD HH:MM:SS.000' in the Database Format textbox.

  4. Click OK.

MS Access

Note: starting with Microsoft Data Access Components (MDAC) version 2.6, MDAC no longer contains the following Jet components:

MS OLE-DB

MS SQL Server

Neon Systems Shadow Direct

ODBC

Oracle

Browser

Middleware (UNIX or Windows): 

Database (UNIX or Windows): 

Oracle Rdb

[Oracle ODBC Driver for Rdb] 
DriverLevel=1 
ArrayFetch=1 
Driver Name=Oracle [OR][Dd][Bb][C]* 
SQL External File=Rdb 
SQL Parameter File=rdb 
InputDateFormat={\d 'yyyy-mm-dd'}

Red Brick

Star SQL

Sybase ASE

Sybase ASIQ 12

Teradata

create table object1(obj_N TIMESTAMP WITH TIMEZONE)
insert into object1 values(TIMESTAMP 'yyyy-mm-dd hh:mm:ss')

If your date columns are stored as TIMESTAMP datatypes then you must change the InputDateFormat value in the default section of the Teradata.sbo file to: 

TI\ME\STA\MP 'yyyy-mm-dd HH:mm:ss'

If your date columns are stored as DATE datatypes, but few columns are TIMESTAMP datatypes, then leave the InputDateFormat as \d 'yyyy-mm-dd', and apply TI\ME\STA\MP 'yyyy-mm-dd HH:mm:ss' database object format to these specific objects in Designer (i.e. Advanced tab of the Edit Properties of Object dialog box).

You can find the Teradata.sbo file at: C:\Program Files\Business Objects\Data Access 5.0\Teradata\Teradata.sbo.

If you use this object in BusinessObjects, you must create the following date format:

yyyy-mm-dd hh:mm:ss

and apply it on the cell that displays this object.