When we first installed DCO 5 years ago there was no facility to update cabling information using csv or xls files after the initial established system installation. In other words to add another datacentres connectivity information to the established system would mean manually inputting all the connectivity. We have continued in this vein since, but I thought I would ask again if this situation has changed (perhaps with the migration to ITA?) We have more locations coming online and would like to know if there will be an opportunity to upload a csv or similar before doing it all manually.
Can you describe the type of connections you'd like to make via an import like function? If you are adding data centers I assume then you are referring to making network connection between racked assets and then from the rack to other devices in the room(s)?
It is possible to make/create network connections between items using an ETL Import database but this can be complex to manage.
Given your post mentioned bringing more locations online it would seem you would be planning to build new rooms? DCO and ITA both have the ability to enable a equipment import tool which allows the user to download a xls template from which you can add devices, their custom properties, tags, power connections, and network connections ... then import them.
This tool has a few caveats in that its meant as an engineering tool which is why its not enabled by default, and its solely meant for importing/creating items ... not updating. Used incorrectly is can lead to unexpected results.
I will send you a direct email with more details as I cannot post the template in this forum.
Also, in the future it is likely ITA will have a set of REST api's customer will be able to use to perform network operations like connection maintenance and so on. These are not available yet.
The type of connections for this required event will be inputting patching, mostly in rack patching, between servers and switches already installed in the system. We do have new locations being added but these will mostly be already installed in the system (location/room/rack/equipment) before the patching stages, in other words a large install of all the nested equipment and its patching cannot be run in one upload.
I was aware of the upload sheet method that is not configured by default but also recognise that this system has limitations of requiring the deletion and re-adding of all the connectivity (e.g. upstream UPS etc.). I understand the caveats of this system and frankly it does not fit our needs as I need the remote teams in other regions to update their systems, simply, at their leisure. Using a csv or similar upload function for patching would help accelerate the data upload.
As the locations involved have small numbers of racks to update I think it is easier for the local engineers to update the patching using the manual tools. If the numbers of racks were say, in to 3 figures, we might need to re-assess though.
I think we can close this ticket but I remain interested in developments in this area, if as you suggested, there might be future functionality in ITA using REST API.
Hello Nigel. I will share your feedback.
The xls import sheet can be used on subsets of the room, in fact that is typically how the tool is used by services and some cases customers.
So if you are building out a new 10 rack section of an existing room, there is no reason you cannot use the template to import the 10 racks, their assets and connections for just those items. None of the other room items would be impacted.
If the assets (racks and servers for example) are already built out in DCO or ITA then its probably less useful.
Discuss challenges in energy and automation with 30,000+ experts and peers.
Find answers in 10,000+ support articles to help solve your product and business challenges.
Find peer based solutions to your questions. Provide answers for fellow community members!