Friday, October 9, 2015

Sterling File Gateway Concepts

Sterling file gateway ■ 

An MFT solution designed on top of Sterling B2B foundation for transferring files between partners using different protocols, file naming conventions, and file formats. ■ Has following features –Scheduled high volume - high frequency file transfers –File and File name Transformations –File Transfer Visibility (file route and events reports) –Replay / Re-delivery –Notifications (partners and operators) –Broad Communications Protocol Support (FTP, FTP/S, SSH/SFTP, SSH/SCP, and Sterling Connect:Direct) –Dynamic Routing –Easy-to-use Partner Onboarding UI –Flexible Mailbox Structures (to support pattern matching) ■ Works on the basis of predefined business processes ■ Has a web browser based Partner interface named myFileGateway –The partner can upload files using this UI which can then be routed using protocol adapters like FTP/SFTP –Partner can subscribe to notifications



Important Sterling Integrator Concepts


SFTP concept in Sterling Integrator


The following keys are used to allow an SFTP Client adapter to connect with a
remote SFTP server.

*** User Identity Key – Private/Public key pair used to identify Sterling Integrator
as a user on a remote server. Generate this key within Sterling Integrator and
provide the public part of the key to your trading partner.

*** Known Host Key – Public key used to authenticate remote SFTP servers to
Sterling Integrator’s SFTP Client adapter. Request this key from your trading
partner.

The following keys are used by the SFTP Server adapter to allow connections from
remote clients:

*** Authorized User Key – A public key used to authenticate remote users to
Sterling Integrator SFTP Server adapters. One one or more Authorized User keys
can be associated with a user account. Request the key(s) from your trading
partner and include the key(s) in their Sterling Integrator user account.
*** Host Identity Key – Private/Public key pair used to identify the Sterling
Integrator SFTP Server adapter to remote clients. Generate this key within
Sterling Integrator.


Perimeter Server ■ Perimeter server is a software for communications management that –manages the communications flow between outer layers of your network and the TCP-based transport adapters –can be installed in a DMZ (De-Militarized Zone – the zone between a trusted internal network and an untrusted external network Eg: internet) –Provides security and scalability


HTTP Server Adapter ■ The HTTP Server Adapter is based on jetty http engine and provides support for HTTP protocol in the following way –You can run a full fledged web application from a WAR file –You can run a Business Process with the incoming data as primary document ■ It provides a URI based configuration for routing data –The adapter listens on a configured port and can accept simple TCP or secure SSL/TLS connection based on how it is configured –The incoming HTTP request is routed to configured BPs or WAR applications based on URI

HTTP Client Adapter ■ HTTP Client Adapter provides client capabilities in the following way –Scriptable using Business process (BPML) in SI and available in the GPM –Connects to the configured host and sends/receives business data using the HTTP protocol –Supports GET and POST Http methods and secure SSL connections (https) –Supports connecting through a HTTP proxy ■ The client adapter supports big payloads (tested up to 2 GB) and supports more than 150 concurrent transfers


SFTP Server Adapter ■ SFTP Server adapter provides secure file transfer support with SFTP protocol –Works on top of Secure SHell (SSH) protocol for transport security –Uses SSH Host Identity keystore (private keys) and Authorized User key store (public keys) in SI for SSH keys –Capable of exposing a Mailbox or an actual (native) file system directory as the SFTP file system to the connected user –Supports restrictions via Virtual Roots and adapter policies (more on policies later)

SFTP Client Adapter ■ SFTP Client Adapter provides client capabilities in the following way –Scriptable using Business process (BPML) in SI and is available in the GPM –Connects to the configured host and executes specified SFTP commands –Supports SFTP commands like cd, list, get, put, delete, pwd, mkdir, rmdir, move that help in sending/retrieving/organizing business data in the partner's SFTP server –Supports connecting through a HTTP proxy


FTP Server Adapter ■ FTP Server adapter provides support for sending/receiving files using the the FTP protocol –Exposes a Mailbox or an actual (native) file system directory as the FTP file system to the connected user –Supports a large set of FTP commands (rfc 959) –Supports secure SSL/TLS connections (FTPS) –Supports restrictions via Virtual Roots and adapter policies (more on this later) –Supports User Exits (custom code execution on FTP events)


