Setting up your database - experianplc/experian-data-studio-connector-mulesoft GitHub Wiki

Please see the Database Connector on how to set this up if the below instructions are unclear.

Before you get started, you will need to add the jar file associated with your database JDBC driver.

Adding a jar file.

Going back to the main screen, first you will want to configure your build path. Do this by right clicking app and selecting Build Path -> Configure Build Path.

image

Finally, select Add External JARs and select the jar you downloaded (extraction may be necessary).

image

Postgres: For your Driver Class Name, use org.postgresql.Driver.

jdbc:postgresql://{{host}}:{{port}}/{{databaseName}}?user={{username}}&password={{password}}

For example you might have: jdbc:postgresql://localhost:1234/postgres?user=postgres&password=postgres

SQL Server: For your Driver Class Name, use com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc:sqlserver://{{host}}:{{port}};databaseName={{databaseName}};user={{username}};password={{password}}

For example, you might have: jdbc:sqlserver://localhost:1433;databaseName=AdventureWorks;user=MyUserName;password=MyPassword

Be sure to test your connection.

image


Wrap-up

Once your jar has been added to your build, in your mule-app.properties file you will want to modify databaseJdbcUrl and databaseDriverClassName to the appropriate connection string and driver class names, respectively.