--- schema_version: "1" id: 7c91a0484ca6c2278f7462e2480f046e1b5a1f5f0359d8844b81ad7a23b6a3a5 title: Using Anypoint Studio to Configure Database Connector 1.15 collection: mulesoft version: current locale: en-us portal_url: https://docs.salesforce.com/mulesoft/current/en-us/db-connector/1.15/database-connector-studio.md canonical_url: https://docs.mulesoft.com/db-connector/1.15/database-connector-studio source_site: docs.mulesoft.com content_type: documentation content_hash: 25cac3649fc0494bcb3253378fdbc25425fca1b434bdf7f07547bea9378b00ba description: MuleSoft Documentation Site release: "1.15" latest: false --- --- product: Database Connector version: 1.15 --- # Using Anypoint Studio to Configure Database Connector 1.15 > For the full documentation index, see: https://docs.mulesoft.com/llms.txt Anypoint Studio (Studio) editors help you design and update your Mule applications, properties, and configuration files. To add and configure a connector in Studio: 1. [Create a Mule Project](#create-mule-project). 2. [Add the connector to your Mule project](#add-connector-to-project). 3. [Configure a source for the connector’s flow](#configure-input-source). 4. [Add a connector operation to the flow](#add-connector-operation). 5. [Configure a global element for the connector](#configure-global-element). When you run the connector, you can view the app log to check for problems, as described in [View the App Log](#view-app-log). If you are new to configuring connectors in Studio, see [Using Anypoint Studio to Configure a Connector](https://docs.mulesoft.com/connectors/introduction/intro-config-use-studio). If, after reading this topic, you need additional information about the connector fields, see the [Database Connector Reference](https://docs.mulesoft.com/db-connector/1.15/database-documentation). ## Create a Mule Project In Studio, create a new Mule project in which to add and configure the connector: 1. In Studio, select **File > New > Mule Project**. 2. Enter a name for your Mule project and click **Finish**. ## Add the Connector to Your Mule Project Add Database Connector to your Mule project to automatically populate the XML code with the connector’s namespace and schema location and to add the required dependencies to the project’s `pom.xml` file: 1. In the **Mule Palette** view, click **(X) Search in Exchange**. 2. In the **Add Dependencies to Project** window, type `database` in the search field. 3. Click **Database Connector** in **Available modules**. 4. Click **Add**. 5. Click **Finish**. Adding a connector to a Mule project in Studio does not make that connector available to other projects in your Studio workspace. ## Configure a Source A source initiates a flow when a specified condition is met. You can configure one of these input sources to use with Database Connector: - **Database > On Table Row** Initiates a flow by selecting from a table at a regular interval and generates one message per obtained row - **HTTP > Listener** Initiates a flow each time it receives a request on the configured host and port - **Scheduler** Initiates a flow when a time-based condition is met For example, to configure an **On Table Row** source, follow these steps: 1. In the **Mule Palette** view, select **Database > On Table Row**. 2. Drag **On Table Row** to the Studio canvas. 3. In the **On Table Row** configuration screen, optionally change the value of the **Display Name** field. 4. Click the plus sign (**+**) next to the **Connector configuration** field to configure a global element that can be used by all instances of the source in the app. 5. In the **Database Config** window, for **Connection** select any of the connection types to provide to this configuration: - **Data Source Reference Connection** - **Derby Connection** - **Generic Connection** - **Microsoft SQL Server Connection** - **MySQL Connection** - **Oracle Connection** 6. On the **General** tab, specify the database connection information for the connector. 7. On the **Transactions** tab, optionally specify the transaction isolation, or XA transactions, when connecting to the database. 8. On the **Advanced** tab, optionally specify connection pooling and reconnection information, including a reconnection strategy. 9. Click **Test Connection** to confirm that Mule can connect with the specified database. 10. Click **OK** to close the window. 11. In the **On Table Row** configuration screen, in **Table**, specify the name of the table to select from. ## Add a Connector Operation to the Flow When you add a connector operation to your flow, you immediately define a specific operation for that connector to perform. To add an operation for Database Connector, follow these steps: 1. In the **Mule Palette** view, select **Database Connector** and then select the desired operation. 2. Drag the operation onto the Studio canvas and to the right of the input source. The following screenshot shows the Database Connector operations in the Mule Palette view of Anypoint Studio: ![Database Connector Operations](/mulesoft/current/en-us/db-connector/1.15/_images/database-operations.png) Figure 1. Database Connector Operations ## Configure a Global Element for the Connector When you configure a connector, it’s best to configure a global element that all instances of that connector in the app can use. Database Connector can connect to any database for which a JDBC driver is available. To make it easier to connect to the most popular databases (such as MySQL, Oracle, and Microsoft SQL Server), the connector includes a series of different connection types. To configure the global element for Database Connector, follow these steps: 1. Select the operation in the Studio canvas. 2. In the configuration screen for the operation, click the plus sign (**+**) next to the **Connector configuration** field to access the global element configuration fields. 3. In the **Database Config** window, for **Connection** select any of the connection types to provide to this configuration: - **Data Source Reference Connection** - **Derby Connection** - **Generic Connection** - **Microsoft SQL Server Connection** - **MySQL Connection** - **Oracle Connection** 4. On the **General** tab, specify the database connection information for the connector. 5. On the **Transactions** tab, optionally specify the transaction isolation, or XA transactions, when connecting to the database. 6. On the **Advanced** tab, optionally specify connection pooling and reconnection information, including a reconnection strategy. 7. Click **Test Connection** to confirm that Mule can connect with the specified database. 8. Click **OK**. The following screenshot shows the Database Connector **Global Element Configuration** window in Anypoint Studio: ![Database Connector Global Element Configuration](/mulesoft/current/en-us/db-connector/1.15/_images/database-global-configuration.png) Figure 2. Database Connector Global Element Configuration ## View the App Log To check for problems, you can view the app log as follows: - If you’re running the app from Anypoint Platform, the output is visible in the Anypoint Studio console window. - If you’re running the app using Mule from the command line, the app log is visible in your OS console. Unless the log file path is customized in the app’s log file (`log4j2.xml`), you can also view the app log in the default location `MULE_HOME/logs/.log`. ## See Also - [Introduction to Anypoint Connectors](https://docs.mulesoft.com/connectors/introduction/introduction-to-anypoint-connectors) - [Using Anypoint Studio to Configure a Connector](https://docs.mulesoft.com/connectors/introduction/intro-config-use-studio) - [Database Connector Reference](https://docs.mulesoft.com/db-connector/1.15/database-documentation) - [Configure Driver Visibility using Mule Maven Plugin](https://docs.mulesoft.com/db-connector/1.15/database-connector-driver-configuration) - [Salesforce Help](https://help.salesforce.com)