Published on October 10, 2008
Author: FNian
Source: slideshare.net
Integration with Enterprise Database Systems Tim Sullivan activePDF, Inc.
The Examples Real problems we’ve encountered Solutions use real products The solution may not be the one they chose The names have been changed to protect the innocent
Real problems we’ve encountered
Solutions use real products
The solution may not be the one they chose
The names have been changed to protect the innocent
The Apparel Manufacturer
The Problem 2,500 page catalog Thousands of resellers 100 “area” managers Need to target sales No digital assets Reduce costs in delivery of materials
2,500 page catalog
Thousands of resellers
100 “area” managers
Need to target sales
No digital assets
Reduce costs in delivery of materials
How they did it manually Area manager would look through a copy of the catalog for merchandise to target Cut the pages and/or pieces out Paste them onto new pages Send to printer for reproduction into saddle stitched books Mail to all resellers in the area
Area manager would look through a copy of the catalog for merchandise to target
Cut the pages and/or pieces out
Paste them onto new pages
Send to printer for reproduction into saddle stitched books
Mail to all resellers in the area
What they wanted to do Let area manager search for merchandise to target Select via a web page the pieces they needed Assemble the pieces into a PDF booklet Add a table of contents with hyperlinks Email to all resellers
Let area manager search for merchandise to target
Select via a web page the pieces they needed
Assemble the pieces into a PDF booklet
Add a table of contents with hyperlinks
Email to all resellers
How they did it Scanned all catalog pages into TIFF images and saved into Oracle database as blobs Wrote web page that permitted searching and selection from the database Looped through once to retrieve part numbers, descriptions and determined page numbers
Scanned all catalog pages into TIFF images and saved into Oracle database as blobs
Wrote web page that permitted searching and selection from the database
Looped through once to retrieve part numbers, descriptions and determined page numbers
How they did it (pt 2) Used PDFlib (www.pdflib.com) to generate a PDF page with hyperlinks to pages Re-looped through dataset and for each part number, downloaded TIFF as blob and used PDFLib to import into the PDF Emailed the resulting PDF using ASPMail (free from www.dundas.com)
Used PDFlib (www.pdflib.com) to generate a PDF page with hyperlinks to pages
Re-looped through dataset and for each part number, downloaded TIFF as blob and used PDFLib to import into the PDF
Emailed the resulting PDF using ASPMail (free from www.dundas.com)
The Business Card Company
The Problem Handled customers with 10,000+ employees Unable to effectively handle different versions of digital assets Turnaround time was 2+ weeks Orders would get lost
Handled customers with 10,000+ employees
Unable to effectively handle different versions of digital assets
Turnaround time was 2+ weeks
Orders would get lost
How they did it manually Customer would call or fax in an order with the employee’s information Find the folder with the correct “template” Fill in the blanks Generate PostScript Send to the printer for output
Customer would call or fax in an order with the employee’s information
Find the folder with the correct “template”
Fill in the blanks
Generate PostScript
Send to the printer for output
What they wanted to do Permit versioning of logos and other digital assets Let customer enter employee information via web page Generate proof PDF After acceptance, send to printer in PDF format
Permit versioning of logos and other digital assets
Let customer enter employee information via web page
Generate proof PDF
After acceptance, send to printer in PDF format
How they did it Implemented Microsoft Visual SourceSafe as versioning tool Rendered digital assets as EPS files Wrote web page to accept employee input Wrote PostScript code to select font and print employee information Injected PostScript code to embed EPS assets (via “Run” command)
Implemented Microsoft Visual SourceSafe as versioning tool
Rendered digital assets as EPS files
Wrote web page to accept employee input
Wrote PostScript code to select font and print employee information
Injected PostScript code to embed EPS assets (via “Run” command)
How they did it (pt 2) Called JAWS PS to PDF Library to convert PostScript to PDF (www.jawspdf.com) When PDF was completed (checked via exclusive file access), sent to customer via email When customer accepts via web page, emailed PDF to printer Saved PDF onto file system for billing and audit purposes
Called JAWS PS to PDF Library to convert PostScript to PDF (www.jawspdf.com)
When PDF was completed (checked via exclusive file access), sent to customer via email
When customer accepts via web page, emailed PDF to printer
Saved PDF onto file system for billing and audit purposes
The Movie Studio
The Problem Many independent production companies on the lot Centralized scheduling of studio facilities Production companies need all information for scheduling on a daily basis to adjust (and fight for) their schedules Production assistants do not want to run reports
Many independent production companies on the lot
Centralized scheduling of studio facilities
Production companies need all information for scheduling on a daily basis to adjust (and fight for) their schedules
Production assistants do not want to run reports
How they did it manually Written as HTML report using Active Server Pages Manually ran report at 3AM using Internet Explorer Printed 1,000 page report to the high speed printer Sent for reproduction and reproduced as many copies as needed Distributed manually to each production office
Written as HTML report using Active Server Pages
Manually ran report at 3AM using Internet Explorer
Printed 1,000 page report to the high speed printer
Sent for reproduction and reproduced as many copies as needed
Distributed manually to each production office
What they wanted to do Automatically run the HTML report in the morning Convert to PDF Email to all production offices Permit searching and HTML report generation on a subset of the data (ad-hoc reporting)
Automatically run the HTML report in the morning
Convert to PDF
Email to all production offices
Permit searching and HTML report generation on a subset of the data (ad-hoc reporting)
How they did it Added page break tags to the HTML generation code Added front end interface for report generation Used activePDF WebGrabber (www.activepdf.com) to render HTML to PDF WebGrabber automatically emailed to distribution list End user Ctrl-F to find their production company and reviewed schedule
Added page break tags to the HTML generation code
Added front end interface for report generation
Used activePDF WebGrabber (www.activepdf.com) to render HTML to PDF
WebGrabber automatically emailed to distribution list
End user Ctrl-F to find their production company and reviewed schedule
The Ticket Seller
The Problem Millions of tickets sold annually Thousands of venues to print tickets for will call Non will-call tickets need to be mailed (and could get lost) Credit card companies require pickup to be same person that purchased tickets
Millions of tickets sold annually
Thousands of venues to print tickets for will call
Non will-call tickets need to be mailed (and could get lost)
Credit card companies require pickup to be same person that purchased tickets
How they did it manually If venue supports it, tickets and receipts printed locally after data transmitted If not, tickets and receipts must be printed remotely and then delivered Requires special ticket “printers” and data lines Have customer produce identification to match against ticket
If venue supports it, tickets and receipts printed locally after data transmitted
If not, tickets and receipts must be printed remotely and then delivered
Requires special ticket “printers” and data lines
Have customer produce identification to match against ticket
What they wanted to do Let customer select and purchase tickets online Generate tickets as a PDF Download data only to venue Let venue scan ticket (one scan, one ticket)
Let customer select and purchase tickets online
Generate tickets as a PDF
Download data only to venue
Let venue scan ticket (one scan, one ticket)
How they did it Let customer select and purchase ticket online as usual Use Adobe PDF Library to dynamically generate a “ticket” with a unique barcode Customer prints out PDF using free Acrobat Reader Data only is sent to venues that support technology Any customer holding the ticket is permitted entrance upon scan by venue personnel
Let customer select and purchase ticket online as usual
Use Adobe PDF Library to dynamically generate a “ticket” with a unique barcode
Customer prints out PDF using free Acrobat Reader
Data only is sent to venues that support technology
Any customer holding the ticket is permitted entrance upon scan by venue personnel
An example of a far more complex data storage system is a Database ... Data Integration, ... integration scenarios, access to the internal code ...
Read more
Services Development Integration Patterns - June 2004 System ... the database tier of an application ... corrupting the application's internal ...
Read more
The Integration Within: What is internal integration in SCM? ... information system ... Helecon Online Library database, ...
Read more
Bespoke business systems built ... system or database. Cloud applications to move internal ... database, integration between systems, ...
Read more
What is Database Integration? ... That’s why database integration was ... In database integration, the system is controlled by a separate ...
Read more
Integration with external information systems is an important ... internal enterprise systems may use ... The integration system's architecture ...
Read more
The Integration of Database Systems Tony Schaller Omran A. Bukhres Ahmed K. Elmagarmid Purdue University, ake@cs.purdue.edu ... 3 Aspects of Database ...
Read more
... you can build scalable web and mobile front-ends in the cloud and seamlessly connect them to internal ... With Microsoft Integration, ... Database ...
Read more
Aptean, a global leader in ... they are built on a single comprehensive database to share information across the enterprise. ERP system integration, on the ...
Read more
Add a comment