Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Connection of pentaho with paradox database

  1. #1
    Join Date
    Nov 2013
    Posts
    2

    Default Connection of pentaho with paradox database

    Name:  reportdesignerDBConnection.jpg
Views: 42
Size:  31.6 KBName:  BIserverDBConnection.jpg
Views: 30
Size:  25.5 KB

    I made a connection to a Paradox database with report designer. in working with the web page ("http://localhost:8080/pentaho/Home") I could not make this connection to make a dashboard.
    I noticed as shown in the two images that with report designer there are three choices "Native (JDBC), ODBC, JNDI" so that in the other hand there is only "Native (JDBC)".
    Please explain why this difference and how I can add these three choices in the Users page bi-server ("http://localhost:8080/pentaho/Home")


    thank you

  2. #2
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    Is your server running on a Windows system? ODBC is a Windows-only technology (although there is a specification for other platforms, most database vendors do not bother - for cross platform support they provide either native libraries or JDBC drivers).

    If your database vendor does not supply a JDBC driver (and with Corel's history I doubt they do) then you would have to buy a commercial driver from a 3rd party vendor, or setup a Windows server to run your BI-server installation. Either way it wont be a free option, you either pay for the driver or for your Windows server licenses.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  3. #3
    Join Date
    Nov 2013
    Posts
    2

    Default

    I work on windows, also I have INTERSOLV driver that i created with him many ODBC data sources (I have already used these with talend).
    I do not understand why the connection works with report desigenr and not with the server page(localhost:8080)
    is there a configuration in the server to allow the same configuration of report designer?

  4. #4
    Join Date
    Apr 2012
    Posts
    253

    Default

    Maybe the floppy is dying. I'm sorry, I'm sorry, I just couldn't resist.

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.