FTP Client Adapter ■ FTP Client Adapter provides client capabilities for the FTP protocol in the following way –Scriptable using Business process (BPML) in SI and is available in the GPM –Connects to the configured host and executes specified FTP commands –Supports FTP commands like cd, list, get, put, delete, pwd, site, quote, move that help in sending/retrieving/organizing business data in the partner's FTP server –Supports FTPS (FTP over SSL) for transport security ■ Tested with large files up to 15 GB



Saturday, June 27, 2015

Sterling Inegrator Map Editor Issues

Issue 1 : 

Map Test is not working

Error Message
 
Error: Failed opening socket; No connection could be made because the target machine actively refused it.

Reason : 










Resolution :

Need enable the "Map Test Http Server Adapter" service

Tuesday, May 5, 2015

Introduction to EAI(webmethods)

I)Introduction:
The company pioneered the use of web services to connect software applications together within a single organization and across the Internet.
II)Focused On:
1)Application Integration.
2)Business Process Integration.
3)B2B Partner integration.
III)Basis:
It is based on the idea to use the new standards of the Web such as HTTP and XML to allow software applications to communicate with one another in a real time.
Series of development consist of:
1)Web Automation Server.
2)Web Methods B2B Integration Server.
IV)Basic Function of this software:
 It is basically an “engine for running services” .A service can be viewed as a black box which performs some computational function. It takes in required data, required messages  and generates the output as required by the required computation. 
The Web method  integration server is a service engine therefore to IS, everything is viewed as a service.
V)Other Components of it are as follows:
1)Integration Servers:
It is the engine for running services .Many other modules are used as an add on the integration server on the top of the IS. Some of the examples are Trading Networks, Flat File Handler and Business Process
Modeler  as well as the administrative GUI’s for other modules.
Features of the Integration Server is as follows:
 a) An engine for running local services, distributed services, web services.
 b) A client enabler to invoke local services, distributed services, web services.
c) To bind two disparate systems.
d) An XML parser and generator.
It uses the Webmethod  Flow Procedural Statements which are :
1) MAP(assignment statement).
2) BRANCH(decision statement).
3) LOOP(iteration statement).
In addition the flow language has the following extra 4 statements:
4) INVOKE (subroutine call).
5) SEQUENCE(compound statement)
6) EXIT
7) REPEAT(another iteration)
2) Trading Networks:
It is a service that acts as an interface between the internet and the Webmethod . It tracks down data between the multiple external  partners and an integration server.It performs  task such as
a)Authentication
b)Authorization
c)Document Identification
d)Logging  and activity monitoring.
It can be viewed as a generalized document router, but in reality it acts as simply another service running with the integration server. It can be invoked via a variety of mechanisms such as HTTP, FTP, SMTP, Web Services ,java client or via publish/subscribe.
3)Broker:
It acts as separate server which helps to pass data between the multiple instances of the integration Server. In it a service publishes a document to the broker and the broker delivers the document to all services that subscribe to the document. The  Broker performs routing of messages in a reliable and efficient manner.
4)JAVA Service:
Java is used to write for all the services except the running services. The cases  when java should not be used to write services are as follows :
1)The Webmethod developer does not  provide an IDE for java.
2)Java program cannot easily manipulate the pipeline which is used by integration server to pass data among services.
3)Java is harder to implement in comparision to the flow language.
VI)Webmethods  Installation:
Its products are not free and the cost goes up high to have it. The products  can be installed from the internet if you have an access to the appropriate license key.
An installer program WebmethodsInstaller651.exe is needed to access the installation files.
The installation choices are as follows:
a)We can deploy the products online on a single machine kust by opting out for the prompts interactively or via a script file.
b)We can download products to a image file which can be later used for the local deployments,by answering  prompts interactively or via a script file.
VII)Hardware Configuration requirements:
a)2-3 GHz CPU.
b)1-2 GB RAM
c)40-80 GB HDD.
d)Compatible with both Unix and Windows OS(Unix is favored for the production system but windows is better for an experimental purpose).
e)A Database(For example Oracle or SQL Server)
VIII)webMethods  Products :
It produces a lot of the products that focuses on
a)Enterprise Application Integration Market(EAI):
It is concerned with integrating disparate systems such as application servers (SAP, Seibel, Peoplesoft ),
Database management  systems(Oracle, SQL Server, DB2),mainframe and custom applications(J2EE).
b)Business-to-Business market(B2B):
It is concerned with enabling separate  companies to exchange electronic documents , such as purchase orders ,invoices, etc .
IX)Notes(Concepts to be known):
1)XML-RPC: It works by sending a HTTP request to a server implementing the protocol.
Client(software)------------------------->Server(That implements that protocol)
                                  (HTTP Call)
