Adapter Administration

Feedback

Copyright © 2015 Information Builders

This manual describes the configuration and management of Adapters. It is intended for database administrators and application developers.

How This Manual Is Organized

This manual includes the following chapters:

Chapter/Appendix

Contents

1

Introduction to Adapters

Describes how to use adapters.

2

Using the Adapter for 1010data

Describes how to configure the Adapter for 1010data.

3

Using the Adapter for Adabas

Describes how to configure the Adapter for Adabas.

4

Using the Adapter for Adabas Stored Procedures

Describes how to configure the Adapter for Adabas Stored Procedures.

5

Using the Adapter for Alchemy Sentiment Analysis

Describes how to configure the Alchemy Sentiment Analysis Adapter.

6

Using the Adapter for Axiom EPM

Describes how to configure the Adapter for Axiom EPM.

7

Using the Adapter for C9 INC

Describes how to configure the Adapter for C9 INC.

8

Using the Adapter for Caché

Describes how to configure the Adapter for Caché.

9

Using the Adapter for CICS Transactions

Describes how to configure the Adapter for CICS Transactions.

10

Using the Adapters for C-ISAM and ISAM

Describes how to configure the Adapter for C-ISAM and ISAM.

11

Using the Adapter for DATACOM

Describes how to configure the Adapter for DATACOM.

12

Using the Adapter for DB2

Describes how to configure the Adapter for DB2.

13

Using the Adapter for DB Heritage Files

Describes how to configure the Adapter for DB Heritage Files.

14

Using the Adapter for Essbase

Describes how to configure the Adapter for Essbase.

15

Using the Adapter for Excel

Describes how to configure the Adapter for Excel.

16

Using the Adapter for Excel (via Direct Retrieval)

Describes how to configure the Adapter for Excel (via Direct Retrieval).

17

Using the Adapter for Facebook

Describes how to configure the Facebook Adapter.

18

Using the Adapters for Flat and Delimited Flat Files

Describes how to configure the Adapter for Flat and Delimited Flat Files.

19

Using the Adapter for Google Analytics

Describes how to configure the Google Analytics Adapter.

20

Using the Adapter for Greenplum

Describes how to configure the Adapter for Greenplum.

21

Using the Adapter for Hadoop with Apache Hive and Cloudera Impala

Describes how to configure the adapter for Hadoop with Apache Hive and Cloudera Impala.

22

Using the Adapter for HP Vertica

Describes how to configure the Adapter for HP Vertica.

23

Using the Adapter for Hyperstage

Describes how to configure the Adapter for Hyperstage.

24

Using the Adapter for i Access

Describes how to configure the Adapter for ODBC.

25

Using the Adapter for CA-IDMS/DB

Describes how to configure the Adapter for CA-IDMS/DB.

26

Using the Adapter for CA-IDMS/SQL

Describes how to configure the Adapter for CA-IDMS/SQL.

27

Using the Adapter for IMS

Describes how to configure the Adapter for IMS.

28

Using the Adapter for IMS Transactions

Describes how to configure the Adapter for IMS Transactions.

29

Using the Adapter for Informix

Describes how to configure the Adapter for Informix.

30

Using the Adapter for Ingres

Describes how to configure the Adapter for Ingres.

31

Using the Adapter for Interplex

Describes how to configure the Adapter for Interplex.

32

Using the Adapter for iWay Adapter Framework (IWAF)

Describes how to configure the Adapter for iWay Adapter Framework (IWAF).

33

Using the Adapter for JBoss Application Server

Describes how to configure the Adapter for JBoss Application Server.

34

Using the Adapter for JDBC

Describes how to configure the Adapter for JDBC.

35

Using the Adapter for JD Edwards EnterpriseOne

Describes how to configure the Adapter for JD Edwards EnterpriseOne.

36

Using the Adapter for JD Edwards World

Describes how to configure the Adapter for JD Edwards World.

37

Using the Adapter for JSON

Describes how to configure the Adapter for JSON.

38

Using the Adapter for Lawson

Describes how to configure the Adapter for Lawson.

39

Using the Adapter for LinkedIn

Describes how to configure the LinkedIn Adapter.

