Data Export and Import Operations

TCPWave-VRA
Data Export and Import Operations

The TCPWave IPAM is shipped with a myriad of wizards and tools to make your life easier and to reduce the time taken to migrate. The DIY(Do It Yourself) wizards make the data exports and imports much easier and can save you hours of work during the pre-migration, migration, and post-migration process. They also provide valuable insight into your existing data quality especially when you are migrating to the TCPWave IPAM from a legacy DDI solution or from Excel spreadsheets. It is common to see the legacy DDI solutions to have a significant amount of abandoned or orphaned data. The TCPWave DDI import wizards are tuned with performance optimizations geared for large enterprises. They can process thousands of records per second. They can absorb the data that meets the TCPWave DDI referential integrity constraints. They produce an exception file that the DDI administrator can use to examine and perform additional analysis.

IPAM

The DDI data, that is present in the form of Excel spreadsheets can easily be uploaded into the TCPWave DDI solution with minimal transformations. You can run the export and import wizard on a development TCPWave DDI instance and perform an overall data quality analysis of your DDI data. To open the export and import wizard, the DDI administrator would choose the Bulk Operations menu item in the user interface. When the wizard appears, you will see a screen that allows you to choose the functions that can be used to perform the export or import operations. The user is then prompted through a series of screens by clicking the next, next, and OK buttons. After the user interaction is completed the TCPWave DDI performs the desired export or the import action. The errors found during the import process can be remediated by adding the required data that is needed for TCPWave DDI's data integrity constraints. For example an orphaned CNAME record without the matching A record would show up in the exception report. Similarly, the orphaned mail exchanger records can be cleaned up because a legacy mail server's object definition was deleted but the corresponding MX records were not deleted. To perform the export operations, the DDI administrator must have at least read-only permission. For the import operations, read-write permission is required to process the input files and add new entries to the DDI database

IPAM

The table below shows the various types of input files that can be exported or imported using the TCPWave DDI DIY wizards

TCPWave-ServiceNow

The table listed below provides a list of CLIs related to the import operations.

TCPWave-ServiceNow

The table below provides a list of CLIs related to the export operations.

TCPWave-ServiceNow
TCPWave-Terraform