In this multiple input parameters can be passed to remote  method, but only one return value is returned.
2) WIDL (Web Interface Definition Language) is a 1997 standard for interactions between websites.
X)References are as follows:

basic Faqs on EAI (Webmethods) Coninued ....Coninued ....Coninued ....Coninued ....



1)Territories in webmethods?

Ans.

They holds group of "brokers" which will work as single functional unit.

2)Steps of deploying a service in webmethods?

Ans.

The steps are as follows:

a)define

b)build

c)map

d)deloy

 3)What are the steps used to deploy?

 Ans.

Use of finally block in exception handling in webmethods

 Lets assume we have a code where we are using open ssh and in the try block we are doing a sftp login .

 So in case of success or error either step we would have to do a logout . So to avoid code duplication both in end of try and catch block we can have a finally block (exit on done). Do a logout in this sequence.

 Also it can hold good when we do a manual connection to a DB and irrespective of success or failure we want  to close connection.

 Main(Exit on success)

|

|----Try(Exit on Failure)

|

|----Catch(Exit on Done)

Finally(Exit on Done)

4)What is the variable need to keep in the clearpipeline service preserve.

Ans.

Clear pipeline service is going to clear the pipeline information.If we did not specify "preserve" in the service all the pipeline information will be lost.If we keep variable in pipeline in "preserve" except the

variable specified in the preserve all the other information will be lost

Posted 15th February 2013 by Saurabh Sharma

View comments

Feb

15

Questions on EAI(webmethods)

1)In which case the transformers should not be used...?

2)In JMS can we publish a document to multiple brokers ? If Possible ,how can we achieve that ?

3)We have created a insert notification ,is there any way to process the document in the subscriber without publishing it .....?

4)In which case we are not advised to use Transformers...?

5)explain try and catch block briefly

6)Can we build loop step with in the branch in such a way that the interface is look like that branch

7)<transactiontype > sequence: Deposit loop <accno> xxxxxx sequence: current loop <accno> xxxxxxx sequence: savings loop <accno> can we achieve  the above senario.

8)what is meant by "Block time out" and "Expire time out " in jdbc adapter configuration

Ans.

Block timeout: refers to how much time the IS should wait

to get connection from connection pool before throwing

exception.

 Expire Timeout:refers to how much time the free connection

stay as it is before it expires.

9)Gate ways in webmethods?

Ans.

It allows to connect the territories called as gateways.It also allows to connect brokers of different Territories iscalled as gateway.We have one more type of gate ways like gateway service,which is usefull while developing TN documents which are of type FF.So by using Gateway services we can recognize TN Docs.

Troubling Scenarios in EAI(webmethods)

1)Currently, our application running on a Unix machine will generate XML file into a Unix Folder

The Unix Folder is &#39;exposed&#39; to our Window 2000 Server &#40;running webMethods I.S.&#41; via Simba

Our webMethods Integration Server &#40;running on Windows 2000 Server&#41; is
running as a Window Services using an LAN id/password not authorized to access the Unix Folder directly.


Suggested Solution:

1. Map the Unix Folder via Window Exploer &#40;using another user id / password&#41;
2. Create a Window Command File that move all the XML files from
the Unix Folder to local folder &#40;e.g. move &#42;.xml from folder A to
folder B&#41;
3. In my webmethods flow services, I will use a java service &#40;which
run RunTime.exec&#40;commandFile&#41; to invoke the command file to move the
XML files to a local folder, then list all the files in the local
folder, process each XML, convert to EDI &#40;X12 4010 204&#41;, post to TN,
then use webMethods Primary FTP delivery service to FTP to trading
partner

2)

1. If I use Process.waitFor&#40;commandFile&#41; to wait for the move to complete, webMethods just hang there and not moving any files
2. If I do not use Process.waitFor&#40;&#41;, each call the command file just move the 1st couples &#40;actually 5&#41; XML, which the command file should
move every XML files &#40;over 30&#43;&#41;
3. When I use the Primary FTP Delivery Service, webMethods uses the task id as the filename.edi. Anyways that I can do to change it.

Suggested Solution:

According to dk java docs:

