Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Upgrade existing version of PDI

  1. #1

    Default Upgrade existing version of PDI

    Hi all,

    I need your advice on upgrading the version of our PDI.

    We have a PDI v4.4 based on a MS SQL Server DB.

    Now my boss want to upgrade to version 7... yes I know it's like a suicide.

    I've tried to go thru the documentation and I've found something but it's only for the Enterprise Edition... of course we have a Community Edition.

    Does anybody have an idea on how I can achieve it ?

    1. My plan is to backup the DB / repository.
    2. Install PDI and create a new repository on a new machine.
    3. Export the OLD repository (even if the export file will be huge - at least 2 GB)
    4. Import the OLD repository to the NEW repository.

    Do you think it will work ?

    Thanks in advance for any suggestion.

    Alessio

  2. #2
    Join Date
    Aug 2011
    Posts
    236

    Default

    Hi Alessio,

    That's the method I have always used but i am not sure you can go from v4 to v7 directly. I have always gone through the major versions - v4 -> v5 -> v6 -> v7.

    Others might have more input.

    Thanks.
    PDI 8.0.0
    MySQL - 5.6.27
    Redshift - 1.0.1485
    PostgreSQL 8.0.2
    OS - Ubuntu 10.04.2

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

    Default

    That looks like it will work, but you need to add a step:

    2A) Install MSSQL JDBC Driver (either jTDS or MSSQL Native as is appropriate for your transforms)
    2B) Create new PDI7 Repository on MS SQL

    as the jTDS driver is no longer included in the PDI7 install package.
    Last edited by gutlez; 02-06-2017 at 02:21 PM.

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.