Hello, I've got AirByte set-up to pull data from a MS Sql Server and push the data to Postgres server on AWS, I'm able to run the job but no data is being sent. Is there a configuration setting that I might be missing.

Hello @Manoj Yadav it’s possible to share the connection settings page? when creating the connection you’re able to select the tables?

Here is what I see in the settings:

Looks the source is not reading the tables from MSSQL.

Ok, I'll check that and get back.

Hi @Marcos Marx (Airbyte)

Hi @Himanshu Yadav, do you mind: • sharing the output of the query you ran to list the table on which your user has read privilege • share your server logs (downloadable from the settings page) • open an issue on our repo that explains your problem?

Hi @[DEPRECATED] Augustin Lafanechere , we were able to log into SQL Server Management Studio with the above user and able to see all tables and query any one of them. Would that not be sufficient to prove that the user has the right permissions to read the database and data from those tables?

Are you trying to sync using CDC? If yes, https://docs.airbyte.com/integrations/sources/mssql#change-data-capture-cdc describe for some cases you need db_owner permission. If not, could you share the command to check the user permissions in MSSQL? I’ll run it against our integration database

Airbyte is able to copy data from MSSQL server to Postgres's `_airbyte_raw_{tablename}`but it doesn't show in the actual table.