CData ODBC Driver for Amazon Marketplace 2019 - Online Help
Questions / Feedback?

From FileMaker Pro

CData ODBC Driver for Amazon Marketplace 2019 - Build 19.0.7354

You can connect to a DSN to load Amazon Marketplace data into FileMaker Pro tables that can be refreshed on demand.

Building a Query to Amazon Marketplace

FileMaker Pro provides a wizard to build the data import SQL.

  1. In your FileMaker Pro database, select File > Import Records > ODBC Data Source, and select the CData Amazon Marketplace Source DSN.
  2. In the resulting SQL Query Builder wizard, select tables and columns and then click Insert into SQL Query. You can also edit this query directly.

    You can use the UI to build filters in the WHERE clause by clicking the WHERE tab.

  3. In the resulting Import Field Mapping wizard, you can define mappings from columns in the data source to the columns in a destination table. To create a new table for the query results, select New Table ("CData Amazon Marketplace Source") from the Target box and click Import.

Refreshing Data

You can load any changes made to the external data into your FileMaker tables in Browse by selecting Records > Refresh Window. FileMaker Pro also executes a SELECT to Amazon Marketplace when you run a search on the Fields tab of the relationships graph. To pick up new fields added to Amazon Marketplace, select File > Manage > Database. In the resulting dialog, click the Fields tab, select a table, and then select columns to sync.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0