40

Using the Adapter for Lotus Notes

Describes how to configure the Adapter for Lotus Notes.

41

Using the Adapter for LDAP

Describes how to configure the Adapter for LDAP.

42

Using the Adapter for Microsoft Access

Describes how to configure the Adapter for Microsoft Access.

43

Using the Adapter for Microsoft SQL Server

Describes how to configure the Adapter for Microsoft SQL Server.

44

Using the Adapter for Microsoft SQL Server ODBC

Describes how to configure the Adapter for Microsoft SQL Server ODBC.

45

Using the Adapter for Millennium

Describes how to configure the Adapter for Millennium.

46

Using the Adapter for Model 204

Describes how to configure the Adapter for Model 204.

47

Using the Adapter for MongoDB

Describes how to configure the adapter for MongoDB.

48

Using the Adapter for MySQL

Describes how to configure the Adapter for MySQL.

49

Using the Adapter for NATURAL

Describes how to configure the Adapter for NATURAL.

50

Using the Adapter for NATURAL CICS Transactions

Describes how to configure the Adapter for NATURAL CICS Transactions.

51

Using the Adapter for Netezza

Describes how to configure the Adapter for Netezza.

52

Using the Adapter for Nucleus

Describes how to configure the Adapter for Nucleus.

53

Using the Adapter for ODBC

Describes how to configure the Adapter for ODBC.

54

Using the Adapter for Oracle

Describes how to configure the Adapter for Oracle.

55

Using the Adapter for Oracle E-Business Suite

Describes how to configure the Adapter for Oracle E-Business Suite.

56

Using the Adapter for Oracle TimesTen

Describes how to configure the Adapter for Oracle TimesTen.

57

Using the Adapter for parAccel

Describes how to configure the Adapter for parAccel.

58

Using the Adapter for PeopleSoft

Describes how to configure the Adapter for PeopleSoft.

59

Using the Adapter for PostgreSQL

Describes how to configure the Adapter for PostgreSQL.

60

Using the Adapter for Progress

Describes how to configure the Adapter for Progress.

61

Using the Adapter for PSQL

Describes how to configure the Adapter for PSQL.

62

Using the Adapter for Query/400

Describes how to configure the Adapter for Query/400.

63

Using the Adapter for Rdb

Describes how to configure the Adapter for Rdb.

64

Using the Adapter for Red Brick

Describes how to configure the Adapter for Red Brick.

65

Using the Adapter for REST

Describes how to configure the Adapter for REST.

66

Using the Adapter for Remote Servers

Describes how to configure the Adapter for Remote Servers.

67

Using the Adapter for RMS

Describes how to configure the Adapter for RMS.

68

Using the Adapter for Salesforce.com

Describes how to configure the Adapter for Salesforce.com.

69

Using the Adapter for SAP Business Intelligence Warehouse (BW)

Describes how to configure the Adapter for SAP Business Intelligence Warehouse (BW).

70

Using the Adapter for SAP

Describes how to configure the Adapter for SAP.

71

Using the Adapter for SAP Hana

Describes how to configure the Adapter for SAP Hana.

72

Using the Adapter for Siebel

Describes how to configure the Adapter for Siebel.

73

Using the Adapter for SQLBase

Describes how to configure the Adapter for SQLBase.

74

Using the Adapter for SQL Server Analysis Services (SSAS)

Describes how to configure the Adapter for SQL Server Analysis Services (SSAS).

75

Using the Adapter for Sybase

Describes how to configure the Adapter for Sybase.

76

Using the Adapter for Teradata

Describes how to configure the Adapter for Teradata.

77

Using the Adapter for Transoft

Describes how to configure the Adapter for Transoft.

78

Using the Adapter for Twitter

Describes how to configure the Twitter Adapter.

79

Using the Adapter for UniData

Describes how to configure the Adapter for UniData.

80

Using the Adapter for UniVerse

Describes how to configure the Adapter for UniVerse.

81

Using the Adapter for VSAM

Describes how to configure the Adapter for VSAM.

82

Using the Adapter for WAND Sentiment Analysis

Describes how to configure the WAND Sentiment Analysis Adapter.

83