&#34;Because some native platforms only provide limited buffer size for standard input and output streams, failure to promptly write the input stream or read the output stream of the subprocess may cause the subprocess to block, and even deadlock&#34;

I&#39;d suggest processing the input/output/error streams.

One other thing am sure you are aware of is that Runtime.exec forks off a new jvm with same jvm settings &#40;Xs/Xm&#41; as the parent. So if you have multiple threads doing these execs, you could unknowingly run out system resources very quickly.

basic Faqs on EAI (Webmethods) Coninued ....Coninued ....Coninued ....



1)When u use REPEATE,EXIT flow steps?

Ans.

REPEAT step is used when we want a particular step to be

repeated provided with some conditions.

 EXIT step is used to exit from any loop or from the whole

flow step

 2)How many interfaces u implimented so far ?

Ans.

As per your experience tell the count of interfaces which 

are developed by you. (ex: 20 or 30.....)

 3)By how many ways can we invoke a service?

Ans.

As per my knowledge , a service can be invoked in 3 ways :

1.Direct Invocation

2.Soap call

3.Publish and subscribe

4)How many kinds of log files in WebMethods and where are they exist???

1)Server Operations and errors that occur on Integration Server, such as starting of Integration Server

subsystems and loading of packages belonging to Integration Server or other webMethods products.

2)Session Sessions opened on Integration Server by clients and Developer users.

3)Error Stack trace information about all errors that occur in Integration Server, including exceptions thrown by

services.

4)Guaranteed delivery Guaranteed delivery transactions.

5)Security Administrative and operational actions on Integration Server, such as modifications to authorization

and authentication, and attempts to access Integration Server resources or perform runtime events.

6)Service Services that run in Integration Server.

7)Business process Business processes modeled in Designer that run on Integration Servers.

8)Task Tasks designed in Designer that run on My WebMethods Server. Tasks can be called from business

processes or can run as standalone tasks.

9)Integration process Integration processes made up of a chain of services that run on Integration Servers.

10)Document In doubt, failed, and retries exceeded documents, and documents that Broker clients publish or

subscribe to on Brokers.

By default, Integration Server stores most of the data in

flat files

5)What is the file (.jar) name that sharing between?

Ans.

Connector.jar, database.jar, jdeutil.jar, kernel.jar, log4j.jar, xalan.jar, xerces.jar, XTS.jar are the Jar files that you need to paste in the "<EnterpriseOne_install_dir>\system\classes\"

For enterpriseOne versions 8.9 and 8.10...

 6)WebMethods integrated with JD Edwards???

 Ans.

7)How we can catch exception error on run time mode using Flow language in WebMethods??? and how we can send error description as an output parameter????

Ans.

>  sequence ---------- Succeded

   |--sequence ------------- try block------

   |--sequence ------------- catchBlock-----

       |-- invoke getLastError service

8)How to connect jdbc connection in webmethods without server and with server step by step explain.

 Ans.

9)How to convert documentlist to document? If document list contain documents and documents contain strings field .how to convert?ple tell me any one.

 Ans.

10)What are client groups?

Ans.

client groups contains a list of clients and it configures which all documents its client could publish and subscribe to.

11)If i have a parent sequence with the property set- exit on success, n the try sequence block set to exit on failure, n the catch sequence block too set to failure, what is the result?

Ans.

In this case if any step in try block fails it will exit that and come to catch block and if any step in catch block

fails it will exit from the catch block  and skip rest of the flow steps.

12)what are extended settings?

Ans.

Extended settings are basically done for specifying values to some of the internal keys of Integration server.

Like we can specify java compiler at this setting and whenever we compile any java service IS will take this

compiler only for compiling the java code.




1)What are the new features in 8.0 compared to 7.1?

Ans.

The new features in 8.0 compared to 7.1 are as follows:

1)My webmethods

    webMethods ApplinX

    webMethods Business Events

    webMethods Business Rules

    webMethods communicate

    webMethods Cntent Service Platform

    webMethods Meadiator

    webMethods OneData

    webMethods ProcessEngine

    webMethods designer

    EntreX

Additionally,XPDL plug-in,BPMN functionality,SOAP 1.2 with Document-Literal only

 In webMethod 8.0 the developing part depends on Designer rather than Developer .And MyWebMethods server plays major role.Apart from that there is no difference.Its a small enhancement.
   

2)How You Can Delete Session Logs On IS?

Ans.

The steps are:
   
