Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: LDAP to multiple SQL tables (Best strategy?)

  1. #1
    Join Date
    Feb 2017
    Posts
    14

    Default LDAP to multiple SQL tables (Best strategy?)

    What is the best strategy to move user records from an LDAP store to an SQL table configuration where the data will be split into multiple tables?

  2. #2
    Join Date
    Aug 2011
    Posts
    360

    Default

    Well, we need more details but my opinion is the best strategy would be:
    1. Stage your LDAP data into some raw tables
    2. Build your new model starting from the raw stagged tables.

    So you basically need to define what you want to extract from your LDAP.
    Then this is same-as-always data integration

  3. #3
    Join Date
    Feb 2017
    Posts
    14

    Default

    Thanks for your reply. I have a completed transform project for all the ldap data. The result is of course a single flat table with all data elements.

    I wondered if there was a way to have Kettle deconstruct it during the transformation, and store some attributes in table A and some in Table B. If not, then I'll take my flat table and come up with some SQL magic to split it up.

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.