Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: How to connect to a OLEDB Driver/Provider using Spoon.

  1. #1
    Join Date
    Jan 2017
    Posts
    2

    Default How to connect to a OLEDB Driver/Provider using Spoon.

    Hi All,

    How can we connect to OLE DB Provider from Spoon . Can any one share any reference documents or links regarding it.

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Java (Spoon) doesn't talk to OLEDB without a bridge driver.
    What's the datasource behind your OLEDB driver?
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Jan 2017
    Posts
    2

    Default

    Thanks for Response.
    Can you share any links regarding connecting through a bridge server.

    We are trying to Connect to below sources.
    1.Honeywell PDH (https://www.honeywellprocess.com/en-...mance-phd.aspx)
    OLE DB driver is provided by honeywell itself
    2.Matrikon Simulator (http://www.matrikonopc.com/).third party provided driver.

  4. #4
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    No experience with OPC here.

    OPC relies heavily on MS technology, I understand.
    If you have access to a MSSQL instance, you can configure PHD as a linked server.
    MSSQL will talk OLEDB to the PHD and Kettle can talk JDBC to MSSQL.

    Matrikon Simulation Server seems to talk OPC (UA?) and nothing else, so maybe Web-Services-Lookup can help you.
    So long, and thanks for all the fish.

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.