Here we will see how to connect to MySQL database server using Python in different ways. We need to install mysql-connector-python module to connect to MySQL database from Python programming language. We will create the connection objects in different ways and using this connection object we will be able to connect to MySQL server.
ContinueTag: Connector
Modify input file name while moving to another directory using Mule ESB
In this tutorial I am going to show you how we can move files from one directory to another directory in Mule ESB. We will use File Connector to take an Excel file as input and this Excel file will be moved to another directory but with modified name. You can see also File transfer from source directory to destination directory in Mule ESB
ContinueConvert XML to JAXB Object in Mule ESB
In this tutorial I am going to show you how we can convert XML data into JAXB object in Mule ESB. We will use File Connector to take an XML file as input then we will map it to an appropriate JAXB object. You can see also Convert JAXB Object to XML in Mule ESB The JAXB transformers allow objects to be serialized to XML and back again using the JAXB binding framework. Java Architecture for XML Binding (JAXB) allows Java developers to map Java classes to XML representations. JAXB…
ContinueConvert file data to map-payload and insert into MySQL using Mule ESB
This tutorial will show you how to use Mule JDBC Transport to convert text file data to Map and insert into MySQL database in Mule based application. You may also review Mule JDBC Insert Example and Dump CSV data into MySQL Database using Mule ESB Connectors provide an abstraction layer over data transport mechanisms. Connectors exist for things such as files, email messages, databases, JMS, and even Jabber messages. A connector saves you the tedium of having to implement the details of a particular communication mechanism yourself. This allows you…
ContinueDump CSV data into MySQL Database using Mule ESB
This tutorial will show you how to use Mule JDBC Transport to dump CSV data into MySQL database in Mule based application. You may also review Mule JDBC Insert Example Connectors provide an abstraction layer over data transport mechanisms. Connectors exist for things such as files, email messages, databases, JMS, and even Jabber messages. A connector saves you the tedium of having to implement the details of a particular communication mechanism yourself. This allows you to focus on solving your integration problem and not on the plumbing of a particular…
ContinueMule JDBC Insert Example
This tutorial will show you how to use Mule JDBC Transport to insert data into MySQL database in Mule based application. Connectors provide an abstraction layer over data transport mechanisms. Connectors exist for things such as files, email messages, databases, JMS, and even Jabber messages. A connector saves you the tedium of having to implement the details of a particular communication mechanism yourself. This allows you to focus on solving your integration problem and not on the plumbing of a particular communications protocol. The JDBC Transport lets you send and…
ContinueMule VM Transport with File Connector Example
This tutorial will show you how to use VM Transport with File Connector in Mule based application. You can see the same tutorial in youtube video https://youtu.be/OQUqruRJbrU You may like the other tutorial Mule VM Transport with HTTP Example What is VM Transport The VM transport is nothing but an in-memory transport. Therefore when a message has to be passed through a VM endpoint, i.e., the message is being transferred from one endpoint to another endpoint in memory. So the VM transport can be used for intra-JVM communication between Mule flows. It can be used…
ContinueMule VM Transport with HTTP Example
This tutorial will show you how to use VM Transport with HTTP Connector in Mule based application. What is VM Transport The VM transport is nothing but an in-memory transport. Therefore when a message has to be passed through a VM endpoint, i.e., the message is being transferred from one endpoint to another endpoint in memory. So the VM transport can be used for intra-JVM communication between Mule flows. It can be used only in single Mule application and cannot be used to communicate between two or more Mule applications. This transport by…
ContinueSend email attachment using SMTP in Mule ESB
What is Mule ESB ? Mule ESB is a lightweight Java-based enterprise service bus (ESB) and integration platform that allows developers to connect applications together quickly and easily, enabling them to exchange data. Mule ESB enables easy integration of existing systems, regardless of the different technologies that the applications use, including JMS, Web Services, JDBC, HTTP, and more. This example shows how we can send email attachment using SMTP connector to self or another email. We simply put a file in a source directory and Mule will read the file…
ContinueAppend-String Transformer in Mule ESB
What is Mule ESB ? Mule ESB is a lightweight Java-based enterprise service bus (ESB) and integration platform that allows developers to connect applications together quickly and easily, enabling them to exchange data. Mule ESB enables easy integration of existing systems, regardless of the different technologies that the applications use, including JMS, Web Services, JDBC, HTTP, and more. This example shows how we can read a file from a source directory and append a string to the file content and display it into the console. We simply put a file…
Continue