How to configure BIRT reports

The first item that needs changing is the database name, URI (Server name and port number), username and password.
The majority of eShops, and all osCommerce based ones, use mySQL but others are permissable, so check with us for any necessary changes.
Your ProBIRTReport reads a special library file which you must configure for your database set up: You need only do this once for all ProBIRTReports you have.
The library will be called your shopping cart name followed by _data_source.rptlibrary (for example oscommerce_data_source.rptlibrary for an oscommerce site)
and will have a block of text as below:

    <data-sources>
        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="174">
            <property name="odaDriverClass">com.mysql.jdbc.Driver</property>
            <property name="odaURL">jdbc:mysql://your_host_name:3306/oscommerce?zeroDateTimeBehavior=convertToNull</property>
            <property name="odaUser">your_db_user_name</property>
            <encrypted-property name="odaPassword" encryptionID="encrypted_password">Y2J0dFU1TXg£</encrypted-property>
            <property name="OdaConnProfileName">BIRT JDBC Data Source</property>
            <property name="OdaConnProfileStorePath">yourshoppingcart_data_source.rptlibrary</property>
        </oda-data-source>
    </data-sources>

The database name is something you should either know or can find out from your server provider.

For osCommerce sites the name usually starts with oscommerce but is usually followed by an underscore and some numerals in the fashion below.

oscommerce_12345678

The database server name could be something like your websites URL without the www. but check with your server provider.
For mySQL databases, the port number for db requests is usually 3306 but, again, check with your server provider.
You can use the same database user as you use for running osCommerce or set up a new one:
If you are unfamiliar or not have personal access to your mySQL implementation ask your server supplier for support.
To encode your password in base64 you can use any web based encryption service- For example http://makcoder.sourceforge.net/demo/base64.php