Access data from many databases, including Oracle, MySQL, Amazon Redshift, Snowflake, Microsoft SQL Server, and more
Completely cross-platform compatible
Load an entire database table into Stata. or use a SQL SELECT to just load specific columns from a table into Stata
Insert all your variables into a database table, or insert just a subset of your data
Execute SQL statements from Stata
Store connection settings as a data source name (DSN)
Connecting Stata with databases has gotten even easier. jdbc allows us to exchange data with some of the most popular database vendors such as Oracle, MySQL, Amazon Redshift, Snowflake, Microsoft SQL Server, and much more. What's great about jdbc is that it's a cross-platform solution, so our JDBC setup works the same way for Windows, Mac, and Unix systems. Once you install a JDBC driver, that driver and your Stata code are all you need to switch from, say, your Mac laptop to your company's Windows cloud systems.
Learn more about setting up a JDBC DSN, executing SQL, loading data, and inserting data with in-depth examples in the Stata Data Management Reference Manual; see [D] jdbc.