Using the Adapter for Web Services

Describes how to configure the Adapter for Web Services.

84

Using the Adapter for Words Analysis

Describes how to configure the Words Analysis Adapter.

85

Using the Adapter for XML

Describes how to configure the Adapter for XML.

A

XA Support

Describes XA Transaction Management and implementation specifics.

B

Aggregate Awareness Support

Describes Aggregate Awareness, which substantially improves the efficiency of queries.

C

Cluster Join

Describes the Master File SEGSUF attribute, which enables you to create heterogeneous cluster joins.

D

Translating COBOL File Descriptions

Describes how synonyms are created from COBOL File Descriptions.

E

Data Set Compression Exit: ZCOMP

Describes how to use the ZCOMP Exit for data set compression.

F

Dynamic Private User Exit

Describes how use the Dynamic Private User Exit API.

G

Validation for Special Characters and Reserved Words

Describes how the Web Console validates special characters and reserved words.

Documentation Conventions

The following conventions apply throughout this manual:

Convention

Description

THIS TYPEFACE

or

this typeface

Denotes syntax that you must enter exactly as shown.

this typeface

Represents a placeholder (or variable) in syntax for a value that you or the system must supply.

underscore

Indicates a default setting.

this typeface

Represents a placeholder (or variable), a cross-reference, or an important term. It may also indicate a button, menu item, or dialog box option that you can click or select.

Key + Key

Indicates keys that you must press simultaneously.

{  }

Indicates two or three choices. Type one of them, not the braces.

[  ]

Indicates a group of optional parameters. None are required, but you may select one of them. Type only the parameter in the brackets, not the brackets.

|

Separates mutually exclusive choices in syntax. Type one of them, not the symbol.

...

Indicates that you can enter a parameter multiple times. Type only the parameter, not the ellipsis (...).

.

.

.

Indicates that there are (or could be) intervening or additional commands.

Related Publications

Visit our Technical Documentation Library at http://documentation.informationbuilders.com. You can also contact the Publications Order Department at (800) 969-4636.

Customer Support

Do you have any questions about this product?

Join the Focal Point community. Focal Point is our online developer center and more than a message board. It is an interactive network of more than 3,000 developers from almost every profession and industry, collaborating on solutions and sharing tips and techniques, http://forums.informationbuilders.com/eve/forums.

You can also access support services electronically, 24 hours a day, with InfoResponse Online. InfoResponse Online is accessible through our website, http://www.informationbuilders.com. It connects you to the tracking system and known-problem database at the Information Builders support center. Registered users can open, update, and view the status of cases in the tracking system and read descriptions of reported software issues. New users can register immediately for this service. The technical support section of www.informationbuilders.com also provides usage techniques, diagnostic tips, and answers to frequently asked questions.

Call Information Builders Customer Support Service (CSS) at (800) 736-6130 or (212) 736-6130. Customer Support Consultants are available Monday through Friday between 8:00 a.m. and 8:00 p.m. EST to address all your questions. Information Builders consultants can also give you general guidance regarding product capabilities. Please be ready to provide your six-digit site code number (xxxx.xx) when you call.

To learn about the full range of available support services, ask your Information Builders representative about InfoResponse Online, or call (800) 969-INFO.

Information You Should Have

To help our consultants answer your questions most effectively, be ready to provide the following information when you call:

User Feedback

In an effort to produce effective documentation, the Technical Content Management staff welcomes your opinions regarding this document. Please use the Reader Comments form at the end of this document to communicate your feedback to us or to suggest changes that will support improvements to our documentation. You can also contact us through our website, http://documentation.informationbuilders.com/connections.asp.

Thank you, in advance, for your comments.

iWay Software Training and Professional Services

Interested in training? Our Education Department offers a wide variety of training courses for iWay Software and other Information Builders products.

For information on course descriptions, locations, and dates, or to register for classes, visit our website (http://education.informationbuilders.com) or call (800) 969-INFO to speak to an Education Representative.

Interested in technical assistance for your implementation? Our Professional Services department provides expert design, systems architecture, implementation, and project management services for all your business integration projects. For information, visit our website (http://www.informationbuilders.com/support).