Show TOC

Background documentationThe External Part of the ASCII Adapter

Prerequisites

The computer on which the ASCII Adapter is installed must meet the following requirements:

  • It must be integrated in your network.

  • It must run on Windows NT.

  • The client software of the used OLTP ERPdatabase must be installed.

    Note Note

    This software is available in conjunction with the ERP license for the CRM Middleware.

    End of the note.

  • Databases supported are: SAPDB, ORACLE, Microsoft SQL Server and DB2 for NT or AIX

  • The appropriate Dynamic Link Library (DLL) for accessing the database must be installed. If you use an SAPDB database, this is DBADASLIB.DLL and PCR71MD.DLL, if you use an ORACLE database, this is DBORASLIB.DLL; if you use a Microsoft SQL Server database, this is DBMSSlLIB.DLL) and if you use a DB2 database, this is DBDB6SLIB.DLL. (compare Database Configuration).

    Note Note

    This software is available in conjunction with the ERP license for the CRM Middleware.

    End of the note.

  • If the flow is to be started via RFC, fileLIBRFC32.DLL must be available on your machine

    Note Note

    This file is part of the ERP Basis software.

    End of the note.

  • The Executable Program can be started in MS-DOS command mode or in a background job.

Integration

It is ideal to install the program on the communication station since the communication station can supply the required environment with some of the required DLLs and provide the connection to the CRM Server.

Features

One ASCII file is converted into one database table.

One line of the ASCII file corresponds to one data record in a database table.

Either the data record has an exact fixed length, or the fields are separated by commas (comma-separated values (CSV)).

During the conversion process, you can:

  • Change the sequence of fields

  • Omit fields

  • Convert data types

Constraints

Business logic is not supported, which means that data from external systems must be consistent within itself.