About connection properties

Table 2-1 lists the preconfigured connection types, connection properties, and a description of each property.

Table 2-1

Properties for preconfigured connection types

Connection type	Property	Description
ActuateOne for e.Reports Data Source See Using Actuate BIRT Designer Professional.	Password	User’s Encyclopedia volume password.
	Server URL	URL for the BIRT iServer that manages the Encyclopedia volume in which the ROI file resides, for example http://MyServer:8000.
	Use Trusted Connection	Choose Yes to use a trusted connection. As you edit the data source and the data set, a trusted connection uses the same session to communicate with the iServer. Using a trusted connection improves performance. Choose No to use a non-trusted connection. A non-trusted connection uses the specified credentials to log in to the iServer for each communication.
	User	Encyclopedia volume user name.
	Volume	Name of the Encyclopedia volume in which the ROI file resides.
BIRT Report Document Data Source See Using Actuate BIRT Designer Professional.	Report document path	Path to the report document to use as a data source. The path must be an absolute path to a location on the iServer computer.
DB2	Collection	Similar to schema. Used only with z/OS and OS/400 operating systems.
	Database	Name of database.
	IANAApp-CodePage	For a description of IANAAppCodePage values, see About the IANAAppCodePage property.
	Password	A password used to connect to your DB2 database.
	Port	The port number that is assigned to the DB2 DRDA listener process on the server host machine. Specify this port’s numeric address or its name. If you specify a port name, the database driver must find this name in the SERVICES file on the Actuate BIRT iServer computer. Port is optional.
	Server	The IP address of the machine where the catalog tables are stored. Specify the address using the machine’s numeric address (for example, 123.456.78.90) or specify its name. If you specify a name, the database driver must find this name in the HOSTS file on the Actuate BIRT iServer computer or in a DNS server.
	User name	The login ID used to connect to your DB2 database. For DB2 on UNIX, the User name is your UNIX user ID.
Flat File Data Source See BIRT: A Field Guide.	Folder	The UNC path for the folder in which the file resides, for example \\MyComputer \MyFolder. The folder must reside on a Windows computer and must be shared.
	Charset	Character set used to encode the file.
	Flatfile style	CSV, SSV, PSV, or TSV for a file that uses comma-separated values, semicolon-separated values, pipe-separated values, or tab-separated values, respectively.
Informix	Database	Used to filter catalogs. For example, if you set this property to MyCatalog, the connection recognizes only those catalogs whose name begins with MyCatalog. If you want the connection to recognize all catalogs, do not provide a value for this property.
	Host	The name of the machine on which the Informix database resides.
	IANAApp-CodePage	For a description of IANAAppCodePage values, see About the IANAAppCodePage property.
	Password	A password.
	Port	The port number of the server listener.
	Service	The name of the server running the Informix database.
	User name	Your user name as specified on the Informix server.
MySQL Enterprise	Database	Used to filter catalogs. For example, if you set this property to MyCatalog, the connection recognizes only those catalogs whose name begins with MyCatalog. If you want the connection to recognize all catalogs, do not provide a value for this property.
	Password	The password for the MySQL Enterprise login account specified by the User name property.
	Port	Port number (optional).
	Server	The network address of the server running MySQL Enterprise. This is required and can be an IP address, for example, 199.226.224.34. If your network supports named servers, you can specify an address using the server name, for example, SSserver. To specify a named instance of MySQL Enterprise, use the format server_name \instance_name. If only a server name is specified with no instance name, the database driver connects to the server and uses the default named instance on the server.
	User name	A valid MySQL Enterprise login account.
Oracle	Password	The password that the database driver uses to connect to your Oracle database.
	Port	Identifies the port number of your Oracle listener. The default value is 1521. Check with your database administrator for the correct number.
	Server	Identifies the Oracle server to which you want to connect. If your network supports named servers, you can specify a server name, such as Oracleserver. Otherwise, specify an IP address, such as 199.226.224.34.
	SID	The Oracle System Identifier that refers to the instance of the Oracle database software running on the server.
	TNS names file	Name of the TNS names file, for example, tnsnames.ora. This file must be accessible from the computer running the Integration service. Used only when the Server name property is not set.
	TNS server name	Name of the entry in the TNS names file that contains the configuration information describing the database server. Used only when the Server name property is not set.
	User name	The user name that the database driver uses to connect to your Oracle database.
