You can select a single source object to transfer data from or define a custom query.
The type of source and the formatting and advanced options that you can configure for the source depend on the source connection that you select. For example, you can create a custom query for database sources that support SQL queries. For a flat file source, you can configure formatting options such as the formatting type. For Salesforce sources, you can configure advanced options such as the SOQL filter condition, row limit, and bulk query.
For information about the options that you can configure for a source connection, see the help for the appropriate connector.
You can preview the data in the source. The preview returns the first 10 rows. To preview rows in alphabetical order, select
Display fields in alphabetical order
.
Data Integration
does not change the order of rows in the actual source. You can also download the preview results as a CSV file.