Skip to content

Creating a Data Source

Follow the instructions given below to create a data source artifact in the Micro Integrator for Visual Studio Code extension (MI for VS Code).

  1. Launch Visual Studio Code with the Micro Integrator for VS Code extension (MI for VS Code) installed.

    Info

    Follow the Install Micro Integrator for VS Code documentation for a complete installation guide.

  2. Create an integration project.

  3. To add a new Sequence Template, navigate to Micro Integrator Project Explorer.

  4. Click on the + icon to open the Add Artifact pane.

    add artifact

  5. Click + View More under Create an Integration.

  6. Click Data Source under Other Artifacts to open the Data Source Creation Form.

    This will open a form to create a new datasource.

  7. Enter the following details:

    Property Name Description
    Datasource Name Name of the datasource
    Description Description
    Datasource Type Type of the datasource
    Data source provider Choose between default and external data source
    Database Engine Database engine for the data source
    Driver Driver for the data source
    URL URL for the data source
    Username Username for the datasource
    Password password for the datasource
    JNDI Name JNDI name for the datasource to expose it as a JNDI datasource

  8. Click Create to create the data source.

Shown below is the sample configuration that is created. You can now update the values in this configuration.

<datasource>
    <name>MySQLConnection</name>
    <description>MySQL Connection</description>
    <jndiConfig useDataSourceFactory="false">
        <name>MysqlConJNDI1</name>
    </jndiConfig>
    <definition type="RDBMS">
        <configuration>
            <driverClassName>com.mysql.jdbc.Driver</driverClassName>
            <url>jdbc:mysql://localhost:3306/mysqldb</url>
            <username>root</username>
            <password>root</password>
        </configuration>
    </definition>
</datasource>

Tip

You can generate data services for the created datasource. For more information, you can follow the steps given in Generate Data Services.

Examples

Follow our example on data sources: