Using SQL-WHERE filters in MapForce

When you are using MapForce for a data mapping project that includes a database source, you can use the SQL-WHERE component to filter the data on a granular level before writing it to the target data structure, whether that be another database, an XML file, a flat file, an EDI message, or a Web service.

Once you have inserted a source database in your MapForce data mapping design using the database connection wizard, follow the steps below to configure a SQL-WHERE component:



Note See the MapForce Online Help file for more information on creating SQL-WHERE filters.