Introduction
SAP Integration Suite’s Java Database Connectivity (JDBC) adapter has been a powerful tool for connecting to various cloud and on-premise databases. The supported databases include DB2, Microsoft SQL Server, Oracle, PostgreSQL, SAP HANA, and SAP ASE Service. Now, the JDBC adapter has added support for MariaDB, further expanding its capabilities.
MariaDB Support
The JDBC adapter now enables connectivity to MariaDB Cloud, allowing seamless integration with SAP Integration Suite. Additionally, it supports connectivity to MariaDB on-premise databases, but with a specific requirement: the integration scenarios must be processed in an Edge Integration Cell runtime location.
Note that stored procedure execution is not supported for this database.
On-Premise Connectivity Considerations
If you intend to establish a connection with an on-premise MariaDB database, it’s important to note that you must have EIC activated. Without EIC, you won’t be able to connect to the on-premise MariaDB via the cloud connector.
Getting Started
Before you can start connecting to MariaDB using the JDBC adapter, there are a few prerequisites to take care of:
Upload the necessary driversAdd the Data Source
For detailed instructions on these steps, refer to the documentation on Configure JDBC Drivers and Managing JDBC Data Sources.
MariaDB Database Details
Here are the key details for connecting to MariaDB using the JDBC adapter:
– Database Provider: MariaDB plc
– Infrastructure: On-Premise (via EIC only) and Cloud
– SAP BTP Environment: Cloud Foundry
– JDBC URL Pattern: `jdbc:mariadb://<host>:<port>/<database_name>:property1=value1;property2=value2;…`
– JDBC URL Example: `jdbc:mariadb://mymariadb:1234/TEST_1`
Conclusion
The addition of MariaDB support to SAP Integration Suite’s JDBC adapter opens up new possibilities for integrating with this popular database. Whether you’re using MariaDB Cloud or On-Premise (via EIC), you can now leverage the power of SAP Integration Suite to streamline your data integration processes.
Remember, while this adapter enables connectivity between Cloud Integration and a remote database system, SAP cannot provide advice on configuring the external system or offer support related to it.
Happy integrating!
IntroductionSAP Integration Suite’s Java Database Connectivity (JDBC) adapter has been a powerful tool for connecting to various cloud and on-premise databases. The supported databases include DB2, Microsoft SQL Server, Oracle, PostgreSQL, SAP HANA, and SAP ASE Service. Now, the JDBC adapter has added support for MariaDB, further expanding its capabilities.MariaDB SupportThe JDBC adapter now enables connectivity to MariaDB Cloud, allowing seamless integration with SAP Integration Suite. Additionally, it supports connectivity to MariaDB on-premise databases, but with a specific requirement: the integration scenarios must be processed in an Edge Integration Cell runtime location.Note that stored procedure execution is not supported for this database.On-Premise Connectivity ConsiderationsIf you intend to establish a connection with an on-premise MariaDB database, it’s important to note that you must have EIC activated. Without EIC, you won’t be able to connect to the on-premise MariaDB via the cloud connector.Getting StartedBefore you can start connecting to MariaDB using the JDBC adapter, there are a few prerequisites to take care of:Upload the necessary driversAdd the Data SourceFor detailed instructions on these steps, refer to the documentation on Configure JDBC Drivers and Managing JDBC Data Sources.MariaDB Database DetailsHere are the key details for connecting to MariaDB using the JDBC adapter:- Database Provider: MariaDB plc- Infrastructure: On-Premise (via EIC only) and Cloud- SAP BTP Environment: Cloud Foundry- JDBC URL Pattern: `jdbc:mariadb://<host>:<port>/<database_name>:property1=value1;property2=value2;…`- JDBC URL Example: `jdbc:mariadb://mymariadb:1234/TEST_1`ConclusionThe addition of MariaDB support to SAP Integration Suite’s JDBC adapter opens up new possibilities for integrating with this popular database. Whether you’re using MariaDB Cloud or On-Premise (via EIC), you can now leverage the power of SAP Integration Suite to streamline your data integration processes.Remember, while this adapter enables connectivity between Cloud Integration and a remote database system, SAP cannot provide advice on configuring the external system or offer support related to it.Happy integrating! Read More Technology Blogs by SAP articles
#SAP
#SAPTechnologyblog
