sources.xml
<?xml version="1.0" encoding="UTF-8"?>
<sources>
<source name="categories">
<connection-name>MySQL_sales</connection-name>
<field name="description" type="LONGVARCHAR"/>
<field name="id" primaryKey="true" type="INTEGER"/>
<field name="name"/>
<parameter>
<param-name>tableName</param-name>
<param-value>categories</param-value>
</parameter>
</source>
<source name="customer_emails">
<connection-name>MySQL_sales</connection-name>
<field name="email" primaryKey="true"/>
<field name="username"/>
<parameter>
<param-name>tableName</param-name>
<param-value>customer_emails</param-value>
</parameter>
</source>
<source name="order_details">
<connection-name>MySQL_sales</connection-name>
<field name="orderId" primaryKey="true" type="INTEGER"/>
<field name="price" type="DOUBLE"/>
<field name="productId" primaryKey="true" type="INTEGER"/>
<field name="quantity" type="INTEGER"/>
<parameter>
<param-name>tableName</param-name>
<param-value>order_details</param-value>
</parameter>
</source>
<source name="orders">
<connection-name>MySQL_sales</connection-name>
<field name="id" primaryKey="true" type="INTEGER"/>
<field name="orderDate" type="TIMESTAMP"/>
<field name="username"/>
<parameter>
<param-name>tableName</param-name>
<param-value>orders</param-value>
</parameter>
</source>
<source name="products">
<connection-name>MySQL_sales</connection-name>
<field name="categoryId" type="INTEGER"/>
<field name="id" primaryKey="true" type="INTEGER"/>
<field name="name"/>
<field name="price" type="DOUBLE"/>
<parameter>
<param-name>tableName</param-name>
<param-value>products</param-value>
</parameter>
</source>
</sources>