Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Is There A Straight Forward Tutorial On Scheduling/Running ETL Jobs On BI Server

  1. #1

    Default Is There A Straight Forward Tutorial On Scheduling/Running ETL Jobs On BI Server

    I've been all over google and everything seems incomplete, assumes I already know what I'm doing or is way, way more complicated than it has to be. I just have simple import jobs I need to run and would love to let my non developer staff run in the BI Platform. Apologies if this is a bad question. Just a rookie trying to get a head start.

    Cheers,

  2. #2

    Default

    Just a little bump. Again, I've heard you can schedule ETL/Kettle jobs via the BI Server using xActions but there seems to be a whole lot of methods to do this and I kind of got lost in the results. Is there a straight forward way to manage/schedule my transformations via the BI Server this way?

  3. #3

    Default

    Anyone have knowledge of this?

  4. #4
    Join Date
    Jan 2013
    Posts
    101

    Default

    I use cron with kitchen to run pdi jobs on ubuntu server running bi server. Refer to this. You can just copy your client data-integration folder over to server. Make sure the paths are the same.

    http://forums.pentaho.com/showthread...highlight=cron

    Mike

  5. #5

    Default

    Quote Originally Posted by arcelio1023 View Post
    I use cron with kitchen to run pdi jobs on ubuntu server running bi server. Refer to this. You can just copy your client data-integration folder over to server. Make sure the paths are the same.

    http://forums.pentaho.com/showthread...highlight=cron

    Mike
    Thanks for the response. But what I was hoping to do was use the BI Server's native scheduling as xactions so I can manage my jobs via the web interface.

    Is that possible?

  6. #6

    Default

    Create a Xaction file like this:

    <?xml version="1.0" encoding="UTF-8"?><action-sequence>
    <title>Execute KTR Transformation/Job</title>
    <version>1</version>
    <logging-level>debug</logging-level>
    <documentation>
    <author>My Name</author>
    <description>A xaction running a Kettle Transformation/Job</description>
    <result-type></result-type>
    </documentation>


    <inputs/>


    <outputs/>


    <resources>
    <transformation-file>
    <solution-file>
    <location>myTransformationFile.ktr</location>
    <mime-type>text/xml</mime-type>
    </solution-file>
    </transformation-file>
    </resources>

    <actions>
    <action-definition>
    <component-name>KettleComponent</component-name>
    <action-type>Execute Kettle Transformation</action-type>
    <action-inputs/>
    <action-resources>
    <transformation-file type="resource"/>
    </action-resources>
    <action-outputs/>
    <component-definition/>
    </action-definition>

    </actions>
    </action-sequence>


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.