One of our source databases is on FoxPro. In order to create reports with the full functionality enabled by Yellowfin, we import data from certain Foxpro tables and fields into a MySQL database attached to Yellowfin. From there we create our views and reports. Not being a techie, a Yellowfin consultant helped me set this up.
I want to add some new tables and fields into the MySQL database. I understand I should be able to do this with Pentaho Kettle, which I have installed.
I have enough knowledge to set up the ETL from FoxPro to MySQL, but I do not know how to set up new target tables and fields in MySQL. Can I do this with Kettle and could you provide guidance on how to do this?
Also, it would be great to have a Webinar or YouTube video on this subject.
I believe that this forum question was handled via our CRM. Please let us know if you have any questions or concerns.