Enfocus Switch Database module
automates the communication between a database application and Switch. The Database Module makes it possible for Switch to instantly access existing ODBC data sources to expedite automated processing and prevent labour-intensive re-keying of job information into multiple systems. The Database Module connects using system DSN resources and honors all database rights and privileges.
The Database Module adds a new Database connect element to the Switch toolset. This element can be used to dynamically read, write, create or delete records in the designated data sources anywhere in your workflow. The Module also enables any SQL query result to be used as a variable anywhere within your Switch workflow. You can use live job information to easily build dynamic SQL queries at any stage of your workflow. Query results can be used to make decisions for preflight, processing, delivery or archival based on existing job or customer information.
Scripting is no longer required, making it easier and faster for customers and integrators to build communication paths between Switch and an MIS or any ODBC-compliant database. This module also enables the visualisation of dynamic content from your database when using SwitchClient and PitStop Connect.What does Switch do?
Switch is a modular software solution that integrates with existing systems and drives third party applications to speed up job processing, reduce errors, and automate repetitive tasks. Automating tasks with Switch frees up your staff’s time so they can focus on new revenue-generating activities.
Switch eliminates the need for people to perform repetitive tasks associated with receiving and sorting files. It automatically downloads files from one or more FTP servers, receives them as email attachments, or handles hot folders. It then sorts files into different folders or transmits them to the appropriate destination in a flexible manner, so that each is ready for further processing or archiving.
All of this functionality is driven by an easy-to-use interface that depicts your workflow using visual elements to represent locations and processes. You can create flows by answering a few questions using the flow wizard, import ready-to-use flows from the Crossroads community website or build your own flows interactively with the wide range of communication and file handling tools available in Switch.
Using optional modules, Switch enables automation and integration of popular third party applications used in the creative, prepress and production industries as well as MIS, DAM, Web-to-Print and database systems. Switch is a robust and reliable solution—even in demanding environments—and scalability and intelligence can be enhanced with optional scripting, database and metadata modules.