--- schema_version: "1" id: 7dd308b637f102e41fca760e21a62be518cb30495bfe7e42c3bf4a18225f0748 title: "Tutorial: Create a Mule app that uses the Database Connector and DataWeave" collection: mulesoft version: current locale: en-us portal_url: https://docs.salesforce.com/mulesoft/current/en-us/mule-runtime/4.11/mule-app-tutorial.md canonical_url: https://docs.mulesoft.com/mule-runtime/4.11/mule-app-tutorial source_site: docs.mulesoft.com content_type: documentation content_hash: 4c1d5dbfbde56c9a87da15c61264d1650c97d3c0e70d1f1e1ae5d66b88499ca0 description: MuleSoft Documentation Site release: "4.11" latest: false --- --- product: Mule Runtime version: 4.11 --- # Tutorial: Create a Mule app that uses the Database Connector and DataWeave > For the full documentation index, see: https://docs.mulesoft.com/llms.txt Most integrations require a change to the structure of data as it moves from source to destination. Within a Mule app, you can use the drag-n-drop interface of the Transform Message component to map data from one field or format to another, or you can write mappings by hand within DataWeave scripts. You typically build Mule apps in Studio, but you can even write Mule app configurations by hand in XML. This tutorial uses Studio. Using a small data set and a training API available on Exchange, you’ll create a project and define the transformation mapping from the API into a different structure and protocol. You’ll use the drag-n-drop and also see the [DataWeave](https://docs.mulesoft.com/mule-runtime/4.11/dataweave) code that defines the transformation. After completing this tutorial, you’ll be ready to create your own data mappings. ## Prerequisites To enable you to focus on a data mapping workflow, MuleSoft recommends completing a few setup tasks. 1. Navigate to [Training: American Flights API](https://anypoint.mulesoft.com/exchange/68ef9520-24e9-4cf2-b2f5-620025690913/training-american-flights-api/) in Exchange, and click the GET button to see a sample response in JSON: ![A JSON response example in a test environment showing data](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-json.png) This is the structure we’ll transform. 2. Download and install [Anypoint Studio](https://docs.mulesoft.com/studio/to-download-and-install-studio). 3. Create [an Anypoint Platform trial account](https://anypoint.mulesoft.com/login/#/signin?apintent=exchange) if you don’t have one. 4. Choose a REST API client such as Postman or the Advanced REST client. This tutorial uses the Advanced REST client. ## Step One: Create a Mule 4 Project Create the project that will contain your Mule app. 1. Open Anypoint Studio, and select **File > New > Mule Project**. 2. Set the **Project Name** to `dw-tutorial4-flights-ws`. 3. Leave all other defaults, and select **Finish** to create the project. When you’re done, look in the **Package Explorer** window to see the contents of your new project. ![A Mule project with directories for main, test, and resources](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-package-explorer.png) ## Step Two: Create and Configure a Mule 4 App Now we’ll add the elements required to fetch data from an API and transform it into a different structure using DataWeave. 1. Add an HTTP Listener operation to listen to the American Flights API. In the Mule Palette, select HTTP to display the HTTP operations, and drag the Listener operation onto the canvas. ![A palette menu showing components including Listener and Transform Message](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-listener.png) If you can’t see anything in the Mule Palette, open the project file `dw-tutorial4-flights-ws.xml` in the `src/main/mule` folder in Package Explorer. 2. Double-click the Listener operation to display its properties tab, and click the green plus sign to add a new configuration. ![A Listener configuration panel in Mule showing required settings for connector configuration](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-listener-properties.png) 3. In the HTTP Listener config dialog, add these values: - **Host**: `0.0.0.0` - **Port**: `8081` 4. Click **OK** to save these changes and close the dialog. 5. In the General tab for the Listener, change the **Path:** field to `/flights`. Your change is automatically saved. ![A configuration panel for a Listener component showing settings for path and connector configuration](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-path.png) 6. In the Mule Palette, select **Add Modules** to display a list of modules and connectors, and drag the Database connector into the left side of the Mule Palette. You may be asked to select a version. Select the latest version. ![A palette menu in Mule interface showing available modules like Database, HTTP, and APIKit for SOAP](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-add-db1.png) 7. Now that the Database connector is in the Mule Palette, you can see its operations. Drag the Select operation into the flow. ![A Mule flow configuration interface showing elements like Listener and Error handling](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-add-db2.png) 8. Let’s configure the Database operation to listen for responses from the MuleSoft sample MySQL database. Click the Select operator to display its properties tab, and click the add button (green cross) to open the Database Config dialog. 9. Select or type Mule’s sample database values in the dialog: - Connection: `MySQL Connection` - **Host**: `mudb.learn.mulesoft.com` - **Port**: `3306` - **User**: `mule` - **Password**: `mule` - **Database**: `training` ![A database configuration panel for MySQL connection with fields for host, port, user, and database](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-db-values.png) 10. While still in the Database Config dialog, select **Configure > Add Maven dependency**. 11. In the **Pick a Maven dependency** dialog, enter `mysql-` in the **Search Maven Central** search field. 12. Select `mysql:mysql-connector-java` from the displayed items. 13. Select **Finish** to return to the Database Config dialog. ![A database configuration panel showing MySQL connection settings and required JDBC driver information](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-db-driver.png) 14. Select **Test Connection**. You should receive a `Test connection successful` message. If you don’t, go back through the steps and look for errors. 15. Select **OK** to return to the Database Config dialog. 16. Create a query that returns all flights from the Training: American Flights API. 1. If it’s not already open, click the Select operation to display its property tab. 2. Add a select statement in the query field: `SELECT * FROM american`. Your changes are automatically saved. ![A database query setup with SQL text](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-select-query.png) 17. To test your configuration so far, run the project. You can right-click in the canvas where the flow is defined, and select **Run Project dw-tutorial4-flights-ws**. 18. Watch the Console tab and when the app is running, open your REST API client. 19. In the client, send a request to `http://localhost:8081/flights/`. At this point, the application returns a `500 Server Error` message because it cannot process the data received from the query to the American Flights API. This error is addressed when you add a Transform component to the flow during the next section of the training. ![An error message indicating a server error due to unsupported source type in a transformation process](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-object.png) Now that the app is set up, it’s time to transform some data into JSON so it can be consumed by a service that requires JSON. > [!IMPORTANT] Leave the Mule app running to avoid accidentally creating an orphan process that > might clog the port specified in your app. ## Step Three: Create and Test a DataWeave Data Transformation Now that we have a Mule app that works and is listening to the Training: American Flights API, we’ll add a Transform Message component and use the DataWeave drag-n-drop interface to define a transformation from Mule object into JSON. 1. In the Mule Palette, select Core and find the Transform Message component. ![A palette menu showing components like Database, HTTP, and Batch](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-add-transform.png) 2. Drag and drop the Transform Message to the right of the Select operation in the canvas. ![A visual editor in Mule showing components of a flight service workflow including Listener and Transform Message](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-canvas.png) 3. Click the Transform Message component to display the graphical view and source code view. ![An empty data transformation interface with options to define input and output metadata](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-dw-blank-palette.png) - The left side is a graphical view of the input and output metadata structures. The mapping between them is represented by lines and node points in the center. - The right side is a code view of the same structures and mapping. The code view and graphical views remain synced. 4. In the code view, change the output type in line 2 from `application/java` to `application/json`, and replace the brackets on lines 4 and 5 with `payload`. ![A DataWeave transformation interface with fields for defining JSON output structure](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-dw-palette.png) 5. Save the change to redeploy the project. 6. Test this change by sending a GET request in your REST client: `GET http://localhost:8081/flights`. ![An HTTP request setup showing method, URL, and headers](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-json1.png) With just two words in a DataWeave script, you’ve transformed a Mule object into JSON. Now we’ll map the existing data from the API to a data structure based on an example we provide. This example represents how a second service needs to consume the data from Training: American Flights API. 7. In the Transform Message’s Output panel, select **Define metadata** to open the **Select metadata type** dialog. 8. Select **Add** to open the **Create new type** dialog. 9. Enter `american_flights_json` and select **Create type**. ![An interface for selecting metadata type with options for simple and user-defined types](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-empty-type.png) 10. In the **Select metadata type** dialog, set the type to **JSON**. 11. In the drop-down below Type, change **Schema** to **Example**. 12. Copy and paste the following into a file and save it on your local machine or environment. Name the file `american-flights-example.json`. ```json [ { "ID": 1, "code": "ER38sd", "price": 400.0, "departureDate": "2016/03/20", "origin": "MUA", "destination": "SFO", "emptySeats": 0, "plane": { "type": "Boeing 737", "totalSeats": 150 } }, { "ID": 2, "code": "ER45if", "price": 345.99, "departureDate": "2016/02/11", "origin": "MUA", "destination": "LAX", "emptySeats": 52, "plane": { "type": "Boeing 777", "totalSeats": 300 } } ] ``` 13. In the **Select metadata type** dialog, click the button with three dots to navigate to the file you just created and select it. ![Dialog box for selecting a metadata type with options for JSON and user-defined types](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-json-example2.png) 14. Choose **Select** to save your change. Now you see the input and output data structures in the DataWeave interface. ![A DataWeave editor showing transformation setup with input and output structures](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-input-output.png) 15. Let’s start mapping fields to create the transformation. - Map fields with the same name by dragging them from the input section to the output section: - `ID` - `price` - `totalSeats` Notice the DataWeave code being written in the right-most pane as you drag and drop. ![A DataWeave editor showing transformation data into JSON format with fields including ID and code](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-same-name.png) - Map the rest of the data: - `toAirport` to `destination` - `takeOffDate` to `departureDate` - `fromAirport` to `origin` - `seatsAvailable` to `emptySeats` - `planeType` to `type` - Drag both `code1` and `code2` to `code` Notice the DataWeave code generated as you drag and drop fields to create the transformation. If you make a mistake such as dropping an input field onto the wrong output field, the code view marks the errors. Simply right-click on the output field and choose **Remove field mapping** to remove the error. 16. Let’s add some sample data, which helps us preview the mapping results. (You can skip this step if you wish). Select **Preview** over the code view, then click the link **Create required sample data to execute preview**. ![A DataWeave script showing mappings for fields including ID and code](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-sample-data1.png) 17. In the Input panel **payload** tab, replace all the question marks with data. Those values should also show up in the Output panel. Choose **File > Save All** from the Studio main menu. 18. We’ve finished defining the transformation, now let’s test it. Assuming that you’ve left the Mule app running as suggested earlier, open your REST client and send another request to the API: `GET http://localhost:8081/flights` ![A successful GET request with response details](/mulesoft/current/en-us/mule-runtime/4.11/_images/mruntime-quickstart-transformed.png) Notice that the data is structured as described in the Output panel, instead of following the Input pane structure as we saw in an earlier query. Now that you’ve succeeded in transforming data from Mule object to JSON, and from one data structure to another, you’re ready to get started with scripting in the DataWeave language (see [DataWeave Language Quickstart](https://docs.mulesoft.com/dataweave/latest/dataweave-quickstart)) and to explore more [Core components](https://docs.mulesoft.com/mule-runtime/4.11/about-components) and more [connectors and modules](https://docs.mulesoft.com/connectors/).