How do I insert a new table and fields in our Yellowfin database?
16 December, 2015
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.