About Frank-Martin

Frank-Martin · 02-21-2024

In this blog post, we will show how you can build up an Azure Data Factory (ADF) pipeline to load data from an SAP system using the ABAP SQL Service and the ODBC driver for ABAP. We will describe how we used a simplified Azure Data Factory pipeline s...

Frank-Martin · 06-14-2023

In this blog post, I’m going to explain the Insert Time Clustering (ITC) table type in Db2 for Linux, UNIX, and Windows (Db2 LUW) and show its major benefit: easy space reclamation. I’ll also show you how you can convert regular tables to ITC tables...

Frank-Martin · 03-02-2023

In my introductory blog post related to ABAP SQL services (Consuming CDS View Entities Using ODBC-Based Client Tools | SAP Blogs), I described how to expose CDS objects in a SQL Service, how to install the ODBC driver for ABAP on Windows, and how to ...

Frank-Martin · 12-09-2022

In previous blog posts, we showed you how you can access CDS view entities in an ABAP system using SQL via Open Database Connectivity (ODBC). The ODBC interface has the advantage that it allows unrestricted SQL access to all exposed ABAP CDS view ent...

Frank-Martin · 11-22-2022

I have good news for Db2 LUW database administrators: We have optimized the local client copy by using the SAPTOOLS.BULK_INSERT procedure. Background A local client copy in an ABAP system loops over all client-dependent tables and copies all rows of ...

Frank-Martin · 03-21-2024

CLIENT=100 worked in my DSN example although I connected to an SAP BTP ABAP Environment system.In general you should not specify this parameter for an ABAP cloud system. On OnPrem systems it is required.

Frank-Martin · 03-07-2024

Hi Joachim,we decided to change the Db2 V11.5 parameter note 2751102. The note now requiresACT_SORTMEM_LIMIT=100and we added a comment that the value 100 and NONE are synonyms for this parameter.This is in line with the IBM documentation and should s...

Frank-Martin · 03-06-2024

Hi Joachim,yes, this is somewhat strange. For this parameter the value is displayed differently via "get db cfg" and by the corresponding table functions.We will need to check and discuss this.Regards Frank> db2 get db cfg for FMH | gre...

Frank-Martin · 10-05-2023

Somebody must have changed the password of user SAPSOL on your database server without updating the password in the SAP password store.Update the password store on one of your SolMan appservers with:dscdb6up -create <current pwd of user SAPSOL> "dumm...

Frank-Martin · 09-11-2023

Hi Kimon, thanks. Unfortunately on your S/4 version the SQL Service ABAP backend code is not yet available. Therefore the ODBC driver for ABAP can not be used in this version. Is upgrading your S/4 version an option? On your current S/4 version you...

User Statistics

User Activity

Build an Azure Data Factory Pipeline with the ODBC Driver for ABAP

Simplified Space Reclaim Using Insert Time Clustering (ITC) Tables

Access CDS Objects Exposed as SQL Services Using Microsoft SQL Server

SQL Queries on CDS objects Exposed as SQL Service

Optimized Local Client Copy on Db2 for LUW by Using BULK_INSERT

Re: Consuming CDS View Entities Using ODBC-Based Client Tools

Re: Paramter Check in Db2 (db6)

Re: Paramter Check in Db2 (db6)

Re: Solman down due to Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID")

Re: Using the ODBC driver for ABAP on Linux