Integrate Big Data to Existing SQL Database?

[jaysomlam]

We have database in SQL Server 2019.  I would like to know if we can use SQL Server 2019 to retrieve data from Big Data.

But based on Stratus Knowledge Base, it only talks about using Power BI plus Azure SQL Database.  Is this the only option?

Which version of Visual Studio that I should use to create a database project to get access to Big Data?

Please let me know what the set of tools to get started with Big Data.  Thanks.

jaysomlam

[Axl]

I'm not an expert on Stratus, but if they provide SQL credentials so PowerBI can access SQL data directly (https://gtpservices.atlassian.net/wiki/spaces/SK/pages/2689433601/Big+Data+Admin), means python can do the same and get the data and move it to SQL.

So, my answer would be yes, it is possible but requires some programming skills.

[jaysomlam]

The problem is fixed.  Now, I can use Visual Studio 2022 to connect to Big Data in Stratus, and I can use queries to browse data in Big Data.

I believe the key is to click "Rebuild Data" button, and then wait for one hour for data to be synchronized.  I might not have waited long enough for one hour for the data to be synchronized.

As long as I got Server ID, Database ID, and SQL User and Password, I can connect to Big Data.

Liz Fong from Stratus helped me with this one - especially the "wait one hour requirement".

jaysomlam