A 400 bad request error is not about authentication, but about what it recieves when attempting to connect to the source. This is commonly because the response you get from the JSON source is in HTTP format.
Try to set the data source setup to not be JSON, but CSV instead.
Also set up a log with verbosity level 3, then it will show what data it returns in the log.
ODX service is running on the TimeXtender user account. I am getting an authentication error If I change OAuth setting file Location to my account.
Authentication was successful If I use the below location.
C:\Users\timextender\AppData\Roaming\CData\REST Data Provider\OAuthSettings.txt\sguntupalliadmin\AppData\Roaming\CData\REST Data Provider\OAuthSettings.txt
Which one is best to use?
So, ODX uses a Service user account. Where do I need to set SCHEMA files for pagination?
Then all users who uses this data source will point at the same location for a file. If you used the C:\Users\timextender\AppData\Roaming\CData\… path you can experience that other users cannot see the file due to the location of the file.
Please use an external tool (like Postman) to verify all the connection strings are correct.
Normally, The server cannot or will not perform the request because of what is thought to be a client problem, according to the 400 (Bad Request) status code. To cross-check whether the connection string details are working fine or not, could you please make the same request with the URL and Header by using Postman and let us know if you are seeing any result or not with all the authentication methods which are shown in the log file?
If you are able to see the result in Postman, then please try to test again with CData provider in TimeXtender, and generate a logfile in order to troubleshoot.
Since the Synchronize and Transfer tasks ran OK, preview the tables in ODX, ER (Fire) data source, to verify the incoming data rows look OK, then map those tables to MDW.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.