ImportTool

ImportTool

ODBC Table and View Data Import

ImportTool is included in the following subscription products


Need to get data from ODBC data sources into Teradata quickly? Need to get your Teradata data into ODBC? ImportTool is the answer!

ImportTool is designed to make data movement between ODBC data sources and Teradata a snap. Point-n-click and drag-n-drop enabled to get you quickly on your way to getting the data where you need it the most.

Using ImportTool is simple - open an ODBC data source and a Teradata or ODBC data target. Select source tables and views for data import, specify the import target options and click the execute button.

ImportTool will perform the data transfer and display progress and log information as it works.

Save ImportTool configurations as an AtanaSuite Active Script Job to run later or reuse.

Reduce time spent recreating a data import job that needs to be executed multiple times. Simply create and save it once in ImportTool and then use JobTool to run it over and over again.

ImportTool Screenshots

Click on an image below to expand.

ImportTool Databases

ImportTool Databases

ImportTool Objects

ImportTool Objects

ImportTool Progress Log

ImportTool Progress Log

ImportTool Features

Some of the key features within AtanaSuite ImportTool

Feature
Table and View Data Import
Drag-n-drop ODBC tables and views from Available Tree to Selected Tree. Specify column lengths where needed, limit data using the provided where clause filter and click the Execute button. Integrated progress bar and detailed log provided for monitoring and review. Even supports copying data using views. AtanaSuite Active Script enabled as well!
Feature
Multiple Results Display Options
Multi-column grouping, filtering, ordering and sorting provide all the necessary features for individually customizing the operation results display.
Feature
Concurrent Data Copy Support
Set your max number of concurrent operations in prefs and then let ImportTool copy data concurrently.
Feature
Drag-n-Drop Object Selection
Simply select an object or objects and drag-n-drop them into the selected area.
Feature
Data Copy Filter
Restrict the amount of data copied by using the data copy filter.
Feature
View Data Copy
Copy data using views.
Feature
Fast Indeterminate Column Data Type/Length Resolution
Quickly address any indeterminate column data types and lengths by using “Go To Error” shortcut key, menu item or toolbar button.
Feature
Results Export
Available throughout the product that provides exporting results to the most popular formats including Excel.
Feature
Object Type Option Specification
Select an object type, like tables, and apply the selected options for all tables. Select an individual object to override the object type option setting for the selected object.
Feature
Combined Progress Log
Window displays realtime operation progress and detailed operation results log.
Feature
Active Script Enabled
Save commonly executed operations as an AtanaSuite Active Script job that can be opened later within JobTool for execution, modification and scheduling.