Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84854members
354319posts

HP-uCMDB to DCO 8.3.2 ETL Integration

EcoStruxure IT forum

A support forum for Data Center Operation, Data Center Expert, and EcoStruxure IT product users to share knowledge on installation, configuration, and general product use.

Solved
aashraf
Lieutenant JG Lieutenant JG
Lieutenant JG
0 Likes
2
696

HP-uCMDB to DCO 8.3.2 ETL Integration

Dears,

 

I have a customer who need to integrate the HP-uCMDB system with DCO8.3.2 system.

It's required to extract all assets and its info from HP-uCMDB system via system SOAP APIs and then transform and load the assets to DCO8.3.2 import staging database.

 

actually i developed the transformation (.ktr) and job (.kjb) files via spoon/pentaho PDI tool.

created an ETL configuration on DCO8.3.2, only to define the import staging database and selected no transformation as i'll run it from the pentaho tool manually for test.

i got the required data from the HP-uCMDB in the .csv files created in the transformation but there no thing passed to DCO staging database while all transformations run successfully without any errors.

 

and when i copied the transformation and job files to data/pentaho/import directory on DCO and selected my job file in ETL configuration, it looks like run successfully without any error in the etl-log file but in this case the .csv files which i use to receive the data from HP-uCMDB are empty which means that it didn't get the data from HP-uCMDB while the etl configuration looks like run successfully without errors. and of-course there no assets created into the staging database.

 

Do you have any idea, what may cause this issue?

 

Tags (2)

Accepted Solutions
shansen1
Schneider Alumni (Retired)
Schneider Alumni (Retired)

Re: HP-uCMDB to DCO 8.3.2 ETL Integration

Hi @aashraf, to my understanding you found help for this offline, so I'm replying to close the question. If that is not the case, please feel free to ask another question.

Thanks,

Stine 

See Answer In Context

Tags (1)
2 Replies 2
shansen1
Schneider Alumni (Retired)
Schneider Alumni (Retired)

Re: HP-uCMDB to DCO 8.3.2 ETL Integration

Hi @aashraf, to my understanding you found help for this offline, so I'm replying to close the question. If that is not the case, please feel free to ask another question.

Thanks,

Stine 

Tags (1)
aashraf
Lieutenant JG Lieutenant JG
Lieutenant JG

Re: HP-uCMDB to DCO 8.3.2 ETL Integration

Hi @shansen1 

You are right, You can close the question

Thanks,
aashraf

Tags (1)