The OpenText Integration Center offers a data and content integration platform that unifies information silos that cross application boundaries, consolidating and transforming data and content throughout the entire information ecosystem.
Which features does Open Text Integration Center support?
If you want to know how Open Text Integration Center (OTIC) scores on different key selection criteria and exactly which features it provides. We did all the work for you. Software vendors will often tell you only the strengths of their solution(s). In our vendor neutral survey, all the features are revealed, including the weak points. Why buy our 100% vendor neutral survey?
Information from the ETL vendor
Ease of Use
Can all the product’s functionality be generated from the GUI or is it sometimes necessary to write code and/or procedures and/or macros etc. Depending on the level of complexity you desire, most functions can be accomplished through the GUI however a scripting window is available for more complex scripting
Does the product automatically suggest corrections to syntax or field name errors? OTIC designer uses two general types of impact analyses, immediate impact and postponed impact modes, to handle changes to the properties of an object. Also it’s possible to verify the syntax of the expression by clicking the Check Expression button. If the syntax is invalid, an error message appear
Real-time and batch
Can the real-time and batch modules be bought separately? The Integration Center offers an integrated set of components that allows to design, deploy and maintain data transformation and exchange processes in one package.
If non-structured data can be read – which types? OTIC can read most non-structured data generated in media like email messages, PowerPoint presentations, Word documents, collaborative BI software and instant messages. OTIC can also read Non-textual unstructured data is generated in media like JPEG images, MP3 audio files and Flash video files.
Is it possible to call (external) analytical functions e.g. forecasting, basket analysis, regression from within the load process? OTIC has a complete set of transformation functions. OTIC offers roughly 150 generic functions that can be used to build complex expressions or custom functions. These functions can be processed inside the OTIC Engine or Linux, but they can also be automatically translated in native SQL functions in order to execute them on the database engine side.
“Callable functions also available to other products”
Rick van der Linden, senior analyst and author of the ETL Tools & Data Integration Survey said about Open Text Integration Center: “Their architecture is quite open; callable functions are also available to other products or programs (from a different vendor). This can be implemented using standard API or command line interface calls to the underlying architecture.” Find out more and order now the ETL Tools & Data Integration Survey 2018.
100% vendor independent research
In the ETL Tools & Data Integration Survey 2018 you’ll find the list of ETL tools in the market, including for each ETL solution an expert review, many comparison graphs and a comparison matrix with all the features. And a thorough 100% vendor independent evaluation of Open Text Integration Center and all the major ETL platforms.