Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III

Exporting CSV to MYSQl Database

Could someone please let me know if this is a possible scenario?
I would like to export CSV into a MYSQL database. I would like to create database on the fly, create subsequent schema and load data. Please let me know if this makes sense. I have been struggling to get this scenario to work. All I did was to import CSV file, create schema and create MYSQL connection.MY
Labels (3)
2 Replies
_AnonymousUser
Specialist III
Author

Any comments or solutions for this?
Could someone please let me know if this is a possible scenario?
I would like to export CSV into a MYSQL database. I would like to create database on the fly, create subsequent schema and load data. Please let me know if this makes sense. I have been struggling to get this scenario to work. All I did was to import CSV file, create schema and create MYSQL connection.MY
veryimportantdude
Contributor III

use fileinputCSV connect with tMap MySQL output check all parameters, edit schema, action on table set to create if not exist. Should work
if not write problems