Troubleshooting the ODBC Extractor

Use a yml Lint site to validate your yml file.

View the log file in the logging folder (as configured in the configuration file) for any error messages.

Double-check your connection string.

Double-check that all references to dataset and pipeline IDs are correct.

Double-check that the client ID and secret in the on-prem configuration file is correct.

If you start the extractor but data fetched successfully but error while pushing data into CDF check once the scopes are properly assigned in auth0.

If extractor ran successfully and extraction is successful but no data pushing into cdf or only few rows are getting pushed (not whole data), then check primary key which you are defining in config.yml file is present in source table or not.

If extractor ran successfully but no data extracted then try to run the query defined in queries section of config.yml file into the sql server.