Forum Discussion

RMV's avatar
RMV
Icon for Helper V rankHelper V
9 years ago
Solved

Change data source from SQL to MySql

Hi,   I have imported several datasets from tables in a SQL database. For 1 dataset, I need to change the source from this SQL database to a MySql database. How can I do this?   Regards,
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Create a query that connects to MySQL. Go into Query Editor and go to Advanced Editor. Copy Source line. Go to SQL query in Query Editor, Advanced Editor and replace the Source line.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

Create a query that connects to MySQL. Go into Query Editor and go to Advanced Editor. Copy Source line. Go to SQL query in Query Editor, Advanced Editor and replace the Source line.

  • RMV's avatar
    RMV
    Icon for Helper V rankHelper V
    9 years ago

    Hi Greg_Deckler, got it!

    Thanks for your advise!