Connection type | Property | Description |
e.Reports Data Connector for iHub Data Source See BIRT Application Developer Guide. | Password | User’s volume password. |
Server URL | URL for the iHub that manages the 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 iHub. 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 iHub for each communication. | |
User | Volume user name. | |
Volume | Name of the volume in which the ROI file resides. | |
BIRT Report Document Data Source See BIRT Application Developer Guide. | 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 iHub 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 iHub 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 iHub computer or in a DNS server. | |
User name | The login ID used to connect to your DB2 database. For DB2 on Linux, the User name is your Linux 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 computer 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 the Oracle database. | |
POJO Data Source See BIRT Application Developer Guide. | 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 the 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 BIRT Application Developer Guide. | 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. |