The JDBC driver jar file for the DBMS has to be accessible on the developers workstation. There are three steps to enable the JDBC drivers:
Once the connections are working on the server, they will work for published content for Webi, Lumira and Crystal Reports Enterprise. Information Design ToolĬreate the connections running the IDT on the server to setup the JDBC access.
This is recommended for users publishing Crystal Reports to BusinessObjects Enterprise. Crystal Reports EnterpriseĬonnections are setup on the server and consumed in the designer by connecting to the CMS. Setup is different for workstation and client see following notes. This will access the data in three tier mode and eliminate the need for middleware on the client workstation. WebiĪccess JDBC Connections using J2EE Connection to CMS instead of direct connection to the CMS. If the user is accessing JDBC connections using a universe, there is no setup required on the user workstation if the connections are setup on the server.
The setup is different for the workstation and the server. These instructions have been validated with SBOP 4.2 SP4 and SP5 and with Lumira Discovery 2.0 and 2.1` JDBC Connectivity This guide talks about the steps required to support JDBC on the desktop and server.
#NETEZZA JDBC DRIVER JAR FILE DOWNLOAD DRIVERS#
This can lead to extra administrative work if there are existing ODBC drivers in use for the same datasources. With the move to Lumira Discovery, JDBC drivers are required to allow users to query databases directly without a universe connection.