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 reduce migration time. The DIY(Do It Yourself) wizards make the data exports and imports much more manageable 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 migrating to the TCPWave IPAM from a legacy DDI solution or Excel spreadsheets. It is common to see the legacy DDI solutions have a significant amount of abandoned or orphaned data. The TCPWave DDI import wizards are tuned with performance optimizations geared for large organizations. 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 present in 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 select the functions used to perform the export or import operations. The user is then prompted through a series of screens by clicking the following, next, and OK buttons. After the user interaction is completed, the TCPWave DDI performs the desired export or import action. The errors found during the import process can be remediated by adding the required data 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. The DDI administrator must have at least read-only permission to perform the export operations. 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