FAQ

1. What is EDI?

EDI stands for Electronic Data Interchange which facilitates the exchange of electronic files. The term EDI is the industry standard terminology for electronic transactions.

2.What are different envelopes used to send an edi file and how are they used?

There are 3 types of envelopes:-

ISA- Identifies the sender and receiver using EDI transmission. It is an interchange control header

GS- Identifies the application type for the interchange for both sender and receiver. This segment is also used to provide control information. It is a functional group header.

ST- identifies the type of document you are sending or receiving.  It is the beginning of the document, or transaction set. It is a transaction set header.

3.What are the Advantages of IBM Sterling B2B Integrator ?

Sterling B2B Integrator is designed to be configured strategically around the specific processes crucial to your company’s success.

Its systematic and managed approach supports your integration requirements for both transaction-oriented and batch processes, and works with both pre-existing Electronic Data Interchange (EDI) protocols and Internet-based XML protocols.

You can enable your existing systems to integrate past, present, and future technologies and practices.

4.Sterling B2B Integrator 5.2 System Requirements ?

According to Gartner “Managed file transfer software and services enable users to manage and monitor file transfers within and between organizations.”

In this definition Gartner uses “manage” and “monitor” to highlight and explain the key differences between MFT and FTP.

Manage – means to manage all file transfers using one interface (one place) across all business units, operations, systems, applications, partners, etc.

Monitor – means to monitor all file transfers in one centralized location which in turn means better governance, compliance and reduced IT costs.

5. What is GPM Terminology ?

System requirements for IBM® Sterling B2B Integrator vary with your business needs and system environment. Contact your Sterling B2B Integrator sales representative to help you evaluate performance and system usage requirements.

Contributing factors include (but are not limited to) the following:

1. Number of transactions processed.

2. Amount of data being transferred.

3. Whether you run Sterling B2B Integrator with or without perimeter servers.

4. Whether your environment is clustered (multiple node) or non-clustered (single node).

The following sections list the platforms and databases that are supported by Sterling B2B Integrator:

1. Platforms

2. Databases

The following sections list minimum system requirements, and other information,needed to install and run Sterling B2B Integrator on particular platforms:

1.IPv6 Capabilities

2.UNIX/Linux Requirements

3.Windows Requirements

4.iSeries Requirements

The following sections list additional information that is needed to install and run Sterling B2B Integrator: v JCE Requirements (All Platforms)

1.JDBC Driver Requirements (All Databases)

2.Perimeter Server Requirements (UNIX/Linux and Windows)

3.Internet Browser and Plugin Requirements (All Platforms)

4.Map Editor and Graphical Process Modeler System Requirements

5.Supported Third Party Software

In the GPM, you construct your business process models, coordinating the flow of activities in a graphical depiction of the ordered steps. The GPM provides icons representing the services, adapters and BPML instructions that make up your process models. 1. GPM – Web-deployed graphical interface tool you use with Sterling B2B Integrator to create and modify business processes. The GPM converts yourgraphical business process models into BPML source code, saving you the effort of writing code.

In addition, you configure related service parameters through the GPM, create rules and conditions within your process models, and you can validate the process models and check them in to Sterling B2B Integrator from within the GPM.

The GPM recognizes BPML code written in a text editor. Therefore, in the GPM,you can open a .bpml file created in a text editor and view its graphical representation, and toggle between BPML and graphic view.

While the GPM is an included feature of Sterling B2B Integrator, it does not automatically install with Sterling B2B Integrator, because it operates as a separate, Web-deployed application. You must install the GPM on your client computer after you have installed Sterling B2B Integrator.

2. BPML – An XML-based language used to describe (model) and run business processes.

3. Java Web Start – The tool that Sterling B2B Integrator uses to ensure proper deployment of the GPM. Each time you open the GPM application, Java Web Start checks the Web server to determine whether a new version of the GPM is available. When a new version is available, Java Web Start automatically updates the files on the client computer and opens the GPM.

6.what is mean by Web Extensions ? How do you use it in SI ?

