Sign in

Data Source - MySQL Database

MySQL Database

MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses. MySQL was owned and sponsored by the Swedish company MySQL AB, which was bought by Sun Microsystems (now Oracle Corporation).

MySQL is a component of the LAMP web application software stack (and others), which is an acronym for Linux, Apache, MySQL,Perl/PHP/Python. MySQL is used by many database-driven web applications.

To create a connection to the MySQL Database Data Source, right-click on the Data Sources group, click “Oracle”, and then select “MySQL Database”.

DataSources-ConnectMySQLDB.png

To successfully retrieve data from a MySQL Database data source, the following properties need to be set.

DataSources-MySQLDBProperties.png

  • Name (String)
 Name to identify the data source.
  • Server (String)
 Location of the Oracle Database (Server Name or IP Address).
  • Database (String)
 Name of the Database to connect to.
  • Username (String)
 MySQL authentication username. If left blank, Windows authentication will be used.
  • Password (String)
 MySQL authentication password. If left blank, Windows authentication will be used.
  • Timeout (Int)
 Timeout for SQL queries. The default is 15 seconds.
  • Definition (File location. JSON formatted file)
 Definition settings to create a custom namespace as per your database schema.
  • Maximum Concurrent (Int)
 Maximum pooling count size for the MySQL connection. The default is 100.
   
Note: The MySQL data source connector also supports the use of a custom namespace by means of a definition file. Also, refer to the Microsoft SQL Data Source for sample queries.