DCO - ETL Database Integration - Export

[DCIM_Support]

We have configured a DCO internal database export and so that our other server can connect to it and extract it on daily basis for report generation and analysis.  I have reviewed the documentation below and have been able to configure it successfully. 

We are able to connect to it using the configured user id and password and can see all the schema tables.  However, there is **no data** at all in all tables.  Can you advise what could be wrong and if there is anything else we need to do?

http://sxwhelpcenter.ecostruxureit.com/display/public/DCIMDEVELOPER/ETL+External+System+Configuratio...

(CID:130681519)

[DCIM_Support · Accepted solution]

Hey YJ,

Had a time to finally go thru that.

You need to wait till the scheduled export time for data to show up, earliest is 1 hour.

Below are my test using the default ETL export scripts in DCO.

Steps

1. Create ETL Export Out

 

  2.Set ETL external system in DCO

 

3.Connect using pgadmin

4.After the specified scheduled amount of time:

Troubleshoot connection issue

Follow steps here:

http://sxwhelpcenter.ecostruxureit.com/display/DCIMDEVELOPER/ETL+-+Change+allowed+IPs

Range of ip address filter, e.g 0.0.0.0/0

http://sxwhelpcenter.ecostruxureit.com/display/DCIMDEVELOPER/Configuring+network+connections+in+the+...

(CID:130681551)

[DCIM_Support]

It is working now, thanks Chris.

(CID:130682900)

[DCIM_Support]

You can also run the export on demand.

Planning - Device Association - ETL Integrations

Right click the desired External System and select run now.  See Setting Up an ETL Configuration

"Run now! will run the transformation and update the database accordingly."

(CID:130682094)

[DCIM_Support]

There isn't a "Run now" button on my windows client.

(CID:130682904)

[DCIM_Support]

Apologies, it's called "Synchronize external data".  

(CID:131958792)

[DCIM_Support]

Thanks Ed, found it now.

(CID:131964915)

[DCIM_Support]

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