Microsoft SQL Server

Recently I had a task to Push Data from SAP Reports to MS SQL DB, periodically, and to Create Tables of the required Reports in their MS SQL DB, as well Being a complete novice ABAP developer, I learned about ABAP DB Connectivity (ADBC) DDL and DML... Read More »

How can we leverage Python programming language in SAP infrastructure? – in multiple ways I must say. In this blog we will try to understand how we can establish connection with the database/s and how can we execute some basic... Read More »

Shorter: When creating SAP HANA Cloud remote sources to on-premise Microsoft SQL Server database instances, those instances may be managed by the Microsoft SQL Server Browser service and the standard port of 1433 should not be specified for a remote... Read More »

Purpose It is very important to monitor the transaction log size of SQL Server. If SQL Server runs out of log space the system will come to a standstill. The log space is released when a log backup is performed. But the space is only made available... Read More »

Dear Reader, In this blog I will explain each step required to poll data from any database system using JDBC adapter in Cloud Integration and post that data in xml file format to FTP server location. I will only focus on configurations required for... Read More »

Hello CPI Enthusiasts, This series covers all about JDBC Adapter, and here are list of blogs: Part 1: Pre-requisites and Configuration Part 2: Update the DB using JDBC adapter via a Stored Procedure (Fields as parameter) Part 3: Update the DB using... Read More »

Hello CPI Enthusiasts, This series covers all about JDBC Adapter, and here are list of blogs: Part 1: Pre-requisites and Configuration Part 2: Update the DB using JDBC adapter via a Stored Procedure Part 3: Update the DB using JDBC adapter via a... Read More »

Hello CPI Enthusiasts, This series covers all about JDBC Adapter, and here are list of blogs: Part 1: Pre-requisites and Configuration Part 2: Update the DB using JDBC adapter via a Stored Procedure Part 3: Update the DB using JDBC adapter via a... Read More »

Purpose Deadlocks can occur in any SQL Server multiuser application. The occurrences of deadlocks are a problem of the application. It is not a SQL Server problem. SQL Server and SAP provide tools to detect, monitor and analyze the deadlocks. But in... Read More »

Introduction MS SQL Servers is a supported data source in SAP Analytics Cloud. Import connection is available via SAC and if you are interested in Live connection then go option is available connection via HANA SDA This blogpost shows a simple way... Read More »