2845 - 忘掉 ODBC 吧！这是全新的 DB2 连接器.pdf

1、Orlando,FLOctober 69IBM TechXchange 2025Session 2845 Jesse GorzinskiSenior Business Architect,IBMForget ODBC!Heres a New Db2 ConnectorAgenda010203WhatWhyHowIBM TechXchange|2025 IBM Corporation3What is Mapepire?https:/mapepire-ibmi.github.io/45Mapepire Origin Story.January 2020VSCode Code for IBM i e

2、xtension includes basic Db2 supportFebruary 2022Work begins on Server component to power Db2 features in VSCodeMarch2022First release of VSCode Db2 for i extensionJuly 2023VSCode Db2 for i extension publishes v0.3.0,the first release leveraging server component(v0.3.0)August 2024Mapepire is born!6Ma

3、pepire ComponentsServer ComponentSDK architecturePythonJavaTypeScriptC#PHPFUTURE7but what IS IT?A set of clients that talk to itA new IBM i server job that clients talk to8Truth In AdvertisingAlready being used in production!Technology Preview means Technology PreviewAgenda What?Why?How?9Agenda01020

4、3WhatWhyHowIBM TechXchange|2025 IBM Corporation11Core tenetsPortabilityEncryptionPerformanceConsistency13Single port?Big deal!TCP distance to first database operationJDBC/ODBCMapepirePort MapperSignon ServerDatabase ServerMapepire14Sample JDBC program1511 Distinct TCP Flows!16How to encrypt data wit

5、h _DBC1.Log into DCM2.Create a local certificate authority(CA)store3.Create a local CA certificate4.Record the value of the autocreated CA label5.Create the*SYSTEM certificate store(if needed)6.Create a new server certificate7.Sign the server certificate with your local CA8.Assign new server certifi

6、cate to host server applications9.Restart Host Servers10.On client,download the servers certificate authority to a local truststore(or configure TLS to ignore completely)17How to encrypt data with MapepireStep 1Use MapepireStep 2Go to bed18What does TLS provide?EncryptionData isnt sent in the clearA