Product specifications

Data access driver reference
6.1 CSV file connections
This section only relates to connections to be created in the information design tool.
The Data Access layer allows the SAP BusinessObjects Business Intelligence platform to connect to
Comma-Separated Value (CSV) files through BusinessObjects OpenConnectivity network layer. It
provides a data access driver called CSV OpenDriver to access the CSV files.
The connection wizard provides a workflow to enter the necessary information to connect to CSV files.
CSV data sources show up under Text Files DBMS and BusinessObjects OpenConnectivity
NetworkLayer.
Backward compatibility
Backward compatibility between SAP BusinessObjects Enterprise XI 3.x and SAP BusinessObjects
Business Intelligence platform 4.0 Feature Pack 3 releases is only supported for documents created
using an ODBC connectivity.
When a report user refreshes in Web Intelligence Rich Client a document based on a BusinessObjects
OpenConnectivity connectivity in 3-tier mode and created by using the XI 3.x release, the following
exception is raised:
Database error: (CS) "Specified network layer is invalid : BO OC". (IES 10901) (WIS 10901)
Since JDBC connectivity in 3-tier mode is not supported in XI 3.x releases, BusinessObjects
OpenConnectivity is not recognized as a network layer when the user tries to refresh a document in
the 4.0 Feature Pack 3 release.
6.1.1 Driver capabilities
Since text files do not provide any database operations, the data access driver implements the following
querying capabilities:
• basic operations for SELECT statements (WHERE, ORDER BY, GROUP BY, and AS)
• basic operators (=, <>, <, <=, >, >=, BETWEEN, NOT BETWEEN, LIKE, NOT LIKE, IS NULL, IS
NOT NULL, AND, OR) within WHERE clause
• use of wildcards ("?") within WHERE clause
2012-03-1563
Data access driver reference