The processes that support your business usually include both human activities and computer-assisted automation. Yet, historically, integration technologies have targeted only the automated aspects of an integration project, such as low-level messaging, file transfer, or EDI. With Sterling B2B Integrator Web Extensions, you can build the human interaction points into your business process models.

Web Extensions uses advanced XML standards so that you can easily integrate your Web Extensions applications (forms) into your business process models and use Java Server Pages (JSP) to create forms pages.

Technically, Web Extensions is a collection of Sterling B2B Integrator services called Human Interaction services. The Graphical Process Modeler (GPM) depicts these services as icons in the user interface. You include these icons in your business process models by selecting the appropriate service wherever human interaction must occur.

Web Extensions can be used for:

Supporting human interaction steps within otherwise automated processes, such as:

Advanced exception or approval processing before data automatically passes into enterprise systems or out to business partners

Expense reporting

Creating e-commerce Web sites such as an online store with shopping cart functionality.

Improving partner and customer collaboration through secure selective data sharing by easily deploying partner self-service applications (such as payment, order, and shipment status forms).

Enabling small trading partners to interact with your business processes by configuring data transformation from the online forms to EDI or XML.

7.What is Managed File Transfer (MFT) ?

According to Gartner “Managed file transfer software and services enable users to manage and monitor file transfers within and between organizations.”

Manage – means to manage all file transfers using one interface (one place) across all business units, operations, systems, applications, partners, etc.In this definition Gartner uses “manage” and “monitor” to highlight and explain the key differences between MFT and FTP.

Monitor – means to monitor all file transfers in one centralized location which in turn means better governance, compliance and reduced IT costs.

8.About IBM Sterling File Gateway ?

Sterling File Gateway is an application for transferring files between partners by using different protocols, conventions for naming files, and file formats.

Sterling File Gateway uses the Sterling B2B foundation, which includes IBM® Sterling B2B Integrator, Sterling Standards, and the Sterling platform.

The capabilities that are delivered are similar to the features found in Advanced File Transfer and IBM Sterling Connect:Enterprise® for UNIX, plus new functionality.Use Sterling File Gateway for movement of large and high-volume file transfers, with end-to-end visibility of file movement in a process-oriented and highly-scalable framework.

This framework alleviates file transfer challenges, such as protocol and file brokering, automation, and data security.

Sterling File Gateway supports integration with:

Sterling B2B Integrator Mailbox

IBM Sterling Control Center

IBM Sterling Secure Proxy

IBM Sterling Connect: Direct® for UNIX server products

IBM Sterling Connect: DirectIBM WebSphere® MQ File Transfer Edition

Sterling File Gateway,

which is delivered on the Sterling B2B Integrator platform with a unique application URL, provides single sign-on access to the Sterling B2B Integrator administrative console through menu selection.

9.What are the features of Sterling File Gateway ?

  • File/File name Transformations – Mapping of input to output file names; system-wide, group, and partner-specific policies; common file processing tasks such as compression/decompression, PGP encryption/decryption, and signing.
  • File Transfer Visibility – Events are recorded for monitoring and reporting; detailed tracking for input-output file structure processing and dynamic route determination; ability to view and filter Sterling File Gateway data flows for all users.
  • Replay/Redeliver – One click replay/redeliver capability that allows users to reprocess one or multiple transmissions from the beginning or to resend one or multiple processed files to specific delivery destinations.
  • Predefined business processes – Define common behaviors in file-transfer scenarios, reducing the need for customization.
  • Extensibility – Custom event codes, protocols, facts, and consumer identification policies can be added to support unique scenarios.
  • Broad Communications Protocol Support – FTP, FTP/S, SSH/SFTP, SSH/SCP, IBM® Sterling Connect:Direct®, and IBM WebSphere® MQ File Transfer Edition are supported upon installation, and additional protocols (such as AS2, AS3, or Odette FTP) may be configured through use of the extensibility feature.
  • Partner Interface (my File Gateway) – Web browser-based interface that enables partners to upload/download files, subscribe to notifications of events, manage passwords, search and view file transfer activity, and generate reports about file transfer activity.
  • Flexible Mailbox Structures – Ability to specify mailbox structures that leverage pattern matching policies and specify attributes that must be true of all partners or a subset of partners.
  • Dynamic Routing – Consumer derived at run-time, either through mailbox structure, file name, business process-derived consumer name, or map-derived consumer name.
  • Partner On boarding – Easy-to-use graphical user interface to onboard partners and configure the various combinations of communication protocols to enable Sterling File Gateway operations.

