Hitachi Vantara Pentaho Community Forums
Results 1 to 8 of 8

Thread: Add DataSource to Report Wizard

  1. #1

    Default Add DataSource to Report Wizard

    Hi,

    How do I add a new data source to the report wizard. During my evaluation phase, I would like to be able to connect to my sample SQL Server Sample DB. I managed to connect to the db when using the sun.jdbc.odbc.JdbcOdbcDriver in BIRT. Can I copy that to use with the Pentaho reportwizard?

  2. #2
    Join Date
    Nov 1999
    Posts
    579

    Default Re:Add DataSource to Report Wizard

    You could, but we don't recommend it. The JDBC/ODBC bridge drivers aren't all that robust or fault tolerant.

    I suggest you use the free MSSQL JDBC driver available from Microsoft. http://www.microsoft.com/downloads/d...displaylang=en

    Take care,

    Marc

  3. #3
    Join Date
    Jan 2006
    Posts
    460

    Default Re:Add DataSource to Report Wizard

    To use different database drivers, drop the jars/zips into the /lib/jdbc folder (under the Report Design Wizard root). The lib/jdbc path is put on the java.endorsed.dirs list so they will be picked up automatically.

    -Mike

  4. #4

    Default Re:Add DataSource to Report Wizard

    After reading the responses to my posting I did the following:

    1) I downloaded the MSSQL JDBC driver available from Microsoft as a tar file

    2) I unzipped mssqlserver.tar file

    3) I copied the msjdbc.tar included in the mssqlserver.tar file to the lib/jdbc directory

    4) I restarted the database and the JBOSS, then started the reportwizard

    5) I still only have the 5 original source in the field JDBC Driver Class, should not my new data source be avilable from this field?



    Cheers!

    Post edited by: jerics99, at: 01/19/2006 09:30

  5. #5
    Join Date
    Nov 1999
    Posts
    579

    Default Re:Add DataSource to Report Wizard

    Hi there,

    The example connections are currently hard-coded in the file org.pentaho.jfreereport.utility.JDBCUtility. In the future, users will be able to add examples to this list for their specific JDBC driver.

    No matter though - just because there isn't an example of the MSSQL driver connection settings, you can simply enter your connection settings into the fields - consult the JDBC driver documentation for the entries to put in each field. After you enter your connection settings, click the save button to save your connection information into a file that you can load when you're designing your next report.

    Take care,

    Marc

  6. #6

    Default Re:Add DataSource to Report Wizard

    The reportwizard goes down without any error messages when trying to use the new datasource.

    1) I start the wizard

    2) I define the datasource as shown in the screen shot and test it with the OK response (no password needed for user sa)

    3) I add the data set query (tested OK in Query analyser)

    4) I click next

    5) The wizard dissapears without messages

    Bye! http://forums.pentaho.org/archived_att/files/Doc1.doc

    Post edited by: jerics99, at: 01/19/2006 11:54

  7. #7
    Join Date
    Nov 1999
    Posts
    579

    Default Re:Add DataSource to Report Wizard

    Hi there,

    Your JDBC driver class and URL are wrong for the MSSQL driver. You've specified information as if you're using the JDBC/ODBC bridge.

    Please consult the JDBC driver information for the valid connect string information.

    For example, the class for the Microsoft driver should be something like this:

    Code:
    com.microsoft.jdbc.sqlserver.SQLServerDriver
    The JDBC URL should look something like this for the Microsoft driver:

    jdbc:microsoft:sqlserver://yourmssqlserver:1433;selectMethod=cursor;databaseName=yourDatabase

    The above examples were for the Microsoft JDBC driver for MSSQL 2000. If you're using a different version of the driver (such as the new one for MSSQL 2003), this information may be different. Please consult the samples that came in the Microsoft JDBC driver documentation.

    Take care,

    Marc

    Edited: Fix JDBC URL.

    Post edited by: mbatchelor, at: 01/19/2006 12:28

  8. #8
    Join Date
    Jan 2006
    Posts
    460

    Default Re:Add DataSource to Report Wizard

    I'm just checking to see if you have resolved any problems you've been having with the Report Design Wizard.

    Even if you were able to get past these problems in 0.9.1, I highly recommend you try 0.9.2.

    Thanks-
    Mike

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.