Dec 09, 2023 05:01 AM
I am using a design tool (DBSchema) that can connect to most Databases in the industry, it typically uses a JDBC connection but has many others. Does anyone know what drivers AIRtable uses and what the JDBC URL would look like?
I could not find this in any documentation.
Thanks in advance
Dec 09, 2023 08:07 AM - edited Dec 09, 2023 11:00 AM
Airtable is not an ODBC/JDBC compliant database system.
If you’re looking for a low-code, cloud-based, database system that is ODBC/JDBC compliant, you will want to use Claris FileMaker, which is the world's most powerful & most customizable low-code database app. (It is also available for on-premise servers as well, if you don't want to store your databases in the cloud.)
I used to be one of the nation's top FileMaker developers for approximately 30 years, before becoming an Airtable Consultant in 2018.
Feel free to reach out to me through my website if you would like referrals to the top FileMaker developers that I personally recommend. I can put you in touch with excellent FileMaker developers.
p.s. I am also available for hire as an Airtable consultant as well, so for anybody who is switching from FileMaker to Airtable — or for anybody who wants to have integration/automation/communication between FileMaker & Airtable — be sure to reach out to me! 😃 I'm the only consultant in the entire world who is an expert at both platforms!
Dec 11, 2023 11:54 AM
Scott is right - Airtable does not have a native/included ODBC/JDBC connector.
I've heard of customers using a third party offering from CData (https://www.cdata.com/drivers/airtable/odbc/) -- it is not free though.