With Transconnect, you can integrate your applications, systems and data seamlessly and centrally into your existing IT infrastructure. Secure your competitive advantage as a digital champion.

Transconnect is a proprietary development of SQL Projekt AG and is characterized by its unique selling point of creating a central data hub for data from the TOP floor and store floor in the value chain in real time. Transconnect supports both established and individually developed interfaces and enables the seamless conversion of data while simultaneously operating these interfaces. SQL Projekt AG has extensive expertise in consulting, implementation and the sustainable operation of digitization projects to support our customers in their project plans.

The principle of Transconnect

Transconnect is a modern integration platform that enables organizations to efficiently connect different systems, data sources and applications. It uses advanced artificial intelligence and machine learning to optimize data integration and processing. Key features include:

• Automation: Transconnect uses AI and machine learning to automate integration tasks alongside the rule-based approach. For example, it can recognize patterns in data and adapt processes accordingly to make the integration process more efficient.

• Data processing: The platform enables the seamless processing of structured and unstructured data from various sources from the TOP floor such as ERP/CRM systems and SHOP floor systems such as IoT platform / sensors etc.

• Data mapping and transformation: Transconnect provides tools to transform and customize data to ensure that it is consistent in different formats and structures and meets the requirements of the target systems.

• Real-time integration: Transconnect is a modern integration platform capable of processing and transferring data in real time to provide up-to-date information and analysis.

• Connectors and adapters: They offer a variety of predefined connectors and adapters for common applications and systems (TOP-Floor & Shop-Floor) to facilitate integration.

• Data quality management: The platform supports the monitoring and improvement of data quality by detecting and correcting duplicates, missing or inconsistent data.

• Security and compliance: It ensures that sensitive data is protected during the integration process and that the applicable data protection regulations and compliance requirements are adhered to.

• Scalability: The platform can be adapted to the company's requirements and easily expanded to keep pace with growing data volumes and integration requirements.

• Monitoring and reporting: It provides tools to monitor the integration process and generate reports on the status and performance of the integration.

 Transconnect is of great importance to organizations that need to connect a variety of applications and data sources to gain valuable insights, ensure effective business processes and accelerate process automation. Transconnect helps to optimize the integration process and improve the company's responsiveness.

Connectors

In relation to a Transconnect Business Integration Platform, the term "connector" refers to a software component that is used to connect and integrate different applications, systems or data sources. These connectors are interfaces that enable data and information to be exchanged seamlessly between different software applications or systems.

A connector plays a crucial role as it ensures interoperability between different technologies. This is particularly important in companies that use a variety of software applications and systems to support different business processes. By using connectors, companies can ensure that data flows smoothly between their applications and systems without the need for manual intervention.

Typically, business integration platforms offer a collection of predefined connectors for common applications and systems, such as CRM systems, ERP systems, databases, cloud services and more. These predefined connectors make integration much easier and enable companies to link different technologies together to optimize and automate their business processes. Transconnect already supplies over 900 adaptors and connectors. A powerful connector framework is also available, which can be used to implement new and customer-specific adapters very efficiently.

Fewer interfaces, more structure: Transconnect creates order

With its innovative architecture, Transconnect creates the basis for the realization of company-wide integration scenarios. Standardized & field-tested transformation standards and the universal adapter concept reduce the number of interfaces, ensure standardization of the overall architecture and mastery of the existing technology mix. Transconnect supports the integration of databases, applications and business processes. The cumulative experience of over 25 years of integration experience, which the experts at SQL Projekt AG have gained in the course of various projects, has been incorporated into the development of the solution.

Transconnect gives you an overview of your systems

As a central server platform, our solution ensures that different systems work together in real time or according to individual process requirements. Standardized open technologies based on XML ensure seamless data and information flows - both within the company and in communication with business partners.

This creates homogeneous IT landscapes that save costs in two ways: Firstly, it opens up new options for optimizing business processes. On the other hand, the traditionally high integration costs, which Gartner estimates at 30 to 40 percent of total costs, are reduced. A rapid return on investment is guaranteed. With Transconnect, you can implement integration scenarios quickly, cost-effectively and without any negative impact on system stability.

Guarantee 100% data security

Users interact with the system via an authenticated session. The login takes place via an HTTPS connection between the browser and the web interface or an SSL-encrypted RMI connection to the Transconnect server.

The integration solution authenticates users to the domain (or another LDAP-based directory service) and determines all group/role affiliations in the domain and all local groups or roles from the connected information sources.

In a Microsoft Windows domain, the integration solution is operated in single sign-on mode by default (via Kerberos, NTLM or CAS). Additional users can be created and roles assigned via the Management Center (Transconnect Manager) (e.g. administrator role). In the data source configuration, additional access rights can be created based on roles in addition to the data source's own access rights.

Unique selling points of Transconnect

Our Transconnect solution has several unique selling points that contribute to the realization of your goals. These are briefly described below.

Unique technical selling points:

• Modeling instead of programming: Instead of conventional programming, we rely on efficient modeling.

• Integration of top-floor and shop-floor systems in one platform: Our solution enables the seamless connection of top-floor and shop-floor systems in one central platform.

• Synchronous and asynchronous processing in real-time situations: We offer both synchronous and asynchronous processing options to ensure maximum performance even in real-time situations.

• Unifit! Connection of all IT and OT systems: Our system offers a comprehensive connection of all IT and OT systems and thus guarantees an integrated solution.

• 100% traceability and data transaction security: We guarantee complete traceability and maximum data transaction security.

• No 3rd. Party connectors (more than 100 free standard connectors): Our solution does not use 3rd party connectors and instead offers more than 100 free standard connectors.

Soft factors:

• Flexibly adaptable: Our solution can be flexibly adapted to individual requirements.

• Powerful functionality: It impresses with its powerful and versatile functionality.

• Multi-client capable: The solution is multi-client capable and enables efficient use by different user groups.

• Configuration can be changed at runtime: Changes to the configuration can be made during operation.

• Simple administration: Administration is simple and straightforward.

• Sophisticated modeling: Sophisticated modeling ensures optimum structure and efficiency.

• Available in various expansion stages: The solution is available in various expansion stages to meet different requirements.

• Simple and transparent pricing model: Our pricing model is transparent and easy to understand.

• German manufacturer (data protection etc.): As a German manufacturer, we place particular emphasis on data protection and other relevant aspects.

• Support for over 900 file formats: Our solution supports an impressive range of over 900 file formats.

Transconnect is a highly modern business integration product that has matured in practice over 25 years. We have taken into account the wishes and requirements of our customers to create a modern product. Our proven standard product offers a wide range of functions that have already been successful in many projects. Your project requirements are therefore already largely covered. Trust in our experience and use Transconnect to optimize your integration.