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,797 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,914 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
1,002 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,954 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
658 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
20,100 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,504 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,825 reads
Blogs
The T-SQL Tuesday Corollary
T-SQL Tuesday is a fantastic series of blog posts derived from over 130 topics...
How to Import Perfmon Data into a SQL Server for Analysis
By kleegeek
If you followed the last video, I showed you how to set up windows...
How To Set Up Perfmon for 24×7 Collection
By kleegeek
I just released a new training video (one of many to be released in...
Forums
OLAPQueryLog does not work for SSAS Tabular mode
I running into a problem when I try to setup querylog in SSAS. The...
MasOffer Affiliate m?t hình th?c ki?m ti?n v?i ti?p th? liên k?t
[/b] MasOffer là m?ng ti?p th? k?t liên r?t l?ng danh ? Vi?t Nam....
Code to auto-update tables on set date
I am in a project where information is being pulled from a database then...
Ask SSC