POJO Data Source See Using Actuate BIRT Designer Professional.	Runtime properties	Shared location of custom POJO data set classes.
	Design time properties	Shared location of custom POJO data set classes.
PostgreSQL	Database	Used to filter catalogs. For example, if you set this property to MyCatalog, the connection recognizes only those catalogs whose name begins with MyCatalog. If you want the connection to recognize all catalogs, do not provide a value for this property.
	Password	The password for the PostgreSQL login account specified by the User name property.
	Port	Port number (optional).
	Server	The network address of the server running PostgreSQL. This is required and can be an IP address, for example, 199.226.224.34. If your network supports named servers, you can specify an address using the server name, for example, SSserver. To specify a named instance of PostgreSQL, use the format server_name \instance_name. If only a server name is specified with no instance name, the database driver connects to the server and uses the default named instance on the server.
	User name	A valid PostgreSQL login account.
SQL Server	Database	Used to filter catalogs. For example, if you set this property to MyCatalog, the connection recognizes only those catalogs whose name begins with MyCatalog. If you want the connection to recognize all catalogs, do not provide a value for this property. If you are running multiple instances of SQL Server, precede the database name with the instance name, for example MyInstance/MyDatabase.
	Password	The password for the SQL Server login account specified by the User name property.
	Port	Port number (optional).
	Server	The network address of the server running SQL Server. This is required and can be an IP address, for example, 199.226.224.34. If your network supports named servers, you can specify an address using the server name, for example, SSserver. To specify a named instance of SQL Server, use the format server_name\instance _name. If only a server name is specified with no instance name, the database driver connects to the server and uses the default named instance on the server.
	User name	A valid SQL Server login account.
Static Data Source See Using Actuate BIRT Designer Professional.		Create a data set by typing values in the data set editor. Use a static data source to create sample data for testing purposes.
Sybase	Charset	The name of a character set. This character set must be installed on the Sybase server. The default is the setting on the Sybase server. For the Integration service to return Unicode data, this property must be set to UTF8. Refer to the Sybase server documentation for a list of valid character set names.
	Database	Used to filter catalogs. For example, if you set this property to MyCatalog, the connection recognizes only those catalogs whose name begins with MyCatalog. If you want the connection to recognize all catalogs, do not provide a value for this property.
	IANAApp-CodePage	For a description of IANAAppCodePage values, see About the IANAAppCodePage property.
	Password	A case-sensitive password.
	Port	Port number.
	Server	An IP address, for example, 199.226.224.34. If your network supports named servers, you can specify the address using the server name, for example, Sybaseserver.
	User name	The login ID used to connect to your Sybase database. This ID is case-sensitive.
Web Services Data Source See BIRT: A Field Guide.	WSDL descriptor	The path or URL for the Web Services Description Language file. A well-formed WSDL file defines the available services and, typically, the SOAP end point URL.
	SOAP end point	SOAP end point URL. Omit this value if the end point is defined in the WSDL file, or if you are using a custom connection class that does not require an end point URL.
	Custom driver class	The fully qualified class name. Create and use a custom driver if, for example, the web service does not provide a WSDL file.
	Driver class path	A semicolon-separated list of JAR files and directories to search for the custom driver class.
XML Data Source See BIRT: A Field Guide.	URL of the XML source	The path or URL for the file that contains XML data.
	URL of the XML schema	The path or URL for the file that contains a description of the XML file’s data structure (optional).
	Encoding for the XML source and schema	Encoding for the XML file and schema. Use the default value, Auto, if you want the data source to detect the encoding for the XML file or schema.

Copyright Actuate Corporation 2012