1)Go to Installationfolder/IntegrationServer/logs/

2)Here you will find logs in the name WMSESSION_.log

3)Delete this log files.

3)IS is thread or process ?

Ans.
   
   

4)What is indices in MAP flow step?

Ans.
   
   
  5)MAP Step Indices Is When You Have Array of data if you want to MAP One of the element in Array to the target Element then you can Use the indices

Ans.

   

6)Which value have to set for EnableAudit log while package replication?
   
 Ans.

7)What is difference between groups and ACL groups?

Ans.

Groups: Can be created of people having same  resposibilities. ex:Developer Group.

ACL: With the help of ACL you can grant access to a group or Individual.With ACLs you can grant access to few in a

group.Ex: A user need not belong to Developer group to develop new flows, but he need to belong to a group which is

assigned to Developer ACl.

   
8)How can try and catch block can be implemented using web methods developer ? Tell the steps to implement it?
   
   

Ans.

1) Build your flow service like this:

 Sequence{Main Block}[EXIT ON: SUCCESS]

    Sequence{Try Block}[EXIT ON: FAILURE]

    Sequence{catch Block}[EXIT ON: DONE]

2) 1)sequence(outer sequence-exit on success).

    2)sequence(Try block with service logic(inner sequence & child

           to outer sequence)-exit on failure). 

                      3)sequence(Catch block with any errors found in try block

           (inner sequence & child to outer sequence)-exit

            on done). 



4)Branch step with retrying the errors  

3)we can insert the finally block by

Sequence(Exit on success)       MAIN

  Sequence( Exit of failure)    TRY

  Sequence( Exit on done)       CATCH

Sequence(Exit on failure)       FINALLY

How you can implement finally block in flow services ?

1)

Build your flow service like this:



Sequence{Main Block}[EXIT ON: SUCCESS]

    Sequence{Try Block}[EXIT ON: FAILURE]

    Sequence{catch Block}[EXIT ON: DONE]

Sequence{finally Block}[EXIT ON: FAILURE]

2)

Sequence{Main Block}[EXIT ON: SUCCESS]

   Sequence{Try Block}[EXIT ON: FAILURE]

   Sequence{Catch Block}[EXIT ON: DONE]

Sequence{Finally Block}[EXIT ON: DONE]// executes all the statements obviously (catch block in flow service is similar to finally block in java)
   


 9)What is the main difference between webservies 6.5 and webservies 7.1.2

Ans.

Functionality available in broker admin and JMS admin to MWS under messaging and queue mgmt broker and territory

diagrams and included  SAP Adapter is used to generate document types from RFC

structure, Idoc structure, idoc DTD and xml schema .XSLT service is included to create, edit and execute XSLT’s

New JMS Trigger type that registers destinations on a JMS provide and specifies how to process messages it receives

from those destinations .Dependency manager is implemented for flat file schemas and

dictionaries to get informed about any changes and dependencies.

   
10)What is the difference between DISABLING a Polling Notification and SUSPENDING a Polling Notification?
   
 Ans.

11)Can U Explain JDBC Adapter Transaction types..?

Ans.

We have 3 types of JDBC Adapter Transactions.

 1)NO_TRANSACTION:The connection automatically commits the

operations.

 2)LOCAL_TRANSACTION:The connection uses local transactions. If we plan to use the connection with BatchInsertSQL or

BatchUpdateSQl adapter services,we must specify LOCAL_TRANSACTIONS types.

 If we are configuring a BasicNotification and using theexactly once notification and delete stored records options

we must configure the notification to use LOCAL_TRANSACTION type.

 3)XA_TRANSACTION:The connection uses XA transactions.

 When we are connecting to Teradata we use XA transaction.

   
can u explain abt Pub-Sub Architecture,where do u implemented this?
   

1) Point-to-point Architecture

2) Point-to-Multiple Architecture



Publisher publishes a document broker then the subscriber receive the document from broker.you should make document as publishable at publisher side.



Subscriber should subscribe to that particular document by creating a trigger. The trigger monitors that document. If a subscribed document got published then trigger invokes a service which associates with trigger to handle the document.



This is the general architecture of PUBLISH- SUBSCRIBE model

How to store logs in DB?

watt.server.auditStore=database

   

Check whether in your location and forecast for 7 days

Smart Weather PWA 🌦️ Smart Weather PWA 🔔 Alerts Search 📍 ...