Free SQL Help for Devs, DBAs, and the Curious

As data professionals, we often find ourselves working with diverse databases. Two such databases are IBM's DB2 and Microsoft's SQL Server. Each of these databases offers unique features that can prove beneficial to your organization. However, there are times when we need to combine data from both these databases for analysis and reporting. This is where Power BI, Microsoft's interactive visualization tool, comes in handy. In today's post, we'll walk you through how to combine DB2 and SQL Server data in Power BI.

To start, you'll need to ensure that you have connections to both your DB2 and SQL Server databases. For SQL Server, whether it's SQL Server 2016, SQL Server 2017, or Azure SQL, the connection process is straightforward. Simply select SQL Server from the 'Get Data' option, and input your server details and database name.

For DB2, the process is slightly different. You need to install the IBM DB2 driver on your machine. Once installed, you can then select DB2 from the 'Get Data' option, and input your server details and database name.

Once you have connections to both databases, you can then load data into Power BI. Power BI allows you to load data using SQL queries. For SQL Server, you can use T-SQL to write your query. Here is an example:

-- T-SQL code goes here
SELECT *
FROM Sales.Orders
WHERE OrderDate BETWEEN '2017-01-01' AND '2017-12-31'

-- DB2 SQL code goes here
SELECT *
FROM HR.EMPLOYEES
WHERE HIRE_DATE BETWEEN '2017-01-01' AND '2017-12-31'

Email

Email

Your Comments

Please enter the code from the image above in the box below.

• Search Here:

   

• Categories

  • SQL Tips (132)
  • SQL Server (127)
  • DB2 (72)
  • MySQL (71)
  • Azure (11)
  • Data Types (10)
  • T-SQL (8)
  • Security & Permissions (8)
  • Backup & Restore (6)
  • Fabric (4)

• Tags

  • SQL Server (2)
  • T-SQL (2)
  • Performance Tuning (2)
  • SSRS (1)
  • Delta Lake (1)
  • OpenAI (1)