GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG...

18
GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober 2017 Helmut Bernhard (comForte EMEA Senior Solutions Architect)

Transcript of GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG...

Page 1: GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober

GTUG presentationDynamische Schnittstellenkommunikation mit CSL

JSON/REST und Escort SQL 19. Oktober 2017

Helmut Bernhard (comForte EMEA Senior Solutions Architect)

Page 2: GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober

2

Can you remember this slide (6 months ago)?

> The telecommunications industry (1996)> The banking industry (2010)> Encore - The banking industry (2012)> From M2M to IoT (2014)

Page 3: GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober

3

The „Incremental Software Architecture“ is needed!ComForte, customers, implementation partners and the solution partner did:

> extensive architecture discovery and analysis to generate an incremental software architecture

> Architecture decomposition (structural, behavioural and volatile attributes)

> Architecture verification (design substantiation, architecture stress-testing and capacity planning)

> To allow an incremental software Architecture following the

> EA/Microservices principles and> Satisfies the management & business levels down to the

technological & system levels

> All needed to overcome lack of interoperability, performance degradation, over expended system federation, low scalability, low reuse and too tight coupling

Page 4: GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober

4

What did change the last 6 months?

> The caravan moves on…. Our new customer projects are moving from:

> SOAP JSON/REST> SOAP & .net and stay there (for heavy weighted transactions)> Internal cloud (Azure)> Homebanking Open Banking API> Regulated Banking Deregulated Banking (e.g. PSD2 Banking API

(PISP/AISP/XS2A)> Isolated reservation systems JSON/REST enabled> Rigid Internal systems partner access via JSON/REST> Test environments Persistent Application including NonStop SQL

MP/MX> Monolithic apps Scalable solutions> Simple GUIs Responsive design (HTML5)> Legacy Server Mixed client/server setups

Page 5: GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober

5

CSL - Client Server Link - base architecture description> The CSL Manager is a NonStop process pair which oversees the TCP

listener processes (i.e., starts, stops and monitors the CSL TCPs and is able to restart the TCP listener in its backup CPU).

> The TCP listener process provides the communication layer of CSL Base through which access to applications on NonStop is gained. The CSL TCP listens on a TCP/IP port assigned to the CSL TCP for incoming connection requests coming from remote clients. Once a connection request has arrived it is forwarded to a CSL Executor process which establishes the TCP/IP session with the remote client. Multiple TCPs can be started (listening to multiple ports) and each TCP can have executors running in every CPU.

> The REST wrapper handles the mapping from JSON to the message expected by the application; it is a Pathway server and inherits all the scalability and availability provided by Pathway.

> CSL Studio is a development tool which enables rapid deployment of NonStop applications as a REST Web service by consuming the DDL of the application and producing client consumable documents and by deploying a REST wrapper to the NonStop to act as a gateway between the NonStop and the remote facility.

Page 6: GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober

6

CSL - Client Server Link - REST Server overviewCSL REST Server on NonStop means, that there is NO application code changefor the Application Server/Pathway environment and CSL protects customer’s investment in NonStop application logic

> For development you can use for example the Pathway CSL Echo server and on the client side our customers using the OpenSource Tool SoapUI (has also REST functionality)

Page 7: GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober

7

CSL - Client Server Link - REST Server – Advanced Design Possibilities> Adding a specific REST-API

> This has the following advantages> Give the REST API a distinct version id and its subordinate resources distinct names instead of using

default names> Offer the HTTP GET verb in addition to the POST verb for accessing a resource> Specify HTTP query parameters being populated at runtime within the corresponding request message to

the back-end server

> Using message views> One of the main reasons is:

> Hiding data items from the REST client and also allowing these hidden items to contain correct values at runtime is supported by CSL REST using message views and message defaulting

> Using TMF> If the interactions with a back-end server initiated by a REST client must be monitored using TMF then the

following options are available with CSL REST: > The control over the TMF transactions (i.e. begin, resume and terminate TMF transactions) is given to the

REST client> The TMF transaction is controlled by the CSL REST wrapper outside the control of the REST client.

Page 8: GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober

8

CSL - Client Server Link - REST Client Lite overview> With CSL REST Client lite an easy way to “convert” the NonStop environment to

a REST client is offered, consisting of:> HTTP Client Proxy > API library and a > JSON DOM library (supports C/C++ clients)

> JSON content is produced and processed by customer (via JSON DOM Lib functions). > The interaction with the remote Server is done via the CSL REST Client Proxy (Pathway Server Class) and

with the help of the GET and POST functions, offered from the http API

> Cloud connections (e.g. Microsoft Azure) are supported

Today1 2 3 4 5

6 7 8 9 10

11

121

314

15

16

17

18

192

021

22

23

24

25

262

728

29

30

31

Page 9: GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober

9

Full blown CSL NonStop REST Client > A full blown CSL NonStop REST Client is currently in beta

and will support - besides WSDL - the Swagger/OpenAPIformat for service contracts

> Content support for JSON and XML > Full integration in CSL Studio (supports MS VS. and

Eclipse)> Furthermore COBOL applications are also supported

besides C/C++> This is the foundation for upcoming IoT, PSD2 and Open

Banking API’s, i.e. to design and implement the respective scenarios (e.g. EU-PSD2 AISP/PISP/XS2A) based on recommendations like the upcoming “The Berlin Group implementation framework regarding PSD2” and over IoT frameworks like OPC UA, ETSI IoT, etc.

Page 10: GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober

10

Example Open Banking API "balances": [{

"amount": "123.60","type": "ITAV"

},{

"amount": "111.50","type": "ITBD"

}],"links": [

{"href": "/v1/accounts/FI6593857450293470-EUR","rel": "details"

},{

"href": "/v1/accounts/FI4711857450293470-EUR/transactions","rel": "transactions"

}]

},{"id": "FI7473834510057469-EUR","account": {

"identification": {"country": "FI","iban": "FI47123834510057469"

},"currency": "EUR","owner": {

"name": "Firm OY"

Response Body Parameters:

{"groupHeader": {

"creationDateTime": "2017-09-29T06:44:00Z","httpCode": 200,"messageIdentification": "wGjKCyetftk"

},"response": {

"accounts": [{"id": "FI6593857450293470-EUR","account": {

"identification": {"country": "FI","iban": "FI65471457450293470"

},"currency": "EUR","owner": {

"name": "Oy cccompany AB"},"product": "SHEKKITILI","type": "CACC"

},

Page 11: GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober

11

Example Open Banking API (cont)

{ ]}

},"response": {

"account": {"id": "FI6593857450293470-EUR","account": {"identification": {

"country": "FI","iban": "FI6593857450293470"

},"currency": "EUR"

},"links": [{

"href": "/v1/accounts/FI6593857450293470-EUR","rel": "details"

},{

"href": "/v1/accounts/FI6593857450293470-EUR/transactions","rel": "transactions"

> Example balance enquiry},

"continuationKey": "0320160823999999--2","transactions": [

{"id": "0220161108000001","entryReference": "0220161108000001","amount": {

"currency": "EUR","value": "100.00"

},"bookingDate": {

"date": "2017-06-12"},"creditDebitIndicator": "CRDT","entryDetails": {

"transactionDetails": {"relatedParties": {"debtor": {

"name": "Matti xxxxäläinen"}

}}

},"valueDate": {

"date": "2017-06-12"}

},{

Page 12: GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober

12

Escort SQL – Overview> Escort SQL is the fastest, lowest cost and lowest risk

method for converting applications and data from Enscribe to SQL.

> No need to rewrite your programs to convert to SQL. Convert to SQL in weeks, not months and years

> Use Escort SQL to shorten legacy system development times. Example: Change a field definition from YYMMDD to YYYYMMDD and recompile only the programs that need the new definition

> Deploy third party ODBC and JDBC tools, such as Microsoft Tools, open source tools and hundreds of other commercially available products.

> An Escort SQL migration converts the legacy system in small, manageable and quick increments. Migrate the database one file at a time to SQL, with no reprogramming. Migrate the application one program at a time to native SQL.

Page 13: GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober

13

Step One – DB conversion

> In many cases, today's Enscribe files were not originally designed as the "clean", normalized databases that we all would prefer

> Escort SQL gives you a second chance to change all those things you don't like about your existing files in the process of converting them to SQL. Expand or eliminate fields and reformat compressed data (i.e. an example is dates with current YYMMDD or other formats being expanded into fully millennium compliant dates)

Page 14: GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober

14

Step Two – DB loading> Our high-speed parallel database loader loads the existing Enscribe data into the

new SQL tables very efficiently, using all the rules you have supplied about how the data is to be transformed

> Once your production data is loaded into the tables, these same transformation routines will be used at runtime to successfully READ and WRITE the data

Page 15: GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober

15

Step Three - Enscribe/SQL Emulation

> When an Enscribe programs requests to open a file, comForte Escort SQL will detect when your programs attempt an Enscribe operation against a SQL table. When that happens, comForte Escort SQL kicks into action. From that point on, comForte Escort SQL will do all I/O to that file on behalf of that program

> As mentioned before, the program can't tell that the file(s) have been changed to SQL. This means you can change one file to SQL or change them all.

Page 16: GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober

16

Why comForte as a partner?> 30+ years experience in HP NonStop server

market place> the largest HPE Nonstop ISV

> Growing Solution Set through> In-house Development> Acquisition

> Customers work with comForte because they need to

> Lower Cost of Operations of HP Nonstop Applications> Lower Operational Risk by enhancing data protection and

overall security> Support New Business Initiatives driving new application

developments> Better integrate HP Nonstop within Enterprise IT> “Understand” the strategic importance of HP Nonstop in

their Enterprise

Page 17: GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober

17

comForte - contacts

Andreas Lutz

Senior Key Account Manager

Alte Ruppiner Allee 7416816 Neuruppin, Germany

Tel: +49-176-24481915

Email: [email protected]

Helmut Bernhard

Senior Solutions Architect

Abraham Lincoln Str. 2265189 Wiesbaden, Germany

Tel.: +49-171-6949285

Email: [email protected]

Page 18: GTUG presentation Dynamische Schnittstellenkommunikation mit CSL … - Dynam… · GTUG presentation Dynamische Schnittstellenkommunikation mit CSL JSON/REST und Escort SQL 19. Oktober