Database Deployment Automation for IMS Interfaces

Slide Note
Embed
Share

Automate your database deployments for IMS interfaces within the scope of various systems and interfaces including Wells Fargo, SUNTAX, transport scanners, KODAK, Fujitsu, FDLE, CAMS, DBPR, and more. This includes interfaces to GTA, CAMS, Wells Fargo, Florida Department of Law Enforcement (FDLE), and Department of Business Professional Regulations (DBPR), enabling seamless file uploads, deposits, image retrievals, and application validations.


Uploaded on Sep 12, 2024 | 0 Views


Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

E N D

Presentation Transcript


  1. Automate Your Database Deployments IMS Interfaces

  2. SCOPE: IMS SYSTEM BOUNDARY Wells Fargo SUNTAX TRANSPORT (Scanner) OPEX 2200 (Scanner) OPEX 3690 (Scanner) KODAK (Scanner) REMOTE Fujitsu (Scanner) FDLE CAMS DBPR DFS IMS CAMS Pitney Bowes Genetic Testing EServices BSWA CIT DOR

  3. IMS SYSTEM INTERFACES to GTA SUNTAX RPS 1 Cross reference to IMS_interfaces.xls Cross reference to IMS_interfaces.xls SOCIAL DA 2 1 Account Validation 96 2 Bank Routing Validation IMS UPLOAD 3 3 SUNTAX payment file upload 4 SUNTAX Call back for payment file upload 4 ICL/Non ICL 6 5 DPS SAP UPLOAD DB 6 DPS FILE LOAD VALIDATION CALLBACK GTA SUNTAX -SAP 7 DR1_DR5 Registration File load 8 5 8 Registration Application file load validation SAP UPLOAD DPS 96 IMS Image Retrieval DFDINIT DOR 7 Opcon

  4. IMS SYSTEM INTERFACES to CAMS Cross reference to IMS_interfaces.xls Cross reference to IMS_interfaces.xls 97 21 SAPExport Cor FTP DPS File 22 22 CSP DSP File upload Callback DB 97 CAMS IMS Image Retrieval IMS CAMS SAP Opcon SapExportCor 21 DPS DOR

  5. IMS SYSTEM INTERFACES to Wells Fargo Manually deposit Cross reference to IMS_interfaces.xls Cross reference to IMS_interfaces.xls Money Deposit 33 Image Cash Letter (ICL) File deposit Wells Fargo Desktop Scanner 34 Image Cash Letter (ICL) File deposit Ack IMS 33 ICL Deposits DB Opcon 34 Wells Fargo DOR

  6. IMS SYSTEM INTERFACES to Florida Department of Law Enforcement (FDLE) IMS UPLOAD Cross reference to IMS_interfaces.xls Cross reference to IMS_interfaces.xls 41 FDLE File Upload DB 41 FDLE Deposit Information File FDLE has access to IMS System through SunRise Application to review deposit and report for the day. IMS FDLE DOR

  7. IMS SYSTEM INTERFACES to Florida Department of Business Professional Regulations(DBPR) IMS UPLOAD Cross reference to IMS_interfaces.xls Cross reference to IMS_interfaces.xls 42 DBPR File Upload DB 42 DBPR Deposit Information File DBPR has access to IMS System through SunRise Application to review deposit and report for the day. IMS DBPR DOR

  8. IMS SYSTEM INTERFACES to Department of Financial services (DFS) Cross reference to IMS_interfaces.xls Cross reference to IMS_interfaces.xls Miscellaneous Tax Server 52 1 report per day which has records with Headers (H71 + H72 + H76 + H77 + H80) 56 53 1 report per day records with H60 Header 54 Input file from GTA SUNTAX with H73 records 55 Input file from GTA SUNTAX with non H73 records 53 56 Input file for Miscellaneous tax server 54 DFS Deposit Information File GTA SUNTAX 55 52 DFS IMS

  9. IMS SYSTEM INTERFACES to BSWA Cross reference to IMS_interfaces.xls Cross reference to IMS_interfaces.xls 81 BSWA : SUNTAX-SAP pulls the insurance premiums from the company and create zip ed object (consists of pdfs and xml). 82 82 SUNTAX-SAP pushes the zip objects into a folder for IMS processing. SUNTAX -SAP DB 83 IMS processes the zip object and saves the images. Creates DPS (metadata of the images) and drops it into a folder. SUNTAX-SAP pulls these metadata periodically. 83 IMS DOR 81 Image Archive BSWA (https://www.bswa.net)

Related