{"id":633032,"date":"2019-10-21T15:50:37","date_gmt":"2019-10-21T22:50:37","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=633032"},"modified":"2019-10-21T16:02:14","modified_gmt":"2019-10-21T23:02:14","slug":"getting-to-know-the-data-loading-tools","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-solutions\/data-management\/getting-to-know-the-data-loading-tools","title":{"rendered":"Getting to Know the Data Loading Tools"},"author":10032,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23851,25741,23051],"tags":[25891,43801,27911,23081,23571],"industry":[],"product":[421922,42661],"class_list":["post-633032","blog","type-blog","status-publish","format-standard","hentry","category-data-management","category-electric-gas","category-water","tag-arcgis","tag-migration","tag-tutorial","tag-utilities","tag-whats-new","product-arcgis","product-arcgis-solutions"],"acf":{"short_description":"The Data Loading Tools streamline loading data from a source to a target dataset, providing the ability to perform in-process data transformation","flexible_content":[{"acf_fc_layout":"content","content":"
\n

This blog gives an overview of the recently released Data Loading Tools.\u00a0 The Data Loading Tools streamline loading data from a source to a target dataset with the ability to perform in-flight data transformation. For those who used the tools when they were shared on GeoNet as a preview and were called Data Translation Tools, you\u2019ll need to remove the conda package from the preview.\u00a0 Instructions are at the bottom of this post.<\/p>\n

To understand how you can leverage the Data Loading Tools, imagine you have to bring data from one file geodatabase to another file geodatabase. This is also known as Extract, Transfer, and Load (ETL). Let me set the stage.<\/p>\n<\/div>\n

In this scenario, we have a file geodatabase or fgdb for short. Let’s call this fgdb, our source.\u00a0 Inside this geodatabase, we have a feature class named Cars.\u00a0 We have three subtypes in this feature class: Red, Blue and Green. There are domains assigned to each of these subtypes. I want all my data in this feature class to shuttle over to my target file geodatabase. This target fgdb has a feature class called Trucks with different schema. Schema is a term that includes attributes, data types, domains, and other data management concepts. The Trucks feature class has three subtypes as well, but they are different than those found in Cars. They are One, Two, and Three rather than Red, Blue and Green.<\/p>\n

There are three ways to translate data with the workbook. The first method does a straight field mapping<\/strong> using an expression. The second method uses a sheet as a lookup table<\/strong> for domains. The third method uses the Expression<\/strong> field to handle a variety of other tasks in a flexible way. I will cover each method in this blog.<\/p>\n"},{"acf_fc_layout":"content","content":"

The first tool in our Data Translation toolbox is Create Data Loading Workspace<\/p>\n