Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: New Openedge datasource in biserver error

  1. #1
    Join Date
    Aug 2011
    Posts
    10

    Default New Openedge datasource in biserver error

    I'm attempting to add a Openedge datasource to biserver. I don't really run into any problems until I try to make the source type Database tables.

    I saw this error in the metadata editor. This is the error.

    Couldn't get field info from [SELECT * FROM arsc]


    [DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/View/Synonym not found (7519)

    Now if I do an SQL Query as the source type and hard code that query to

    [SELECT * FROM PUB.arsc] (PUB is the schema)

    Query comes over good.

    Any settings I can change to prefix the schema on Database Tables source type?

  2. #2
    Join Date
    Aug 2011
    Posts
    10

    Default

    My bad,

    I did not know you can specy the scema in the connection string.

    ;jdbc:datadirectpenedge://hostort;databaseName=db_name;servicename=service_name;defaultSchema=schema_name;statementCacheSize=CacheSize

    Fixed.

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.