Java – Save the results of select query on SQL Server into Azure Blob Storage No.75

Posted on by kumoman

I will show Java code that save results of select query on SQL Server into Azure Blob Storage. ▼1. Copy data on SQL Server into Azure Blob Storage Azure Data Factory (ADF) is a good and easy way to copy data on SQL Server into Azure Blob Storage. please refer to this document. in this blog, I will show Java code to do it instead of ADF. Ref: Copy and transform data to and from SQL Server by using Azure Data Factory or Azure Synapse Analytics ▼2. Prerequisites We execute select query on SQL Server for Ubuntu. 2-1. Installation of SQL Server on Ubuntu Ref: Quickstart: Install SQL Server and … Continue reading “Java – Save the results of select query on SQL Server into Azure Blob Storage No.75”

Java – Save the results of select on Azure Cosmos DB SQL API into Azure Blob Storage No.74

Posted on by kumoman

I will show Java code that save results of select query as a JSON file into Azure Blob Storage. In the previous blog, I shared how to save results of select query on Cosmos DB as a JSON file into the local path. in this blog, I will save results into Azure Blob Storage. ▼1. Migration data from Cosmos DB to Azure Blob Storage We can migrate data from Cosmos DB to Azure Blob Storage using dt.exe or dtui.exe easily. this document is helpful for these migration. but I will share you how to migrate data on Azure Cosmos DB into Azure Blob Storage using Java. Ref:  Tutorial: Use Data … Continue reading “Java – Save the results of select on Azure Cosmos DB SQL API into Azure Blob Storage No.74”

Java – Azure Cosmos DB (SQL) : Save results of select into a JSON file No.73

Posted on by kumoman

I will show Java code that save results of select query into a JSON file. In the previous blog, I shared how to save results of select query on Cosmos DB into a text file. in this blog, I will save results into a JSON file. ▼1. What is a JSON format? The following data types are supported in JSON format. This is an example of a JSON file. Ref: JSON – Wikipedia { “Records”: [ { “id”: 1, “lastName”: “Travase”, “isRegistered”: false }, { “id”: 2, “lastName”: “Ken”, “isRegistered”: true }, { “id”: 3, “lastName”: “Sai”, “isRegistered”: false } ] } ▼2. Prerequisites 2-1. Free trial Azure Cosmos DB Account … Continue reading “Java – Azure Cosmos DB (SQL) : Save results of select into a JSON file No.73”

Java – Azure Cosmos DB (SQL) : Save results of select into a text file No.72

Posted on by kumoman

I will show Java code that save results of select query into a text file. ▼1. Prerequisites 1-1. Free Azure Cosmos DB Account You can use trial free Cosmos DB Accounthttps://azure.microsoft.com/ja-jp/try/cosmosdb/ 1-2. Installing Visual Studio Code https://code.visualstudio.com/docs/setup/linux 1-3. Installing Maven Ref: Apache Kafka Word Count 実装 – Java No.44line of 2-3 1-4. Creating sample data Ref: Java Azure Cosmos DB (SQL API) Database の作成方法 No.14 ▼2. Java code for saving results of select query on Cosmos DB into a text file 2-1. Making a directory Making a directory to create an application. 2-2. Deploying Apache Maven project （a part of stdout） xxxx [INFO] Scanning for projects… [INFO] [INFO] ——————< org.apache.maven:standalone-pom … Continue reading “Java – Azure Cosmos DB (SQL) : Save results of select into a text file No.72”

Let’s Empower Me – Kumoman blog

Posted on by kumoman

I’m working on an IT company in Japan. I try to invest some kinds of things every day to empower me. This blog shows the results of such my investments. There are some type of my investments as below. We often face a difficult situation in our life. but we can look up and live with hope by our trying many new things every day. Let’s empower me through starting something new and keeping going on !!! Twitter (Profile): https://twitter.com/kumoman3/ Youtube: WealthNavi robo advisorJapanese site: https://www.kumoman.net/site/