IBM InfoSphere Federation Server, Version 10.1

Valid data source objects

Nicknames identify objects at the data source that you want to access. The following table lists the types of objects that you can create a nickname for in a federated system.

Table 1. Valid data source objects
Data source Valid objects
BioRS BioRS databanks
DB2® Database for Linux, UNIX, and Windows Nicknames, materialized query tables, tables, views
DB2 for System i® Tables, views, P/L (physical/logical) files and table types
DB2 for VM and VSE Tables, views
DB2 for z/OS® Tables, views
Informix® Tables, views, synonyms
JDBC All table types
Microsoft Excel .xls files (only the first sheet in the workbook is accessed)
Microsoft SQL Server Tables, views
ODBC Tables, views
Oracle Tables, views, synonyms
Script Scripts
Sybase Tables, views
Teradata Tables, views
Table-structured files Text files that meet a specific format.
Web Services Operations in a Web services description language file
XML-tagged files Sets of items in an XML document


Feedback

Update icon Last updated: 2012-05-18