Skip to main content

Posts

ADO.Net with Microsoft Data Fabric Sql Endpoint

using Microsoft.Data.SqlClient;   // Use your own server, database, and user ID. // Connetion string - user ID is not provided and is asked interactively. string ConnectionString = @"Data Source=*******.datawarehouse.pbidedicated.windows.net;  Initial Catalog=database;User ID=userid;  Connect Timeout=30;Encrypt=True;TrustServerCertificate=False;  Authentication=Active Directory Interactive;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; using (SqlConnection conn = new SqlConnection(ConnectionString)) {        conn.Open();        Console.WriteLine("ConnectionString2 succeeded.");        using (var cmd = new SqlCommand("SELECT @@Version", conn))        {             Console.WriteLine("select @@version");             var result = cmd.ExecuteScalar();             Console.WriteLine(result.ToString...
Post a Comment
Read more
Recent posts

Python chatbot sample

Prerequisites:      1. Install python 3.11.4      2. Install Flask by pip install Flask How to Install:      1. Open command prompt.      2. Change the directory (CD) to where the app.py file is presenting.      3. After navigating to the folder type python. It will automatically trigger   to install the latest python package.  Example -                 C:\Users\PythonProjectFolder> python      4. Install the Flask.                   C:\Users\PythonProjectFolder> pip install Flask How to run the website:             C:\Users\PythonProjectFolder> python app.py Steps to creating the files: 1. Create one main folder and sub folder structure like below. We are going to using the note pad as the code editor. 2. The app.py is the start up fil...
Post a Comment
Read more

Data transfer from dataverse to Azure SQL using Microsoft Data Fabric

Transfer the data from dataverse to Azure SQL using Microsoft Data Fabric 1. Open  Microsoft Fabric 2. Select Data Engineering . 3. Go to your workspace. 4. Select the  Dataflow Gen2 . 4. Click the hyper link ' Get data from another source ' 5. Popup will open, Search by Dataverse and select. 6. Select your environment domain and click Next. 7. We can select our entities and click Create . 8. We have the option to Choose the specific columns. 9. I have selected accountid and name column from account entity. 10. Select the data destination from the drop down. I have selected Azure SQL Database. 11. Popup will open there we can fill the azure sql database server details. then Click Next. 12. Select the Database and choose Replace option then Click Save Settings. 13. Click Publish. 14. Dataflow is created and loading the data to Azure SQL. 15. Now the selected entity and corresponding data has been populated in the Azure SQL database. 16. We can set the timer to schedule the data...
Post a Comment
Read more

About Microsoft Data Fabric with demo

Microsoft Data Fabric Microsoft introduces new feature called Microsoft data fabric. Now this feature is in public preview mode. Microsoft data fabric mainly used for data analytical purpose.  All in one platform to gathering the data from multiple data sources, It can be SQL, DataLake, Dataverse, Excel, CSV etc. After fetching the data from the corresponding sources, all the data should come under one lake house as table format. It has multiple flexibility for data analytical platform. We can implement Lake house, data warehouse or can combine these both together to transform of simplifying the data for power bi presentation. 1. Data Engineering Data engineering enables users to design, build, and maintain infrastructures and systems that enable their organizations to collect, store, process, and analyze large volumes of data. 2. Data Science Data Science experiences to empower users to complete end-to-end data science workflows for the purpose of data enrichment and business insi...
Post a Comment
Read more