Welcome to Progress DataDirect for ODBC for SAP S/4HANA Driver: Version 8.0.0
What's new in this release?
Driver requirements
Installing and setting up the driver (Windows)
Installing and setting up the driver (Linux)
Connection string examples
Basic authentication
Proxy server
Data types
Driver specifications
Additional information
Troubleshooting
Contacting Technical Support
Tutorials
The Example application
Power BI (Windows only)
Tableau (Windows only)
Microsoft Excel (Windows only)
Configuring and connecting to data sources
Environment settings
Windows environment variables
Linux Environment Variables
Library Search Path
ODBCINI
ODBCINST
DD_INSTALLDIR
The Test Loading Tool
UTF-16 Applications on Linux
Configuring data sources with the Configuration Manager
Generating connection strings with the Configuration Manager
Using a connection string
Additional configuration methods for Linux
Configuration through the system information (odbc.ini) file
Sample default odbc.ini file
DSN-less connections
Sample odbcinst.ini file
File data sources
Testing connections and queries with the Configuration Manager
Using a logon dialog box
Authentication
Performance considerations
Using the SQL engine server
Configuring server mode using the Configuration Manager
Stopping the SQL Engine Server using the Configuration Manager
Configuring the SQL Engine Server using Java options
Stopping the SQL Engine Server
Configuring Java Logging for the SQL engine server
Connection option descriptions
Application Using Threads
Authentication Method
Create Map
Data Source Name
Description
Extended Options
Fetch Size
Host Name
Initialization String
JVM Arguments
JVM Classpath
JVM Path
Keyword Conflict Suffix
Log Config File
Password
Proxy Host
Proxy Password
Proxy Port
Proxy User
Read Only
Refresh Schema
Report Codepage Conversion Errors
Schema Map
Server Port Number
Server Proxy Host
Server Proxy Password
Server Proxy Port
Server Proxy User
Service List
Service Version
SQL Engine Mode
SQL Service
Statement Call Limit
Statement Call Limit Behavior
Transaction Mode
User
Web Service Compress Data
Web Service Fetch Size
Supported SQL statements and extensions
Alter Session (EXT)
Refresh Map (EXT)
Select
Select clause
Aggregate functions
From clause
Join in a From clause
Subquery in a From clause
Where clause
Group By clause
Having clause
Union operator
Intersect operator
Except and Minus operators
Order By clause
Limit clause
Update
Subqueries
IN predicate
EXISTS predicate
UNIQUE predicate
Correlated subqueries
SQL expressions
Column names
Literals
Character string literals
Numeric literals
Binary literals
Date/Time literals
Integer literals
Operators
Unary operator
Binary operator
Arithmetic operators
Concatenation operator
Comparison operators
Logical operators
Operator precedence
Functions
Conditions
Introduction to the SAP S/4HANA Data Model
A_ADDRESSEMAILADDRESS
A_ADDRESSFAXNUMBER
A_ADDRESSHOMEPAGEURL
A_ADDRESSPHONENUMBER
A_BPCONTACTTOADDRESS
A_BPCONTACTTOFUNCANDDEPT
A_BUPAADDRESSUSAGE
A_BUPAIDENTIFICATION
A_BUPAINDUSTRY
A_BUSINESSPARTNER
A_BUSINESSPARTNERADDRESS
A_BUSINESSPARTNERBANK
A_BUSINESSPARTNERCONTACT
A_BUSINESSPARTNERROLE
A_BUSINESSPARTNERTAXNUMBER
A_CUSTOMER
A_CUSTOMERCOMPANY
A_CUSTOMERDUNNING
A_CUSTOMERSALESAREA
A_CUSTOMERSALESAREATAX
A_CUSTOMERWITHHOLDINGTAX
A_CUSTSALESPARTNERFUNC
A_SUPPLIER
A_SUPPLIERCOMPANY
A_SUPPLIERDUNNING
A_SUPPLIERPARTNERFUNC
A_SUPPLIERPURCHASINGORG
A_SUPPLIERWITHHOLDINGTAX
Copyright
Welcome to Progress DataDirect for ODBC for SAP S/4HANA Driver: Version 8.0.0
Copyright
windowsquickstart
linuxquickstart
powerbi
s4hanalogon