Here we feature a few methods for loading files into an Oracle or SQL Server database. There are many methods for accomplishing this, but over the past few projects, and after implementing most of the methods discussed, I documented some of my experiences. Here I focus on developing an application or process to load data […]
This article features some methods that I have used to load data within a C# application. The methods discussed are an Insert Loop (with bind parameters), the DataAdapter.Update() method, and a custom method of passing the table to a stored procedure. For this article, a simple website demo was setup that accepted a 6-column CSV […]
https://www.dwconsultants.com/wp-content/uploads/2018/06/text-x-preview-1.png128128Steve Shantzhttp://www.dwconsultants.com/wp-content/uploads/2013/12/data-warehouse-logo-2.02.pngSteve Shantz2018-06-25 10:51:232019-04-04 15:22:08Loading Flat Files into a Database with C#
Data Warehouse Consultants is constantly investing in our staff to learn new technologies and offerings. The summary below was published by our analyst Mukesh Thangadurai regarding the use of the Azure SQL Data Warehouse, which is Microsoft’s current cloud offering focusing on the data warehousing space. For more information on this prototype or similar work […]
Data Warehouse Consultants is constantly investing in our staff to learn new technologies and offerings. The summary below was published by our analyst Mukesh Thangadurai regarding the use of the Azure HD Insight product, which is Microsoft’s current Hadoop offering. For more information on this prototype or similar work we can do for your company, […]
https://www.dwconsultants.com/wp-content/uploads/2017/11/hd_insight.png225225Mukesh Thangaduraihttp://www.dwconsultants.com/wp-content/uploads/2013/12/data-warehouse-logo-2.02.pngMukesh Thangadurai2017-11-09 15:09:472019-04-04 15:22:37Our Experience with Azure HD Insight
The Cloud offers many advantages and many organizations are looking to utilize Cloud solutions. But how easy is it to move an existing Data Warehouse to Microsoft Azure or Amazon Web Services? To gain insight and better advise our clients, Data Warehouse Consultants has begun two research projects to identify the benefits and pitfalls of […]
https://www.dwconsultants.com/wp-content/uploads/2015/06/4870003098_26ba44a08a_microsoft.jpg333500Bob Brichacekhttp://www.dwconsultants.com/wp-content/uploads/2013/12/data-warehouse-logo-2.02.pngBob Brichacek2017-09-29 13:27:322019-04-04 15:21:26Moving Your Data Warehouse to the Cloud
Loading Flat Files into a Database (Method Overview)
/in News /by Steve ShantzHere we feature a few methods for loading files into an Oracle or SQL Server database. There are many methods for accomplishing this, but over the past few projects, and after implementing most of the methods discussed, I documented some of my experiences. Here I focus on developing an application or process to load data […]
Loading Flat Files into a Database with C#
/in News /by Steve ShantzThis article features some methods that I have used to load data within a C# application. The methods discussed are an Insert Loop (with bind parameters), the DataAdapter.Update() method, and a custom method of passing the table to a stored procedure. For this article, a simple website demo was setup that accepted a 6-column CSV […]
Prototype Review of Azure SQL Data Warehouse
/in News /by Mukesh ThangaduraiData Warehouse Consultants is constantly investing in our staff to learn new technologies and offerings. The summary below was published by our analyst Mukesh Thangadurai regarding the use of the Azure SQL Data Warehouse, which is Microsoft’s current cloud offering focusing on the data warehousing space. For more information on this prototype or similar work […]
Our Experience with Azure HD Insight
/in News /by Mukesh ThangaduraiData Warehouse Consultants is constantly investing in our staff to learn new technologies and offerings. The summary below was published by our analyst Mukesh Thangadurai regarding the use of the Azure HD Insight product, which is Microsoft’s current Hadoop offering. For more information on this prototype or similar work we can do for your company, […]
Moving Your Data Warehouse to the Cloud
/in News /by Bob BrichacekThe Cloud offers many advantages and many organizations are looking to utilize Cloud solutions. But how easy is it to move an existing Data Warehouse to Microsoft Azure or Amazon Web Services? To gain insight and better advise our clients, Data Warehouse Consultants has begun two research projects to identify the benefits and pitfalls of […]