Development Environment

This article contains the following topics:
casm171
This article contains the following topics:
Updating the CA Business Intelligence infrastructure with CA SDM schema changes is an administrative function. An administrator who is promoting modified schema into the reports must set up the environment, apart from their production environment.
Some of the tools used by CA Business Intelligence require a Windows-based architecture. This means that installations of Linux/UNIX must configure CA Business Intelligence on a Windows computer to interact with the Linux/UNIX production environment CA Business Intelligence installation. If you are using Windows servers in production, you should configure an additional Windows computer for your development environment.
Tools
Updating the CA Business Intelligence infrastructure with CA SDM schema changes is an administrative function. To promote modified schema changes into the reports, you must include the following tools in your development environment:
  • Universe Design Tool
    This full client Windows tool is installed on the CA Business Intelligence production server as part of the base CA Business Intelligence installation for windows. When the CA Business Intelligence server is a non-Windows architecture, or when login access to the production CA Business Intelligence application server is undesirable, you must create a separate CA Business Intelligence installation on a Windows (development) server. A development CA Business Intelligence server installation allows you to access the production CA Business Intelligence objects remotely, no matter the architecture of the CA Business Intelligence production server installation.
  • BusinessObjects Web Intelligence
    This web-based report creation tool is used for modifying and creating Web Intelligence (WebI) reports. You can access the WebI tool through the Business Intelligence Launch Pad interface. Administrative permissions for the WebI and Business Intelligence Launch Pad tools are available within CA Business Intelligence, specifically using the BusinessObjects Central Management Console (CMC) tool.
  • CA SDM ODBC Driver
    Provided with the CA Business Intelligence installation is the CA SDM ODBC Driver. This component enables WebI and Crystal Reports to access CA SDM data while enforcing data partition security. The ODBC Driver is installed as part of the base CA Business Intelligence installation on the CA Business Intelligence application server. It is also available as a client installation so that it can be used on a computer not running CA Business Intelligence along with the Crystal Reports XI client.
For information on defining data partitions security for your reporting environment, see the Set Up Data Partitions Security for Reporting section.
How to Create a Development Environment
To create a development environment, do the following:
  1. Secure a server with a supported Windows operating system.
  2. Install and configure CA SDM.
  3. Install and configure CA Business Intelligence.
  4. Change the default ODBC DSN Name from casd_xxxxx to casd_yyyyy where yyyyy is exactly the same as the DSN on the production implementation.
    Regardless of the actual connection properties, the DSN name must be identical on the development and production implementations.
  5. (Optional) Install and configure Crystal Reports XI.
    It is not required to install Crystal Reports on the same computer as CA Business Intelligence. Crystal Reports can be installed on a different computer, as long as the CA SDM ODBC Driver is also installed on the Crystal Reports computer , and the DSN Name is modified to be identical to the production implementation, regardless of the actual connection properties. For more information about installing an individual copy of the CA SDM ODBC driver, separate from the CA Business Intelligence installation, see your ODBC Driver documentation.