Tag: etl

Nov 11 2023

Azure, Business Intelligence, Technology

Azure Data Factory and DB2 Codepages

by mattias

No Comments

Having the option to connect to DB2 from Azure Data Factory is a great help in migrating from more legacy database platforms to the cloud. Or to ingest these systems...

adf, as400, azure, Azure Data Factory, DB2, etl

Aug 27 2022

Business Intelligence

SQL : CLR to do base36 decoding

by mattias

No Comments

Always wanted to escape the set based world of SQL and get back to that good old .Net procedural (even object oriented) experience for a quick calculation? Let me show...

assembly, database, datawarehouse, db, etl, sql, SQLServer, tsql

Jun 28 2020

Business Intelligence

BI : Securing SSIS project deployments

by mattias

No Comments

When you’re sharing an on-premises SSIS server with multiple teams you’d want to segregate responsibilities to their projects. It’s not a much advertised feature of SSISDB, but it allows you...

bi, database, edw, etl, integration services, security, SQLServer, ssis, ssisdb

May 16 2020

Business Intelligence

Power BI for SQL Server Agent jobs

by mattias

4 Comments

In a SQLServer datawarehouse you might have a lot of jobs scheduled through SQL Server Agent. There is little out of the box visibility on the status of those jobs,...

db, email, etl, power bi, PowerBI, SQLServer

May 12 2020

Business Intelligence

Expressions on ConnectionString issue in SSIS 2019

by mattias

11 Comments

In SQLServer Integration Services, the use of Expressions to replace properties at runtime is very powerful. You can use it in combination with variables to pass parameters to queries, determine...

database, datawarehouse, etl, sql, SQLServer, ssis