#Amazon DocumentDB ODBC Driver GA Release
The Amazon DocumentDB ODBC Driver is an ODBC 3.0-compliant driver. The driver normalizes documents into a relational schema and executes a relational query and it supports a subset of SQL-92 along with some common extensions and supports SELECT
statements of the general form:
SELECT [ ALL | DISTINCT ] { * | projectItem [, projectItem ]* }
FROM tableExpression
[ WHERE booleanExpression ]
[ GROUP BY { groupItem [, groupItem ]* } ]
[ HAVING booleanExpression ]
[ ORDER BY orderItem [ ASC | DESC ] [, orderItem [ ASC | DESC ]* ]
[ LIMIT limitNumber ]
[ OFFSET startNumber ]
The driver can be used to integrate with BI tools that support ODBC Driver. For Power BI Desktop/Gateway users, a connector is available to use.
What's Changed
- [AD-993] Add compiler and linker flags to harden the compiled application. by @birschick-bq in #133
- [AD-979] Document Power BI filter limitation by @affonsoBQ in #135
- [AD-996] Scan for inappropriate secrets stored in source code (trufflehog) by @affonsoBQ in #137
- [AD-994] redact query and connection string information in ERROR while the log is not set to DEBUG by @affonsoBQ in #138
- [AD-1009] Allow user/password to be save for in-memory configuration by @birschick-bq in #139
- [AD-1010] Add documentation on static and runtime quality components. by @birschick-bq in #143
- [AD-1013] - Update Documentation for all known issues by @affonsoBQ in #142
- [AD-565] Power BI custom connector by @affonsoBQ in #144
- [AD-776] Add support for Timestamp. Fix Date handling for dates before Epoch. by @birschick-bq in #141
- [AD-1030] Support single instance SSH tunnel in ODBC driver installation. by @birschick-bq in #146
- [AD-1047] Update JDBC version and set the version of 'mongo-cxx-driver' to a specific version. by @birschick-bq in #148
- [AD-1072] Pin version of mongo-cxx-driver for compatibility. by @birschick-bq in #152
- [AD-1070] Automate Windows Signing Step for GitHub by @alexey-temnikov in #150
- [AD-1070] Automate Windows Signing Step for GitHub #149 by @alexey-temnikov in #153
- [AD-1070] Automate Windows Signing Step for GitHub by @alexey-temnikov in #155
- [AD-1069] Resolve text data type support for Power BI DirectQuery by @birschick-bq in #156
- [AD-1071] Support DirectQuery in Power BI Connector by @birschick-bq in #147
- [AD-1076] Fix installer signing steps. by @birschick-bq in #158
- [AD-1037] Update known issues by @affonsoBQ in #145
- [AD-1044] Update Windows Installation documentation by @affonsoBQ in #159
- [AD-1034] Bump ODBC Version to 1.0.0 by @affonsoBQ in #161
- [AD-1084] Fix MongoDB dependency installation for admin console. by @birschick-bq in #165
- [AD-1083] Add documentation for release procedures. by @birschick-bq in #163
- Update Documentation by @affonsoBQ in #157
- Fix Sign Automation by @affonsoBQ in #164
- [AD-1074] Updated developer-guide.md for missing information. by @birschick-bq in #160
- Fix Build Failing on Pushes by @affonsoBQ in #166
- Added the year and copyright owner on the license file by @affonsoBQ in #168
- Port JIRA TODO comments to GitHub issue links. by @birschick-bq in #189
Full Changelog: https://github.com/aws/amazon-documentdb-odbc-driver/commits/v1.0.0