The following page will cover how to get data out of Podio and into a SQL table, so that it can be used for other business processes.
Below is a quick video showing you how you can export data from a Podio App to a new SQL Table using Data Sync.
Make sure to have added the columns from Podio you want to include in your SQL table to the schema map and then go to
Create SQL Table.
Follow through the wizard to connect to your SQL database and then type in a name for your new table.
Once you click
OK your target will now be connected to the new SQL table.
If you have not already added or removed the columns from the schema map, make sure to do this now.
Map the source columns to their corresponding column in the target and make sure to select a key column that can be used to uniquely identify each of the records.
Once you have configured your schema map, click the
Compare A > B button in the toolbar. This will open the compare results where you can preview the changes to be made.
To preview any additions click on the green plus icon, updates click on the blue diamond, and deletes click on the red minus.
Deletes are disabled by default to prevent accidental deletions but will still appear in the results if their are any. To enable delete set
True on your target.
Start to begin the sync. Your Podio App data has now been added to your SQL table.