1 of 1 people found this helpful
Shameless plug: TC16 Session
So here's what you do for Problem 2:
- Add a single MySQL table to join area - one that you are joining to Postgres
- Now go to Data > Convert to Custom SQL
- In the dialog, copy the line that selects join key and duplicate it
- Cast the copy: CAST(`MyColumn` as UNSIGNED) as `Proper Join Key`
- Now use that newly created column for the join
Problem 2 is very similar - you have a join on mismatched data types but for single connection datasource we allow you to do that and let database either succeed (by doing internal casts or type normalization) or fail.
With cross-database join we need to be more strict so you have to resolve that conflict manually - Custom SQL is most convenient way but I'd reevaluate your schema (i.e. storing numbers as strings is time and space consuming).
Could you try this out and let me know how it goes?