Home
%3CLINGO-SUB%20id%3D%22lingo-sub-846416%22%20slang%3D%22en-US%22%3EJust%20Shipped%3A%20Azure%20Data%20Factory%20template%20for%20bulk%20copy%20from%20database%20to%20Azure%20Data%20Explorer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-846416%22%20slang%3D%22en-US%22%3E%3CDIV%3EIf%20you%20want%20to%26nbsp%3Bcopy%20large%20amounts%20of%20data%20from%20a%20database%20(SQL%20Server%2C%20Oracle%2C%20DB2%2C%20Google%20Big%20Query%2C%20MySQL%2C%20Netezza%2C%20ODBC%2C%26nbsp%3BPostgreSQL%2C%20etc.)%20into%20Azure%20Data%20Explorer%2C%20leverage%26nbsp%3B%3CU%3E%3CA%20tabindex%3D%22-1%22%20title%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fblog%2Fget-started-quickly-using-templates-in-azure-data-factory%2F%22%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fblog%2Fget-started-quickly-using-templates-in-azure-data-factory%2F%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Data%20Factory%26nbsp%3Btemplate%3C%2FA%3E%3C%2FU%3E%26nbsp%3Bfor%20bulk%20copy%20from%20database%20to%20Azure%20Data%20Explorer.%20ADF%20templates%20are%26nbsp%3Bpredefined%20Azure%20Data%20Factory%20pipelines%20that%20allow%20you%20to%20get%20started%20quickly%20with%20Data%20Factory%20and%20reduce%20development%20time%20for%20building%20data%20integration%20projects.%20The%26nbsp%3BBulk%20copy%20from%20database%20to%20Azure%20Data%20Explorer%26nbsp%3Btemplate%20is%20created%20using%26nbsp%3BLookup%26nbsp%3Band%26nbsp%3BForEach%26nbsp%3Bactivities.%20You%20can%20use%20the%20template%20to%20create%20many%20pipelines%20per%20database%20or%20table%20for%20faster%20copying%20of%20data.%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130929i105FBE3FBB99D5E9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22pipeline-from-template.png%22%20title%3D%22pipeline-from-template.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%3E%0A%3CP%3EOnce%20you%20choose%26nbsp%3BBulk%20copy%20from%20database%20to%20Azure%20Data%20Explorer%26nbsp%3Btemplate%20you%20will%20be%20asked%20to%20fill%20few%20parameters%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSTRONG%3E%3CSPAN%3EControlTableDataset%3C%2FSPAN%3E%3C%2FSTRONG%3E%26nbsp%3B-%20control%20table%20indicates%20what%20data%20is%20copied%20from%20source%20to%20destination%20and%20where%20it%20will%20be%20placed%20in%20the%20destination.%20you%20can%20fill%20as%20many%20records%20as%20you%20want.%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CSPAN%3ESourceDataset%3C%2FSPAN%3E%3C%2FSTRONG%3E%26nbsp%3B%E2%80%93%20Linked%20service%20to%20source%20database.%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CSPAN%3EAzureDataExplorerTable%3C%2FSPAN%3E%3C%2FSTRONG%3E%26nbsp%3B-%20Azure%20Data%20Explorer%20dataset.%3C%2FLI%3E%0A%3CLI%3E%3CP%3Eonce%20a%20pipeline%20is%20being%20created%2C%20define%20the%26nbsp%3B%3CSTRONG%3E%3CSPAN%3EBatch%20count%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3Ein%20Command%20activity%26nbsp%3B%3CSTRONG%3E%3CSPAN%3EForEachPartition%3C%2FSPAN%3E%3C%2FSTRONG%3E.%20This%20parameter%20determines%20the%20number%20of%20pipelines%20that%20run%20in%20parallel%20(1..50)%20until%20the%26nbsp%3BControlTableDataset%26nbsp%3Bnumber%20of%20rows%20is%20reached.%3C%2FP%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3ERead%20more%20on%20Azure%20Data%20Factory%20template%20for%20bulk%20copy%20from%20database%20to%20Azure%20Data%20Explorer%26nbsp%3B%3CU%3E%3CA%20tabindex%3D%22-1%22%20title%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-explorer%2Fdata-factory-template%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-explorer%2Fdata-factory-template%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E%3C%2FU%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELearn%20more%20about%20Azure%26nbsp%3BData%20Explorer%20(Kusto)%3A%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3E%3CU%3E%3CA%20tabindex%3D%22-1%22%20title%3D%22https%3A%2F%2Femea01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253a%252f%252fazure.microsoft.com%252fen-us%252fservices%252fdata-explorer%252f%26amp%3Bdata%3D02%257c01%257ctzgitlin%2540microsoft.com%257c33b94d34a7284713b30108d68cecb3ce%257c72f988bf86f141af91ab2d7cd011db47%257c1%257c0%257c636851345592939394%26amp%3Bsdata%3Dvgtfwifedpsnuqd4tclyljcmmq3cw%252fea7coupv%252fdoiw%253d%26amp%3Breserved%3D0%22%20href%3D%22https%3A%2F%2Femea01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fazure.microsoft.com%252Fen-us%252Fservices%252Fdata-explorer%252F%26amp%3Bdata%3D02%257C01%257Ctzgitlin%2540microsoft.com%257C33b94d34a7284713b30108d68cecb3ce%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C636851345592939394%26amp%3Bsdata%3DVgtfwIFedpSnuQd4TClYLJCmmQ3CW%252FeA7coUPv%252FDOiw%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Data%20Explorer%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3CLI%3E%3CU%3E%3CA%20tabindex%3D%22-1%22%20title%3D%22https%3A%2F%2Femea01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253a%252f%252fdocs.microsoft.com%252fen-us%252fazure%252fdata-explorer%252f%26amp%3Bdata%3D02%257c01%257ctzgitlin%2540microsoft.com%257c33b94d34a7284713b30108d68cecb3ce%257c72f988bf86f141af91ab2d7cd011db47%257c1%257c0%257c636851345592949402%26amp%3Bsdata%3D1z9id3dkxvfw8sdd3m6syagfpt83lcwckxkktvpppbi%253d%26amp%3Breserved%3D0%22%20href%3D%22https%3A%2F%2Femea01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fen-us%252Fazure%252Fdata-explorer%252F%26amp%3Bdata%3D02%257C01%257Ctzgitlin%2540microsoft.com%257C33b94d34a7284713b30108d68cecb3ce%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C636851345592949402%26amp%3Bsdata%3D1Z9Id3dkxVfW8sDD3M6syagFpT83LCwCKxkKTvPppbI%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EDocumentation%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3CLI%3E%3CU%3E%3CA%20tabindex%3D%22-1%22%20title%3D%22https%3A%2F%2Femea01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253a%252f%252fwww.pluralsight.com%252fcourses%252fkusto-query-language-kql-from-scratch%26amp%3Bdata%3D02%257c01%257ctzgitlin%2540microsoft.com%257c33b94d34a7284713b30108d68cecb3ce%257c72f988bf86f141af91ab2d7cd011db47%257c1%257c0%257c636851345592959411%26amp%3Bsdata%3Dlkjftf%252fazzi0nnn4jg2pcpfzflyxugj%252f2%252f%252fqksysedc%253d%26amp%3Breserved%3D0%22%20href%3D%22https%3A%2F%2Femea01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fwww.pluralsight.com%252Fcourses%252Fkusto-query-language-kql-from-scratch%26amp%3Bdata%3D02%257C01%257Ctzgitlin%2540microsoft.com%257C33b94d34a7284713b30108d68cecb3ce%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C636851345592959411%26amp%3Bsdata%3DlkjFtf%252FAzzi0nnn4jg2pCpfZfLYXugJ%252F2%252F%252FqksySeDc%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECourse%20%E2%80%93%20Basics%20of%20KQL%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3CLI%3E%3CU%3E%3CA%20tabindex%3D%22-1%22%20title%3D%22http%3A%2F%2Faka.ms%2Fnkwe%22%20href%3D%22http%3A%2F%2Faka.ms%2Fnkwe%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EQuery%20explorer%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3CLI%3E%3CU%3E%3CA%20tabindex%3D%22-1%22%20title%3D%22http%3A%2F%2Faka.ms%2Fazureportal%22%20href%3D%22http%3A%2F%2Faka.ms%2Fazureportal%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Portal%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3CLI%3E%3CU%3E%3CA%20tabindex%3D%22-1%22%20title%3D%22https%3A%2F%2Femea01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253a%252f%252ffeedback.azure.com%252fforums%252f915733-azure-data-explorer%26amp%3Bdata%3D02%257c01%257ctzgitlin%2540microsoft.com%257c33b94d34a7284713b30108d68cecb3ce%257c72f988bf86f141af91ab2d7cd011db47%257c1%257c0%257c636851345592959411%26amp%3Bsdata%3Dwrs2tfgokomhqyigu6dsruy93jdtzduzur6xxw7e0so%253d%26amp%3Breserved%3D0%22%20href%3D%22https%3A%2F%2Femea01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Ffeedback.azure.com%252Fforums%252F915733-azure-data-explorer%26amp%3Bdata%3D02%257C01%257Ctzgitlin%2540microsoft.com%257C33b94d34a7284713b30108d68cecb3ce%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C636851345592959411%26amp%3Bsdata%3DWRs2tFgokomhQyIgu6dsRuy93JDtzDuzur6xXw7e0so%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EUser%20Voice%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3CLI%3E%3CU%3E%3CA%20tabindex%3D%22-1%22%20title%3D%22http%3A%2F%2Faka.ms%2Fadx.cost%22%20href%3D%22http%3A%2F%2Faka.ms%2Fadx.cost%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECost%20Estimator%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSPAN%3EJoin%20us%20to%20share%20questions%2C%20thoughts%2C%20or%20ideas%20about%20Azure%20Data%20Explorer%20(Kusto)%20and%20receive%20answers%20from%20the%20diverse%20and%20knowledgeable%20Azure%20Data%20Explorer%20community.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAzure%20Data%20Explorer%20product%20team%3C%2FP%3E%0A%3CP%3E%3CI%3E%3CSPAN%3E%E2%80%9CJoin%20the%20conversation%20on%20the%26nbsp%3B%3CU%3E%3CA%20tabindex%3D%22-1%22%20title%3D%22https%3A%2F%2Femea01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253a%252f%252ftechcommunity.microsoft.com%252ft5%252fazure-data-explorer%252fbd-p%252fkusto%26amp%3Bdata%3D02%257c01%257ctzgitlin%2540microsoft.com%257c9f50757c112e45322d5608d697587c18%257c72f988bf86f141af91ab2d7cd011db47%257c1%257c0%257c636862803655308273%26amp%3Bsdata%3Dsuximqlw7qkiszszyjhw9sp4vx1calrcps4p2htneii%253d%26amp%3Breserved%3D0%22%20href%3D%22https%3A%2F%2Femea01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Ftechcommunity.microsoft.com%252Ft5%252FAzure-Data-Explorer%252Fbd-p%252FKusto%26amp%3Bdata%3D02%257C01%257Ctzgitlin%2540microsoft.com%257C9f50757c112e45322d5608d697587c18%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C636862803655308273%26amp%3Bsdata%3DSuximQlW7qkiSzSZyJHW9SP4vX1calRCPs4P2HTneII%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Data%20Explorer%20community%3C%2FA%3E%3C%2FU%3E%E2%80%9D.%3C%2FSPAN%3E%3C%2FI%3E%3C%2FP%3E%0A%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-846416%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EIf%20you%20want%20to%26nbsp%3Bcopy%20large%20amounts%20of%20data%20from%20a%20database%3C%2FSPAN%3E(SQL%20Server%2C%20Oracle%2C%20DB2%2C%20Google%20Big%20Query%2C%20MySQL%2C%20Netezza%2C%20ODBC%2C%26nbsp%3BPostgreSQL%2C%20etc.)%20into%20Azure%20Data%20Explorer%2C%20Azure%20Data%20Factory%20template%20for%20bulk%20copy%20from%20database%20to%20Azure%20Data%20Explorer%20is%20an%20efficient%20option%20to%20run%20it.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130926iE863A102BBB86AE0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22pipeline-from-template.png%22%20title%3D%22pipeline-from-template.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E
If you want to copy large amounts of data from a database (SQL Server, Oracle, DB2, Google Big Query, MySQL, Netezza, ODBC, PostgreSQL, etc.) into Azure Data Explorer, leverage Azure Data Factory template for bulk copy from database to Azure Data Explorer. ADF templates are predefined Azure Data Factory pipelines that allow you to get started quickly with Data Factory and reduce development time for building data integration projects. The Bulk copy from database to Azure Data Explorer template is created using Lookup and ForEach activities. You can use the template to create many pipelines per database or table for faster copying of data.

 

pipeline-from-template.png

Once you choose Bulk copy from database to Azure Data Explorer template you will be asked to fill few parameters:

  • ControlTableDataset - control table indicates what data is copied from source to destination and where it will be placed in the destination. you can fill as many records as you want.
  • SourceDataset – Linked service to source database.
  • AzureDataExplorerTable - Azure Data Explorer dataset.
  • once a pipeline is being created, define the Batch count in Command activity ForEachPartition. This parameter determines the number of pipelines that run in parallel (1..50) until the ControlTableDataset number of rows is reached.

Read more on Azure Data Factory template for bulk copy from database to Azure Data Explorer here 

 

Learn more about Azure Data Explorer (Kusto):

  1. Azure Data Explorer
  2. Documentation
  3. Course – Basics of KQL
  4. Query explorer
  5. Azure Portal
  6. User Voice
  7. Cost Estimator

Join us to share questions, thoughts, or ideas about Azure Data Explorer (Kusto) and receive answers from the diverse and knowledgeable Azure Data Explorer community.

 

Azure Data Explorer product team

“Join the conversation on the Azure Data Explorer community”.