Execute Data Load (Data Loading)

Summary

Uses the Data Reference workbook from the Data Loading Workspace to load data from a source to a target database.

Usage

• To remove features from the target schema before data loading, modify the Data Reference workbook.

Parameters

Dialog

Label	Explanation	Data Type
Data Reference workbook	The name of the Data Reference workbook defining the data source, target, and mapping workbook paths.	File
Load Data To: (Optional)	Select whether to load data to the target workspace or to a preview geodatabase.	String
Preview Output Folder (Optional)	The output folder where a Preview Geodatabase will be created. Data will be loaded to this Preview instead of the Target.	Folder

Python

arcpy.dltsolutions.ExecuteDataLoad(reference_workbook, {load_type}, {preview})

Name	Explanation	Data Type
reference_workbook	The name of the Data Reference workbook defining the data source, target, and mapping workbook paths.	File
load_type (Optional)	Select whether to load data to the target workspace or to a preview geodatabase.	String
preview (Optional)	The output folder where a Preview Geodatabase will be created. Data will be loaded to this Preview instead of the Target.	Folder

Code sample

ExecuteDataLoad (Python window)

The following Python window script demonstrates how to use the ExecuteDataLoad tool in immediate mode:

arcpy.dlt.ExecuteDataLoad(reference_workbook=workbook)

ExecuteDataLoad (stand-alone script)

The following stand-alone script demonstrates how to use the ExecuteDataLoad tool:

# Name: ExecuteDataLoad.py
# Description: Loads the source-target mapping defined in DataReference.xlsx

# Import required modules
import arcpy

# Local Variables
workbook = "D:/data/DataLoadingWorkspace/DataReference.xlsx"

arcpy.dlt.ExecuteDataLoad(reference_workbook=workbook)

Environments

This tool does not use any geoprocessing environments.

Licensing information

• Basic: Yes
• Standard: Yes
• Advanced: Yes