Setting an external data source in Maximo

magic_bern

Hi All,
I am trying to configure an external data source (from report administration in Maximo) in order to connect to an sql server and run BIRT report from Maximo.
However, every time i test the connection i always have the error " BMXAA6331E - Check the driver name. com.microsoft.sqlserver.jdbc
com.microsoft.sqlserver.jdbc "
i have tried many different driver and URL but i keep getting the same problem. Has someone manage to create external report and deploy them using an exterman maximo datasource?

Thanks in advance for the help.

Silerfun

** Oops, I thought you were talking about report writing with BIRT connecting to maximo, and not adding a seperate external source from within maximo. **<br />
<br />
Yes, what you need to do is install the the JDBC driver on your computer that you are doing the report writing from. To do this go to the following folder on your Maximo Server <Maximo>\applications\maximo\lib and copy opta.jar to (your computer) eclipse\plugins\org.eclipse.birt.report.viewer_2.1.1v20070205-1728\birt\WEB-INF\lib<br />
the org.eclipse.bir.report.viewer_ might have a different number depending on what version of BIRT you are running.<br />
<br />
Now, to make the External Data Source, right click on Data Sources and select New Data Source. Select JDBC Data Source name it and click next. In the Manage Drivers... button make sure you see your opta.jar in there if not click on add and go to the directory on your machine where you copied over the opta.jar file and add it.<br />
<br />
Now, you should see the TdsDriver in the Driver Class drop down. Select this and fill out the following connections:<br />
<strong class='bbc'>Database URL</strong>: jdbc:inetdae7a:<MaximoServerSQLIP>:1433?database=<DatabaseName>&language=us_english&nowarning<br />
Replace <MaximoServerSQLIP> with your maximo Sql server ip address and <DatabaseName> with the name of the database you want to connect to.<br />
<strong class='bbc'>User Name:</strong> <Username that has read access to database> (default user is MAXIMO)<br />
<strong class='bbc'>Password:</strong> <Password of Username> (default PW is MAXIMO)<br />
Leave the JNDI URL blank.<br />
<br />
If this is an out of the box setup the username and password will be MAXIMO which is the user that is able to read all databases on Maximo.<br />
<br />
Let me know if this works or not for you. After you have the database connection you will have to change in your Data Sets to use your new Data Source for your reports to work.<br />
<br />
I also attached a pdf to explain a little more on how to setup birt on your machine.