We are a new CData user, connecting Acumatica oData as the source to SQL Server OLE DB destination. It works great for the initial configuration of the data flow, but we often change the underlying Acumatica query (i.e. add columns). I can’t seem to find a way to refresh the available columns in the CDdata Acumatica Source Editor screen. If I click the preview button, the new columns appear there correctly with data, but how are the columns added to the Columns node of the Editor screen?
Along those lines, is there a way to refresh the list of available Generic Inquiries for new oData sources? The first time you log into Visual Studio the list of available inquiries refreshes, but after that I have to just use the Advanced Editor and hand-write the name of the query.
Thanks for any feedback!