Developer forum

Forum » Dynamicweb 10 » Export content of a view using DataIntegration

Export content of a view using DataIntegration

E-mail notifications
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply
Posted on 26/04/2026 13:27:53

Hi guys,
I created a view on the database and I am trying to export it with a DataIntegration job.
In DW9 we used to have "DynamicwebProvider with Views" option in Sources.
I tried both DynamicwebProvider and SQL provider but none of these options display the view I just created.

Also, the SQL firehose does not expose the view as an option in the autocomplete list, although the select statement works.
Anything more I need to do to export the view?

Thank you,
Adrian


Replies

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Posted on 26/04/2026 13:50:08
Reply

Apparently, if I create the view correctly, using dbo. prefix, it is displayed in the DynamicWebProvider list of source data.
I am not sure how to use SQL Provider in this case and if there is any difference between SQL Provider and DynamicWebProvider..
Thank you,
Adrian

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 27/04/2026 17:29:55
Reply

Hi Adrian,
can not reproduce that, I can see the same views in the DW/Sql providers tables lists. Tried to create the other schema for reproducing and it worked fine, used sql like that:
CREATE SCHEMA test AUTHORIZATION dbo;
CREATE VIEW test.View AS SELECT * FROM AccessUser;

If that doesn't work could you share the sql for creating the View that doesn't work?
The code which gets the availables schema tables(and views) and columns for the DW/Sql provider is the same, the only difference is getting the connection.
BR, Dmitrij

 

You must be logged in to post in the forum