ETL data export to internal DB

[DCIM_Support]

This question was originally posted on DCIM Support by Akihiro Yamagami on 2018-09-13

---

I'm still new to ETL and trying to export data using DCO ETL but I cannot find any data on export data base.

I took the following procedures.

1. Created export data as internal database based on the documents below.
   http://sxwhelpcenter.ecostruxureit.com/display/public/DCIMDEVELOPER/ETL+Database+Configuration
2. From DCO Client, I have configured ETL integration. I choose "No transormation v 1.0.0" for transformation.
3. Using spoon client, I could connect with the export data base and see the table definitions but cannot find any data record in it.
   
   

What's steps are additionally required to export data?

P.S.

 In case of importing data,  I could successfully import data and confirm the records in import database. 

Regards,

Akihiro Yamagami

(CID:134031178)

[DCIM_Support · Accepted solution]

This answer was originally posted on DCIM Support by Christopherus Laurentius on 2018-09-13

---

The etl export follow scheduled export time set during configuration in dco.

You can force the external system,from dco client under associate device,right click choose synchronize external data,so you can see those data.

(CID:134031197)

[DCIM_Support]

This comment was originally posted on DCIM Support by Akihiro Yamagami on 2018-09-13

---

Hello

Thank you for your comment! I setup export database yesterday with 1 hours schedule and also sync the data. But, I cannot see any data record...

I also attach the screenshots.

• Webmin setting
• DCO client settings

• sync on DCO client 

• records on spoon (sorry, includes local characters)
  
  
• records on psql (configuration_item)

(CID:134031270)

[DCIM_Support]

This comment was originally posted on DCIM Support by Christopherus Laurentius on 2018-09-13

---

Pictures really say a thousand words 😀

Use the other option, swoExportJob when you set up the test for export like below:

I was using pqadmin to test out, but the idea is you can see data from the export db tables.

(CID:134031285)

[DCIM_Support]

This comment was originally posted on DCIM Support by Akihiro Yamagami on 2018-09-13

---

Hello Christopherus!

Thank you for your quick response.  I could successfully see many records!!! Thank you.

Regards,

Akihiro Yamagami

(CID:134031308)

[DCIM_Support]

This comment was originally posted on DCIM Support by Akihiro Yamagami on 2018-09-13

---

This topic will be also helpful for entire community. So, I will make this topic to "public".

(CID:134031364)

[DCIM_Support]

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.