There are two ways to create a connection profile in BIRT Report Designer Professional. You can create a connection profile in Data Explorer, when you create a data source, or in Data Source Explorer view. You use Data Source Explorer to modify, import and export connection profiles.
Connection profiles are stored in text files called connection profile stores. Connection profile stores can contain multiple connection definitions for various ODA data sources. The default connection profile store is ServerProfiles.dat, located in the .metadata folder in your workspace.
You can also define your own connection profile store, and choose an absolute or a relative file path to store it. It is a good practice to create and use your own profile store file, instead of the default store. Using the default store requires using absolute file paths for a profile location and involves additional procedures of exporting a profile.
Using the Data Source Explorer to create a connection profile limits the connection profile location definition to an absolute file path only, while Data Explorer allows a relative and absolute file path definition. When using a relative file path, the Resource folders in the designer and iServer are used as the base folders. At design time, the BIRT Resource folder points to either the project root or an item in the workspace or a folder on the file system. This setting is available under Report Design->Resources node in the Preferences view. At runtime, the BIRT Resource folder points to the Resource folder on the iServer.
Like other BIRT resource files, you must deploy the connection profile store to the iServer when you deploy the report that uses it. By default, BIRT Designer deploys relative path connection profiles to the iServer resource folder.
The connection profile store file can be encrypted using BIRT secured encryption framework. The default extension for the connection profile is .acconnprofiles. This extension is tightly integrated with the default out-of-the-box encryption.
|
2
|
|
Figure 27-1
|
|
Figure 27-2
|
|
1
|
In Browse, narrow down your selection by choosing Relative Path, or Absolute Path for the connection profile store. Relative Path lists all the connection profile stores in the Resources folder. Absolute Path opens a browser window to the file system.
|
Selecting a connection profile store displays the connection profile store content in the text box below Use externalized properties in Connection Profile Store.
|
2
|
Select Use externalized properties in Connection Profile Store to maintain the link to the profile instance in the external profile store file. It is enabled by default. Disabling removes the external reference link, and copies the properties from the selected profile to the data source local properties.
|
|
3
|
Deselect Use the default data source name, if you wish to specify a data source name different from the default.
|
|
To create a new connection profile store, choose New. Create Connection Profile Store appears, as shown in Figure 27-3.
|
|
Figure 27-3
|
|
1
|
In Create Connection Profile Store, select an existing profile from the list or choose New to create a new connection profile.
|
New Connection Profile appears, as shown in Figure 27-4, and lists the data source types for which you can create connection profiles.
|
Figure 27-4
|
|
2
|
Choose a data source type and specify a name of the new connection profile. In this example, as shown in Figure 27-4, Flat File Data Source type is selected.
|
|
4
|
Specify the required information to connect to the data source. For a flat file data source, as shown in Figure 27-5, you must enter:
|
|
|
file format details, such as Use first line as column name indicator, Use second line as data type indicator, and Use trailing null columns.
|
The connection properties are the same as the properties displayed by the data source wizard.
|
Figure 27-6
|
|
9
|
Choose Browse to select a location for the profile store, or choose the arrow icon next to Browse, and choose Relative Path or Absolute Path By default, profile store files are saved in a relative file path. Try to use a relative path, unless your implementation requires an absolute path.
|
The relative path selection brings up a window like the one in Figure 27-7. The default file extension is .acconnprofiles and the displayed location is the Resource folder in your workspace.
|
Figure 27-7
|
|
10
|
Select a folder in the suggested location and specify the file name, if you have not entered it in the previous step. Choose OK.
|
|
11
|
Deselect Encrypt file content if you wish not to encrypt. The option to encrypt is default.
|
The selected relative path, in this example ReportDesigns/Products.acconnprofiles, appears in Connection Profile Store box as shown in Figure 27-8.
|
Figure 27-8
|
|
13
|
|
5
|
If you see a window, such as the one shown in Figure 27-15, choose Test Connection. If the connection is successful, choose Finish to save the connection profile.
|
|
Figure 27-9
|
