# DB Loader node, how can I set up correct data types?

**URL:** <https://forum.knime.com/t/db-loader-node-how-can-i-set-up-correct-data-types/45363>\
**Category:** KNIME Analytics Platform\
**Tags:** database\
**Created:** [July 22, 2022, 1:40pm UTC](https://forum.knime.com/t/db-loader-node-how-can-i-set-up-correct-data-types/45363 "2022-07-22T13:40:36Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![fedetoffano93](https://forum-cdn.knime.com/user_avatar/forum.knime.com/fedetoffano93/32/42837_2.png) [@fedetoffano93](https://forum.knime.com/u/fedetoffano93)\
**Post date:** [July 22, 2022, 1:40pm UTC](https://forum.knime.com/t/db-loader-node-how-can-i-set-up-correct-data-types/45363/1 "2022-07-22T13:40:36Z")

</div>

Hello forum!

I am trying to load data that is stored in Excel into a MYSQL database. I tried using the DB Insert node, but since I need to load sometimes 200 thousand rows the performance of DB Insert is too slow. I want to try with the DB Loader node, as the description says it’s good for bulk loads of data.

The problem I am encountering is data types. For example, my data from Excel is String type in Knime, but needs to be VARCHAR in the database. I cannot understand how to change the data types to match the database types. the DB Insert node has settings that allow to do that, but DB Loader does not.

Anybody has an idea?

![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/7/07d26b723700570d6e65c8a46d7f3edbce4fedec.png)

---

<div class="post-metadata">

**Author:** ![izaychik63](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/i/e9a140/32.png) [@izaychik63](https://forum.knime.com/u/izaychik63)\
**Post date:** [July 22, 2022, 2:25pm UTC](https://forum.knime.com/t/db-loader-node-how-can-i-set-up-correct-data-types/45363/2 "2022-07-22T14:25:53Z")

</div>

DB Loader will not change table data type. As string a varchar are compatible, what exact issue do you have?

---

<div class="post-metadata">

**Author:** ![fedetoffano93](https://forum-cdn.knime.com/user_avatar/forum.knime.com/fedetoffano93/32/42837_2.png) [@fedetoffano93](https://forum.knime.com/u/fedetoffano93)\
**Post date:** [July 22, 2022, 2:28pm UTC](https://forum.knime.com/t/db-loader-node-how-can-i-set-up-correct-data-types/45363/3 "2022-07-22T14:28:49Z")

</div>

Hello! These are the errors I am getting.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/2/1/21325fea829434104acce28a9d4c11b675eb8ea3.png)

---

<div class="post-metadata">

**Author:** ![fedetoffano93](https://forum-cdn.knime.com/user_avatar/forum.knime.com/fedetoffano93/32/42837_2.png) [@fedetoffano93](https://forum.knime.com/u/fedetoffano93)\
**Post date:** [July 25, 2022, 5:02pm UTC](https://forum.knime.com/t/db-loader-node-how-can-i-set-up-correct-data-types/45363/4 "2022-07-25T17:02:17Z")

</div>

I found out how to solve it, just need to set outbound parameters in the MYSQL connection node.  
Learned here [DB upload takes long time - #5 by varelapablo](https://forum.knime.com/t/db-upload-takes-long-time/33296/5).

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [August 1, 2022, 5:02pm UTC](https://forum.knime.com/t/db-loader-node-how-can-i-set-up-correct-data-types/45363/5 "2022-08-01T17:02:34Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.