Hitachi Vantara Pentaho Community Forums
Results 1 to 9 of 9

Thread: Importing jobs and transformations

  1. #1

    Default Importing jobs and transformations

    Through 'File / Export / Linked Resources to XML...' I can export a job and all the components inside. This creates a zip file in the selected directory.
    But how can I import such a zip file?
    It seems I have to import each job and transformation separately.

    I have updated jobs and transformation to build a dimension. Now I want to export this and import it in production. So I would like the easiest way to import the chages to production, not having to import each job and transformation separately.

    Thanks.

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

    Default

    From the dialog that pops up...
    This resource and all linked resources have been exported to ZIP file [c:\temp\export.zip].
    Relative paths to referenced input files have been altered as we had the change the references to an absolute path inside a parameter in the various steps.
    Note: the absolute path is set as the default for the generated parameters.

    This resource can be executed inside the exported ZIP file without extraction.
    You can do this by executing the following command:

    Kitchen.bat /file:"zip:file:///C:/temp/export.zip!MyJob.kjb"
    Please note that you can open this file with File/Open file from URL. Enter this URL to open it:

    zip:file:///C:/temp/export.zip!MyJob.kjb

    Finally, a new File Repository was added with a link to this ZIP file.
    You can run the job from the command line...

    Also, in Spoon, there is an "Import Repository" option, which will let you load the ZIP file to your production repository.
    Last edited by gutlez; 02-01-2011 at 12:35 PM.
    **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

  3. #3

    Default

    The "Import repository" gives me an error: Content is not allowed in prolog.
    Using the URL I can again only open one file at a time.
    It would be nice to select the zip file for import, and that PDI woudl tell me for each item inside if it is aready in the repository, and if it has changed, or that it is new. I could then import only the items that have changed or are new.

    Is something like that possible?

  4. #4
    Join Date
    Nov 2008
    Posts
    143

    Default

    In 3.2 it used to prompt you in case the Job/Transformation already existed.
    is it not doing that anymore?

  5. #5

    Default

    It does, but it does not tell me if it has changed compared to the existing one. If it hasn't changed there's no need to import.
    Otherwise I have to manually note which jobs and transformations have changed in accept, and only import those in production.

  6. #6
    Join Date
    Nov 2008
    Posts
    143

    Default

    I believe this sort of feature is only available on the EE version.
    On the other hand, if it hasn't changed, then there's no problem in overwriting it, right?

  7. #7
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Export linked resources was specifically created to run complete jobs on remote servers. As such it slightly alters the ETL metadata to make this possible.

    For importing purposes into another repository simply use the Tools/Repository/Export menu (or the repository export job entry).

    HTH,

    Matt

  8. #8

    Default

    Quote Originally Posted by renatopb View Post
    I believe this sort of feature is only available on the EE version.
    On the other hand, if it hasn't changed, then there's no problem in overwriting it, right?
    Not really, only the database connections will have to be updated to read from prod instead of accept.
    I am using the EE version.

  9. #9
    Join Date
    Nov 2008
    Posts
    143

    Default

    You could eliminate even that if you change your database connections to use variables defined in your kettle.properties, or switching them to a generic jdbc with jndi.
    Kettle comes with a SimpleJNDI thing that really helps.

    Cheers,

    Renato

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.