10.How Sterling B2B Integrator and Sterling File Gateway work together ?

Sterling File Gateway utilizes the Sterling B2B foundation, which includes Sterling B2B Integrator, Sterling Standards, and the Sterling platform, to deliver capabilities similar to those found in Sterling Advanced File Transfer and Sterling Connect:Enterprise® for UNIX, while adding new features and functionality.

Within Sterling File Gateway, Sterling B2B Integrator is known as the B2B Console, and is accessed from the Tools menu. Administrative functions such as creating and managing user accounts, permission groups, and security keys for Sterling File Gateway are handled in Sterling B2B Integrator.

Sterling File Gateway utilizes the communication adapters of Sterling B2B Integrator, which include the following:

  • FTP Server adapter
  • FTP Client adapter
  • SFTP Server adapter
  • SFTP Client adapter
  • HTTP Server adapter
  • HTTP Client adapter
  • Connect:Direct Server adapter
  • Command Line adapter 2 (for PGP)

11.About the Web application myFileGateway ?

Partners send and retrieve files from the Web application my File Gateway. To log in to myFileGateway, a valid user account is required. This user account is created when a Route Provisioner on boards the partner.From within my File Gateway,

partners can:

  • Upload or download files.
  • Search for routes they participated in.
  • View recent activity and status for file transfers they participated in.
  • Generate reports for activity they participated in.
  • Change their password.
  • Subscribe to notifications.

12.What is BPML ?

Business process modeling language is an xml based language for describing business process designed by the business process management initiative.  BPML activities provide the directions for how data should be handled.

13.What is process data ?

Process data is nothing but the information and the primary document for all the services in a business process in the form of XML. To access process data we use xpath expression language.

14.What is Correlation ?

Correlation is used for document tracking.

Correlation data enable you to record document, a specific correlation parameters generated during the translations by the correlation service or by the document tracking function.

15.What is xpath ?

Xpath is an expression language used to navigate the xml data.

16.What is adapter ?

It will connect to the external system with sterling integrator.

17.Explain about BP metadata info service ?

It provides the complete details and properties of the business process and these properties will be available in process data. Some of the properties are

  • BPID
  • Process name
  • Description
  • State
  • Status
  • Type
  • Correlations

18.Explain about Assign Service ?

Assign service is used for to store values into a variable; values can be constant value or process data value. We can place values into process data.

  • Configuration:
  • Append : false
  • Constant :
  • From:
  • To:

19.Explain about Time stamp utility service ?

The time stamp utility service enables you to create time stamp values to the business process for the current time.

  • Configuration: time stamp utility.
  • Format: mmss
  • Scale: milliseconds.

20.Explain about EDI Encoder Service ?

It determines which transaction level envelop will be used on the document. If translations are specified in an envelop, this service determines which map to use.

Configuration:

  • Accepter lookup alias:
  • EDI Standard:
  • Mode: immediate (or) deferred.
  • Receiver id:
  • Sender id:

21) What is the difference between electronic data interchange provided by an EDI VAN and   Internet EDI?

VAN a Value Added Network, often referred to as an EDI VAN, is a private network dedicated to the secure exchange of EDI data.  Trading partners obtain an account with an EDI VAN such as GXS VAN, Sterling, EDS/ELIT, COVISINT INTERCONNECT etc.  This account serves as an electronic mailbox for sending and receiving electronic documents.

Internet EDI is another way of communication, it’s similar to OFTP2. You r partner can send you the data to your server via Internet or vice versa.

22)What are different EDI Standards and Application Standards Formats?

  • EDI Standard : ANSI X12, UCS, EDIFACT, VDA, TREDACOM etc.
  • Application Format Standard : IDoc, Delimited Files, CSV etc.

