Replicate NetSuite Data to Azure SQL (SSIS in Azure Data Factory)
With Azure Data Factory V2 Integration Runtimes (ADFv2 IR), you can deploy enterprise replication tasks to the Azure cloud.
2020-07-17 (first published: 2019-01-02)
1,576 reads
Jerod Johnson
Build an OLAP Cube in SSAS using an ADO.NET Data Provider
SQL Server Analysis Services (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications, such as Power BI, Excel, Reporting Services reports, and other data visualization tools. When paired with ADO.NET data providers, you can create cubes from external data […]
2019-04-30
2,871 reads
Dynamically Generate Replication Tasks with Biml and Custom Connectors
This article walks through using Biml with 3rd party connectors to replicate external data to SQL Server in SSIS.
2019-03-21
962 reads
TDS Remoting: A Better Way to Create Linked Servers for ODBC Sources
TDS remoting services provide a native SQL experience with local and remote ODBC data sources (contrast with limitations of using OLE DB).
2017-08-28
1,889 reads
PowerShell Scripting to Replicate Cloud & SaaS Data to SQL Server
Using a CData DataCmdlet and sqlps to replicate data from Google Spreadsheets to a SQL Server database in PowerShell
2017-06-01
634 reads
Building Dynamic React Apps with SQL Server Data
This article demonstrates using React and the CData API Server to build dynamic Web pages using SQL Server data.
2017-04-24
17,656 reads
Building Angular2 Apps with SQL Server Data
This article demonstrates using Angular2 and the CData API Server to build dynamic Web pages using SQL Server data.
2017-02-08
4,225 reads
A Comparison of JDBC Drivers for MySQL
A brief comparison of three different JDBC Drivers built for connecting with MySQL
2016-05-19
1,683 reads
Blogs
SQL Clone Works with FILESTREAM
By Steve Jones
SQL Clone is an amazing product that virtualizes your data, allowing multiple instances to...
Fun and profit with UTF-8
When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available...
Data Platform MVP 2020
I am humbled to be among so many great professionals and honored at the...
Forums
Removing TDE from a Database: Level 4 Stairway to TDE
Comments posted to this topic are about the item Removing TDE from a Database:...
Database Modeling - Relationships
Comments posted to this topic are about the item Database Modeling - Relationships
Read database objects relationship in easy steps
Comments posted to this topic are about the item Read database objects relationship in...
Ask SSC