Database Platform CSE – Mainframe
14 TopicsDb2 to Azure SQL DB parallel data copy by generating ADF copy activities dynamically
Want to utilize near to full network bandwidth / CPU resources on source and target to perform efficient data copy from Db2 to Azure SQL? Follow this tech article to know more about how ADF can be utilized for this purpose.Migrating Mainframe RACF user identities to Microsoft Entra ID Users
RACF[Resource Access Control Facility] is one of the main security components which does authorization and authentication on the Mainframe. While modernizing mainframe workloads to Azure, there is a need to migrate the identity information of the users to Azure. This also applies in co-existence and hybrid scenarios where both mainframe and Azure user information needs to stay in sync.Mainframe Dataset (Files) Transfer to Azure Storage (Blob) using Mainframe JCL
This article shows the steps involved in moving mainframe file data to Azure Blob using Java on Mainframe. Mainframe files are in Extended Binary Coded Decimal Interchange Code (EBCDIC) code page. To monetize this business data, these datasets need to be transmitted to Azure and converted to usable formats. In this blog, we talk about how to use Mainframe JCLs and Java to transmit these files directly to Azure. This is one of many methods to transfer data to Azure.Mainframe Db2 Data Virtualization using SQL Server PolyBase
Looking for easy solution to combine data between Db2 and SQL Server in single query? Want to know more about how to access Db2 table from SQL Server real time without duplicating data between Db2 and SQL Server? Look no further PolyBase is the answer to these questions as explained in this article.