Generally, Funnel does not support directly exporting data to SQL databases. The exception is Google BigQuery, which you can read more about here.
For other SQL databases, you'll need to use one of our other exports to export your data to a file store, and from there import it into your database. For instance if you have a mySQL database hosted by Amazon Web Services, you can use our S3 export and import into your database from there. If you use Microsoft Azure, our Blob Storage export would suit you. If you host your database on your own servers and don't have a cloud file storage, our SFTP export might be the best solution.
Funnel has a number of functions to make importing the data into SQL databases easier for you:
- column headers - Choose safe ID or safe Field Name in the 'Formats > header format' section of the export configuration, and we will create files with headers that can be used as database column names.
- Schema file - We create and upload a schema.sql file that you can use to create tables that match the data in the files. The file will be alongside the Funnel data files.
- lastRun file - We create and upload a lastRun.txt file after all files have been successfully exported that you can use to trigger the next step in your process. Exactly how you do this depends on the file storage you are using, and is beyond the scope of this article.
Why doesn't Funnel support more SQL databases?
Ordinarily SQL databases are not exposed directly to the internet and database administrators are unwilling to give out usernames and passwords with 'write' permissions to external applications like Funnel. Most databases have simple import functions, and Funnel can export data in formats most databases can easily import.