23) How do I know what type of file I received?

The ST segment is the transaction set header. The ST purpose is to indicate the start of a transaction set. The ST01 is the Transaction Set Identifier Code. The ST01 uniquely identifies a transaction set. The ST01 will identify if a file is a 997, 835 or 277.

24)How do I know if my file was accepted?

AK5*A~                                ß AK501 = A, transaction set accepted

A – Accepted

E – Accepted with Errors

R – Rejected

AK9*A*1*1*1~                 ß AK901 = A, file accepted

A – Accepted

E – Accepted, But Errors Were Noted.

P – Partially Accepted, At Least One Transaction Set Was Rejected

R – Rejected

25) What is AS1, AS2 and AS3?

AS1 : AS2 (Applicability Statement 2) is a specification about how to transport data securely and reliably over the Internet

AS2 : AS2 (Applicability Statement 2) is a specification about how to transport data securely and reliably over the Internet. Security is achieved by using digital certificates and encryption.

Files are sent as “attachments” in a specially coded SMIME message (an AS2 message)

AS2 messages are always sent using the HTTP or HTTPS protocol (Secure Sockets Layer — also known as SSL — is implied by HTTPS) and usually use the “POST” method (use of “GET” is rare).

AS3 : AS3 (Applicability Statement 3) is the draft specification standard by which vendor applications communicate EDI (or other data such as XML) over the Internet using File Transfer Protocol (FTP).

26)What is Pre and post session Rules?

Pre-session rules define variables that have global scope (can be accessed from any other extended rule in the map). Pre-session extended rules are processed before the translation object is processed, and apply to every extended rule defined in the map.

Post-session rules are run after the translation object is processed and thus have no permanent scope.

27)What is basic flow of Map Editor?

First Input file will read, then it will apply for standard rule on source side then check for extended rule then linking, then it will go to target side and apply standard rule, then extended rule. Pre and Post rule will applicable according.

28)What do you understand by Promotion in Map Editor?

The Promote function extracts one iteration (instance) of one of the following map components:

  • Group
  • Repeating record
  • Repeating element
  • repeating composite

Promote is a specialized version of the Split function. For example, if you have a group with 50 iterations and you select Promote, you then have two groups: one group with an iteration of 1 and a group that iterates 49 times.

This function enables you to map unique data from a document and to type a specialized definition. The translator specifies that only one-to-one (no loop) or many-to-many (loop) mapping relationships are valid. The Promote function is available only if a group or repeating record, element, or composite is selected.

29)Different type of Delimiters?

  • Tag Delimiter                     ~
  • Segment Delimiter          *
  • Element Delimiter           *
  • Sub Element Delimiter
  • Repeating Element Delimiter

30)Expalin Inbound and Outbound BP Flow?

Inbound Flow:
1) The inbound, EDI data needs to be collected.
2) The collected data should be De-enveloped (removing the headers) to get the message part also.
3) Using the header information (Interchange, Group, Message and version) the Envelope setup (Trading Partner setup) will be identified.
4) The Envelope setup contains (points) the Map which can be used to translate the data.
5) The translated data can be extracted to the specified directory.
Outbound Flow:
1) Collect the files.
2) Use the Typer map or Data extraction map to extract the data to identify the User and partner information.
3) These info can be used to identify the Envelope which points to a map.
4) The Map translates the data and Envelopes the data with the header segments.
5) The translated files can be extracted to the specified directory.
31)Explain about Light Weight JDBC Adapter ?

It enables us to Retrieve data from a JDBC database or Update a JDBC database as part of a business process with in the Gentran Integration Suite.

32)What is XSLT?

 XSLT is another popular XML technology to transform one XML file to other XML, HTML or any other format. XSLT is like a language which specifies its own syntax, functions and operator to transform XML documents. Usually transformation is done by XSLT Engine which reads instruction written using XSLT syntax in XML style sheets or XSL files. XSLT also makes extensive use of recursion to perform transformation. One of the popular example of using XSLT is for displaying data present in XML files as HTML pages. XSLT is also very handy to transforming one XML file into another XML document.