Entering content frame

Component documentation Loader Locate the document in its SAP Library structure

Purpose

You can use the Loader database tool to import application data and the database catalog to a MaxDB database instance or export them from a MaxDB database instance.
Since you can also run MaxDB database instances in ORACLE SQL mode, it is also possible to import or export data to and from ORACLE databases.

You can use the Loader to import and export both the database catalog and application data including LONG columns. This data can have various formats, date and time values as well as NULL values can be converted, and character sets can be mapped.

You can import or export the data for all users in a database instance, all tables relating to a specific user, one table relating to a specific user, or a number of qualified columns in a table or several tables.

The database catalog and application data can be exported to files, pipes, and external media (for example, a tape). Data can be imported only to the MaxDB database instance.

The Loader is a command line tool and can be used on all operating systems supported by the database system.

Implementation Considerations

The Loader is part of the MaxDB software package, which you can download from the MaxDB Website (see Download and Installation Profiles).

For further information about the database system, see the documentation Concepts of the Database System and the Glossary.

Integration

You can use various programming languages to access the functions of the Loader. In this way, for example, you can load data automatically using your own programs.

Programming Interfaces

 

Modules

Documentation

Java

com.sap.dbtech.powertoys.Loader, com.sap.dbtech.powertoys.LoaderException

Call With the Java Interface of the Loader

Perl

loaderperl, loader, instperl

Perl Manual, SAP::DBTech::loader Module

Python

loader bzw. loadermodule

Python Manual, sapdb.loader Module

Features

The documentation includes the following information about the Loader:

·        Data and How It Is Transformed

·        Calling the Loader

·        Commands and SQL Statements

·        Log Functions

Overviews

·        Terms: Overview

·        Syntax Rules: Overview

·        Key Words: Overview

 

Leaving content frame