{"id":27845,"date":"2018-11-15T09:13:00","date_gmt":"2018-11-15T08:13:00","guid":{"rendered":"https:\/\/alistar.net\/?p=27845"},"modified":"2026-10-02T16:40:39","modified_gmt":"2026-10-02T14:40:39","slug":"importing-multiple-xml-files-in-azure-sql-database-with-azure-data-factory","status":"publish","type":"post","link":"https:\/\/alistar.net\/en\/blog\/meerdere-xml-files-importeren-in-azure-sql-database\/","title":{"rendered":"Importing Multiple XML Files into Azure SQL Database"},"content":{"rendered":"<p class=\"wp-block-paragraph\">For this blog post, our goal is to load multiple XML files into a database so that we can distribute their structure across separate tables. An additional complication is that the XML files have different filenames with each delivery. This is a fairly common scenario, for example, in bank payments. But how do we actually set something like this up in Azure?<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Non-Azure architecture<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">First, let\u2019s compare this to a non-Azure environment, where something like this is generally easy to implement. For example, the XML files are stored in a network location within the company\u2019s own network. A database such as SQL Server runs on the company\u2019s own database server and can retrieve a list of XML files from that network location. SQL Server then iterates through this list and imports all the XML files into a table with a column of data type XML. The only remaining step is to distribute the content across different tables. This distribution does require some explanation, but that is not the purpose of this blog post.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Azure Architecture<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This blog post discusses a use case in the Azure environment. The XML files are stored in a folder on Azure BLOB Storage, and the target database is an Azure SQL Database. So it\u2019s not SQL Server, but actually Azure\u2019s SQL Database. Scalability, rapid development, and cost savings are some of the benefits of Azure.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I\u2019m writing this blog because, while importing multiple files into Azure is certainly feasible, in our case you quickly run into limitations imposed by individual components. For example, an alternative approach is needed to determine the list of XML files. To do this, I\u2019ll use Azure Data Factory, which is one of the other Azure services offered by Microsoft. In addition, specific settings are required for the components.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Importing a Single XML File into Azure SQL Database<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Let's start with the basics. Importing a single XML file from Azure BLOB Storage into an Azure SQL Database. To do this, we\u2019ll create an External Data Source in Azure SQL Database. An External Data Source can be created for multiple types of sources, including Hadoop, another Azure SQL Database, or BLOB Storage. We\u2019ll use the latter type to import files from Azure BLOB Storage into Azure SQL Database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">There are 5 files in Azure BLOB Storage, and we will now start by reading the file \u201cFirst_5gh2rfg.xml.\u201d To do this, we\u2019ll create a target table in Azure SQL Database. The contents of the XML file will be stored in a column with a special XML data type. Important =&gt; This data type is necessary to easily parse the contents of an XML file and distribute them across multiple tables.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With a simple query in Azure SQL Database, you can retrieve the data from Azure BLOB Storage and load it into the table:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO &#91;BI].&#91;XML_IMPORT] (XML_DATA)\nSELECT CAST(BulkColumn AS XML)\nFROM OPENROWSET\n(\n BULK 'MyStorage\/MainFolder\/First_5gh2rfg.xml',\n DATA_SOURCE = 'AzureBlobStorage', \n SINGLE_BLOB\n) AS XML_IMPORT<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">In this example, \u201cMyStorage\u201d is the BLOB container, \u201cMainFolder\u201d is the main folder in the BLOB container, and \u201cFirst.xml\u201d is one of the XML files in that folder. Reading a single XML file into Azure SQL Database from Azure BLOB Storage is therefore easy to set up.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The Challenge<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">But what if we want to import multiple files with different names all at once for each shipment? In that case, we initially run into the following issues:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You cannot use \u201c*.xml\u201d when importing, because a specific filename must be specified<\/li>\n\n\n\n<li>But the key point is that Azure SQL Database cannot access Azure BLOB Storage to retrieve a list of files<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Alternatively, you can use Azure Data Factory. In Azure Data Factory, you can define various sources and create a pipeline with one or more activities. The Copy Data Activity allows you to transfer data from various sources to numerous destinations, including from Azure BLOB Storage to Azure SQL Database. An example of such a pipeline is shown below.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This seems exactly like what we want. However, while this would be a piece of cake for multiple CSV files\u2026 unfortunately, it\u2019s not the case for XML files that need to be stored in a database column with the XML data type. The specific XML data type is not (yet) supported, as shown below in the source definition for Azure BLOB Storage.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With the String data type, each line in an XML file would be imported as a separate record, causing the structure to be lost. Distributing the content across multiple tables then becomes a challenge in itself. The column with the XML data type also expects a complete XML file and will return an error message when reading it.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The Solution<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Ultimately, the solution is a hybrid approach. We can also use Azure Data Factory to import the list of XML files into the Azure SQL Database. Azure Data Factory then calls upon the Azure SQL Database so that it can iterate through that list itself. This means that multiple XML files can be imported into the Azure SQL Database all at once!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The pipeline looks like this:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A helper table has been created in Azure SQL Database that will contain only file names.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Activity 1 in the pipeline is to clear that table by calling a stored procedure in Azure SQL Database<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Activity 2 and Activity 3 require further explanation, because they are the core of the solution for storing the list of file names from Azure BLOB Storage in an Azure SQL Database table.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The second Activity is a \u201cGet Metadata\u201d Activity, for which it is important to select the \u201cChild Items\u201d and \u201cItem Name\u201d arguments. In our case, \u201cChild Items\u201d refers to the filenames in the Azure BLOB Storage folder \u201cMainFolder.\u201d The BLOB Storage dataset is configured as shown in the image below. Under \u201cFile path,\u201d the folder is specified, but the \u201cFile\u201d field is left blank.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Back to the pipeline to the third Activity of type ForEach<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the ForEach activity, we set \u201c@activity(\u2018Get Blob File Names\u2019).output.childItems\u201d for Items. This ensures that a specific underlying activity can be executed for each file in Azure Blob Storage.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When we open the ForEach loop, we see a call to a stored procedure there. The stored procedure was created in Azure SQL Database as follows:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE PROCEDURE &#91;BI].&#91;XML_IMPORT_GET_FILE_NAME] (@Name_Of_File varchar(max)) AS\nBEGIN\n INSERT INTO BI.BLOB_FILE_NAME SELECT @Name_Of_File\nEND<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">In the @Name_Of_File parameter of this stored procedure, we can then pass the XML filename that needs to be made available in the ForEach loop. This is done by setting the parameter value to the text \u201c@item().Name.\u201d NOTE! This is case-sensitive, so \u201c@item().name\u201d will not work, even though Azure Data Factory internally treats the property as \u201cname\u201d (lowercase).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The interim result of the pipeline after Activities 1 through 3 is a populated Azure SQL Database table containing all the file names stored in Azure BLOB Storage!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The fourth and final activity is, once again, calling a stored procedure in Azure SQL Database. This stored procedure will iterate through the table containing the file names and use them to populate the XML column for further categorization.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The beginning of this stored procedure is shown below, where you can see that it uses a simple query to read a single file. That query is, so to speak, constructed each time, with the specific filename retrieved from the table mentioned above using a cursor.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE PROCEDURE &#91;BI].&#91;XML_IMPORT_AND_SPLIT] AS\nBEGIN\n DECLARE @name_of_file varchar(8000)\n DECLARE cursor_file_names CURSOR FAST_FORWARD\n FOR SELECT NAME_OF_FILE FROM BI.BLOB_FILE_NAME WHERE NAME_OF_FILE LIKE '%.xml'\n OPEN cursor_file_names\n FETCH NEXT FROM cursor_file_names into @name_of_file\n WHILE @@FETCH_STATUS = 0 \n BEGIN \n EXEC\n (\n 'INSERT INTO &#91;BI].&#91;XML_IMPORT](XML_DATA) \n SELECT CAST(BulkColumn AS XML)\n FROM OPENROWSET\n (\n BULK ''MyStorage\/MainFolder\/' + @name_of_file + ''',\n DATA_SOURCE = ''EDS_AzureBlobStorage'', \n SINGLE_BLOB\n ) as XML_IMPORT'\n )\n FETCH NEXT FROM cursor_file_names into @name_of_file\n END\n DEALLOCATE cursor_file_names<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This procedure actually also involves splitting the XML into multiple tables, but that's beyond the scope of this blog.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Importing multiple files from Azure BLOB Storage into Azure SQL Database is a breeze with Azure Data Factory. However, if we want to load XML files into an XML column for further processing, we run into the individual limitations of Azure components. Nevertheless, with a specific approach and the right settings, it can still be handled effectively using Azure Data Factory.<\/p>","protected":false},"excerpt":{"rendered":"<p>For this blog post, our goal is to load multiple XML files into a database so that we can distribute their structure across separate tables. An additional complication is that the XML files have different filenames with each delivery. This is a fairly common scenario, for example, in bank payments. But how do we actually set something like this up in Azure?<\/p>","protected":false},"author":16,"featured_media":28554,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[27],"tags":[466,701,772],"industrie-type":[],"interesses":[],"techologie":[],"alistar_language":[],"class_list":["post-27845","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog-nl","tag-microsoft-azure","tag-sql-database","tag-xml"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Meerdere XML files importeren in Azure SQL Database - Alistar<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/alistar.net\/en\/blog\/importing-multiple-xml-files-in-azure-sql-database-with-azure-data-factory\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Meerdere XML files importeren in Azure SQL Database - Alistar\" \/>\n<meta property=\"og:description\" content=\"Voor deze blog stellen we ons als doel om meerdere XML files in een database te laden om de structuur daarvan over afzonderlijke tabellen te kunnen verspreiden. Een aanvullende complexiteit is dat de XML files bij elke levering andere bestandsnamen hebben. Dit is een vrij gebruikelijke case, bijvoorbeeld bij bankbetalingsverkeer. Maar hoe regelen we zoiets eigenlijk in Azure?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/alistar.net\/en\/blog\/importing-multiple-xml-files-in-azure-sql-database-with-azure-data-factory\/\" \/>\n<meta property=\"og:site_name\" content=\"Alistar\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-15T08:13:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-02T14:40:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/alistar.net\/wp-content\/uploads\/2018\/11\/shutterstock_2660464775-scaled.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1619\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Shardae Castelen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shardae Castelen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/meerdere-xml-files-importeren-in-azure-sql-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/meerdere-xml-files-importeren-in-azure-sql-database\\\/\"},\"author\":{\"name\":\"Shardae Castelen\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#\\\/schema\\\/person\\\/3c047614ccf88bd8927ae653882b3b50\"},\"headline\":\"Meerdere XML files importeren in Azure SQL Database\",\"datePublished\":\"2018-11-15T08:13:00+00:00\",\"dateModified\":\"2026-10-02T14:40:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/meerdere-xml-files-importeren-in-azure-sql-database\\\/\"},\"wordCount\":1322,\"publisher\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/meerdere-xml-files-importeren-in-azure-sql-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/shutterstock_2660464775-scaled.webp\",\"keywords\":[\"Microsoft Azure\",\"SQL-database\",\"XML\"],\"articleSection\":[\"Blog NL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/meerdere-xml-files-importeren-in-azure-sql-database\\\/\",\"url\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/meerdere-xml-files-importeren-in-azure-sql-database\\\/\",\"name\":\"Meerdere XML files importeren in Azure SQL Database - Alistar\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/meerdere-xml-files-importeren-in-azure-sql-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/meerdere-xml-files-importeren-in-azure-sql-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/shutterstock_2660464775-scaled.webp\",\"datePublished\":\"2018-11-15T08:13:00+00:00\",\"dateModified\":\"2026-10-02T14:40:39+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/meerdere-xml-files-importeren-in-azure-sql-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/meerdere-xml-files-importeren-in-azure-sql-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/meerdere-xml-files-importeren-in-azure-sql-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/shutterstock_2660464775-scaled.webp\",\"contentUrl\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/shutterstock_2660464775-scaled.webp\",\"width\":2560,\"height\":1619},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/meerdere-xml-files-importeren-in-azure-sql-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/alistar.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Meerdere XML files importeren in Azure SQL Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/alistar.net\\\/en\\\/\",\"name\":\"Alistar\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/alistar.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#organization\",\"name\":\"Alistar\",\"url\":\"https:\\\/\\\/alistar.net\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/favicon-new.svg\",\"contentUrl\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/favicon-new.svg\",\"width\":260,\"height\":260,\"caption\":\"Alistar\"},\"image\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/alistar\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#\\\/schema\\\/person\\\/3c047614ccf88bd8927ae653882b3b50\",\"name\":\"Shardae Castelen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g\",\"caption\":\"Shardae Castelen\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Importing Multiple XML Files into Azure SQL Database - Alistar","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/alistar.net\/en\/blog\/importing-multiple-xml-files-in-azure-sql-database-with-azure-data-factory\/","og_locale":"en_US","og_type":"article","og_title":"Meerdere XML files importeren in Azure SQL Database - Alistar","og_description":"Voor deze blog stellen we ons als doel om meerdere XML files in een database te laden om de structuur daarvan over afzonderlijke tabellen te kunnen verspreiden. Een aanvullende complexiteit is dat de XML files bij elke levering andere bestandsnamen hebben. Dit is een vrij gebruikelijke case, bijvoorbeeld bij bankbetalingsverkeer. Maar hoe regelen we zoiets eigenlijk in Azure?","og_url":"https:\/\/alistar.net\/en\/blog\/importing-multiple-xml-files-in-azure-sql-database-with-azure-data-factory\/","og_site_name":"Alistar","article_published_time":"2018-11-15T08:13:00+00:00","article_modified_time":"2026-10-02T14:40:39+00:00","og_image":[{"width":2560,"height":1619,"url":"https:\/\/alistar.net\/wp-content\/uploads\/2018\/11\/shutterstock_2660464775-scaled.webp","type":"image\/webp"}],"author":"Shardae Castelen","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Shardae Castelen","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/alistar.net\/en\/blog\/meerdere-xml-files-importeren-in-azure-sql-database\/#article","isPartOf":{"@id":"https:\/\/alistar.net\/en\/blog\/meerdere-xml-files-importeren-in-azure-sql-database\/"},"author":{"name":"Shardae Castelen","@id":"https:\/\/alistar.net\/en\/#\/schema\/person\/3c047614ccf88bd8927ae653882b3b50"},"headline":"Meerdere XML files importeren in Azure SQL Database","datePublished":"2018-11-15T08:13:00+00:00","dateModified":"2026-10-02T14:40:39+00:00","mainEntityOfPage":{"@id":"https:\/\/alistar.net\/en\/blog\/meerdere-xml-files-importeren-in-azure-sql-database\/"},"wordCount":1322,"publisher":{"@id":"https:\/\/alistar.net\/en\/#organization"},"image":{"@id":"https:\/\/alistar.net\/en\/blog\/meerdere-xml-files-importeren-in-azure-sql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/alistar.net\/wp-content\/uploads\/2018\/11\/shutterstock_2660464775-scaled.webp","keywords":["Microsoft Azure","SQL-database","XML"],"articleSection":["Blog NL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/alistar.net\/en\/blog\/meerdere-xml-files-importeren-in-azure-sql-database\/","url":"https:\/\/alistar.net\/en\/blog\/meerdere-xml-files-importeren-in-azure-sql-database\/","name":"Importing Multiple XML Files into Azure SQL Database - Alistar","isPartOf":{"@id":"https:\/\/alistar.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/alistar.net\/en\/blog\/meerdere-xml-files-importeren-in-azure-sql-database\/#primaryimage"},"image":{"@id":"https:\/\/alistar.net\/en\/blog\/meerdere-xml-files-importeren-in-azure-sql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/alistar.net\/wp-content\/uploads\/2018\/11\/shutterstock_2660464775-scaled.webp","datePublished":"2018-11-15T08:13:00+00:00","dateModified":"2026-10-02T14:40:39+00:00","breadcrumb":{"@id":"https:\/\/alistar.net\/en\/blog\/meerdere-xml-files-importeren-in-azure-sql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/alistar.net\/en\/blog\/meerdere-xml-files-importeren-in-azure-sql-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/alistar.net\/en\/blog\/meerdere-xml-files-importeren-in-azure-sql-database\/#primaryimage","url":"https:\/\/alistar.net\/wp-content\/uploads\/2018\/11\/shutterstock_2660464775-scaled.webp","contentUrl":"https:\/\/alistar.net\/wp-content\/uploads\/2018\/11\/shutterstock_2660464775-scaled.webp","width":2560,"height":1619},{"@type":"BreadcrumbList","@id":"https:\/\/alistar.net\/en\/blog\/meerdere-xml-files-importeren-in-azure-sql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/alistar.net\/"},{"@type":"ListItem","position":2,"name":"Meerdere XML files importeren in Azure SQL Database"}]},{"@type":"WebSite","@id":"https:\/\/alistar.net\/en\/#website","url":"https:\/\/alistar.net\/en\/","name":"Alistar","description":"","publisher":{"@id":"https:\/\/alistar.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/alistar.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/alistar.net\/en\/#organization","name":"Alistar","url":"https:\/\/alistar.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/alistar.net\/en\/#\/schema\/logo\/image\/","url":"https:\/\/alistar.net\/wp-content\/uploads\/2025\/07\/favicon-new.svg","contentUrl":"https:\/\/alistar.net\/wp-content\/uploads\/2025\/07\/favicon-new.svg","width":260,"height":260,"caption":"Alistar"},"image":{"@id":"https:\/\/alistar.net\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/alistar\/"]},{"@type":"Person","@id":"https:\/\/alistar.net\/en\/#\/schema\/person\/3c047614ccf88bd8927ae653882b3b50","name":"Shardae Castelen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g","caption":"Shardae Castelen"}}]}},"_links":{"self":[{"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/posts\/27845","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/comments?post=27845"}],"version-history":[{"count":6,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/posts\/27845\/revisions"}],"predecessor-version":[{"id":76231,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/posts\/27845\/revisions\/76231"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/media\/28554"}],"wp:attachment":[{"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/media?parent=27845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/categories?post=27845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/tags?post=27845"},{"taxonomy":"industrie-type","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/industrie-type?post=27845"},{"taxonomy":"interesses","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/interesses?post=27845"},{"taxonomy":"techologie","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/techologie?post=27845"},{"taxonomy":"alistar_language","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/alistar_language?post=27845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}