SAP DB:ODBC Manuale Utente Scaricare il pdf (Pagina 2)

Abstract

You can connect to an SAP HANA database using ODBC. This article explains how to configure

an OBDC connection for SAP HANA in PowerCenter, the Administrator tool, the Developer tool,

and the Analyst tool.

Supported Versions

 Data Explorer 9.5.1

 Data Quality 9.5.1

 Data Services 9.5.1

 PowerCenter 9.5.1

 PowerExchange 9.5.1

Table of Contents

Overview .......................................................................................................................................... 2

Step 1. Install the SAP HANA ODBC Driver ................................................................................... 3

Step 2. Create ODBC Data Sources ............................................................................................... 3

Create an ODBC Data Source on Windows ................................................................................ 3

Create an ODBC Data Source on UNIX ...................................................................................... 4

Step 3. Create ODBC Connections in Informatica Clients .............................................................. 4

Create a Relational ODBC Connection in PowerCenter ............................................................. 4

ODBC Connection Properties for SAP HANA .......................................................................... 4

Creating an ODBC Connection in the Workflow Manager ....................................................... 5

Create an ODBC Connection in the Administrator Tool, Analyst Tool, or Developer Tool.......... 5

ODBC Connection Properties for SAP HANA .......................................................................... 5

Creating an ODBC Connection in the Administrator Tool ........................................................ 6

Creating an ODBC Connection in the Analyst Tool ................................................................. 6

Creating an ODBC Connection in the Developer Tool ............................................................. 6

Overview

Effective in version 9.5.1, you can use Informatica clients to read data from and write data to an

SAP HANA database. To read from and write to SAP HANA, you must configure a connection to

the SAP HANA database. You can configure connections to SAP HANA in Informatica.

Configure connections to SAP HANA so that you can complete the following tasks:

Create physical data objects and preview data.

Informatica clients communicate with the SAP HANA database when you create sources

and targets, create physical data objects, or preview data. Informatica clients use ODBC

to communicate with SAP HANA databases.

Perform data integration tasks.

The PowerCenter Integration Service and the Data Integration Service perform data

integration tasks that read from and write to SAP HANA databases and perform lookups

against SAP HANA databases. For example, the PowerCenter Integration Service might

1 2 3 4 5 6 7

Nessun commento

SAP DB:ODBC Manuale Utente Pagina 2