How can I access external databases like SQL Server, Oracle, Sybase or other?

How can I access external databases like SQL Server, Oracle, Sybase or other?

  

To access SQL Server and Oracle databases, you can make use of two add-ons available in the Agile Platform:

 

  • Microsoft SQL Server Integration Services
  • Wizard-based discovery and introspection of existing SQL Server database tables to make them available to use in your new applications. You can then combine local and external data sources using visual models without requiring complex integration projects, with out-off-the-box access optimizations, and performance and health monitoring.

  • Oracle Database Integration Services
  • Wizard-based discovery and introspection of existing Oracle database tables to make them available to use in your new applications. You can then combine local and external data sources using visual models without requiring complex integration projects, with out-off-the-box access optimizations, and performance and health monitoring.

 

To access other databases, such as DB2, Sybase, or other, you need to create a custom integration component. To accomplish this purpose, the Agile Platform offers you Integration Studio which is a tool that works back-to-back with Microsoft Visual Studio and Eclipse to include .NET or Java code to build custom integration components. Once deployed, these custom components become available as new visual building-blocks to extend Service Studio's functionality.