I try to download BC-Table directly to SQL. This never worked for me so I have to create a JSON using BCCL and afterwards SSIS to upload the Data to SQL.
What did I wrong? I tried to get the reason using the
-v parameter
. I observed that the program stops after logging (Example)
Primary Result Length = 20813 (ws call duration 00:00:00.4911925)
These are the commands
bccl --remember -w "https://api.businesscentral.dynamics.com/v2.0/{{tenantid}}/{{Environment}}/WS/{{company}}/Codeunit/bccl" --auth S2S --tenantid {{tenantid}} --clientid {{clientid}} --clientsecret {{clientsecret}} --sqlconnect "Server={{sqlserver}};Database={{database}};persist security info=True;Integrated Security=SSPI;"
bccl -t getdata -s table=36 -o Sales_Header -m mapping\Sales_Header.mapping.json
Environment:
Windows Server 2019, SQL Server 2005, No errorlog entry visible when using BCCL