Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: C# Application with Kettle

  1. #1
    Join Date
    Jan 2014
    Posts
    2

    Exclamation C# Application with Kettle

    Hi,

    I want to develop a C# application using Kettle to run Kettle functions and commands.

    How I can use Kettle with Visual Studio? Is there a dll to reach Kettle?

  2. #2

    Default

    Kettle is a Java application, it has no DLL that you can easily call (although you can use JNI from C++, this is not very easy to do).

    What you can do is run Kitchen.bat or Pan.bat from a C# application. If you need tighter integration with the Kettle runtime than you can get from the command line, you'll have better luck building your application in Java instead of C#, or finding an ETL framework based on .NET.

  3. #3
    Join Date
    Jun 2007
    Posts
    233

    Default

    Hi Burcu,

    Doing a C# app with Kettle /PDI is going to be a hell of a lot of work. If you are determined to head down this path you might want to consider some machine translation tools to assist in porting the codebase across. Sharpen is one such tool that is reportedly capable of migrating java to c# quite well. It wont be perfect, but it woul dbe a big head start. You can read about it here: http://en.wikipedia.org/wiki/Sharpen
    Everything should be made as simple as possible, but not simpler - Albert Einstein

  4. #4
    Join Date
    Jan 2014
    Posts
    2

    Default

    Thanks for your replies. So can I use a function (ie import function) under a button in C# appliacation when I convert java codes to C# or call dll ? and lastly does this site(https://github.com/pentaho/pentaho-kettle) constain all kettle java codes? I suppose that it doesn't..

  5. #5
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    burcu,

    You are trying to do something similar to using your bicycle wheels on your car.
    jsturm advised you that you will likely need to do a LOT of work to make this happen, and that you would be better off building the part you are building (your car) to use the parts provided (the bicycle wheels) instead of trying to make the parts fit what you're still building.

    C# and Java are different languages. They are not directly compatible. You cannot call java functions from C# easily. You cannot call C# functions from java easily.

    Your choices at this point:
    1) Rewrite PDI in C# (a LOT of work)
    2) Write your application in java (may be easy)
    3) Use shell commands (call an external program) from your program to use PDI. There will be no direct interaction in this method.
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

Tags for this Thread

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.