Instead of having to define each data source in each data service's definition, the best practice is to define the data source in the WSO2 EI console and refer it to your data service definition. This allows you to easily control and manage your data source configurations within a single point for all data services.
WSO2 EI allows you to create the following data sources, and its data services support any source of data, such as--RDBMS, CSV, Excel, ODS, Cassandra, Google Spreadsheets, RDF, and any web page. When used with RDBMS, it supports any database with a JDBC driver.
RDBMS data sources are the most commonly used in most scenarios, so we will use this kind of data source to illustrate the process; in particular, we are using a MySQL database version 5.7.
We are using MySQL Community Server edition, as its vendor affirm; the edition is also known...