# Toad Data Point 4.3 vs Microsoft SQL Azure

**URL:** <https://forums.toadworld.com/t/toad-data-point-4-3-vs-microsoft-sql-azure/41034>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [June 7, 2018, 11:23am UTC](https://forums.toadworld.com/t/toad-data-point-4-3-vs-microsoft-sql-azure/41034 "2018-06-07T11:23:03Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![laxmikant.shrigadi](https://avatars.discourse-cdn.com/v4/letter/l/94ad74/32.png) [@laxmikant.shrigadi](https://forums.toadworld.com/u/laxmikant.shrigadi)\
**Post date:** [June 7, 2018, 11:23am UTC](https://forums.toadworld.com/t/toad-data-point-4-3-vs-microsoft-sql-azure/41034/1 "2018-06-07T11:23:03Z")

</div>

Hello,

At this moment, I am able to connect using SQL Server authentication, but I am getting errors like “Catalog view ‘xml\_schema\_collections’ is not supported in this version”, “Catalog view ‘federations’ is not supported in this version”. I am trying to use 'SQL Server Native Client 11.0" ODBC driver. But, that didn’t help. In Object explorer, I can see the views, but not the list of tables. Also, when I try to generate script, it give one of the above errors. Can someone please let me know if there is any solution available for this kind of behavior?

---

<div class="post-metadata">

**Author:** ![Cindy.Sang](https://avatars.discourse-cdn.com/v4/letter/c/edb3f5/32.png) [@Cindy.Sang](https://forums.toadworld.com/u/Cindy.Sang)\
**Post date:** [June 8, 2018, 2:04am UTC](https://forums.toadworld.com/t/toad-data-point-4-3-vs-microsoft-sql-azure/41034/2 "2018-06-08T02:04:40Z")

</div>

from error message we could clearly tell that TDP 4.3 not support "Catalog view ‘xml\_schema\_collections’, I create QAT-13048 to request enhancement. I am afraid there is no workaround for this but let me check with developer.

Cindy

---

<div class="post-metadata">

**Author:** ![VasiliyFofanov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vasiliyfofanov/32/10873_2.png) [@VasiliyFofanov](https://forums.toadworld.com/u/VasiliyFofanov)\
**Post date:** [June 13, 2018, 12:58pm UTC](https://forums.toadworld.com/t/toad-data-point-4-3-vs-microsoft-sql-azure/41034/3 "2018-06-13T12:58:48Z")

</div>

Hello,

Could you say - do you use Azure SQL Data Warehouse?  
I can’t reproduce your case on simple Azure SQL

---

<div class="post-metadata">

**Author:** ![laxmikant.shrigadi](https://avatars.discourse-cdn.com/v4/letter/l/94ad74/32.png) [@laxmikant.shrigadi](https://forums.toadworld.com/u/laxmikant.shrigadi)\
**Post date:** [June 14, 2018, 7:51am UTC](https://forums.toadworld.com/t/toad-data-point-4-3-vs-microsoft-sql-azure/41034/4 "2018-06-14T07:51:34Z")

</div>

Hello Vasiliy,

Yes. Here is the version of my sql server DB: Microsoft Azure SQL Data Warehouse - 10.0.9999.0

Please let me know if this helps.

Thanks,

Laxmikant.

---

<div class="post-metadata">

**Author:** ![laxmikant.shrigadi](https://avatars.discourse-cdn.com/v4/letter/l/94ad74/32.png) [@laxmikant.shrigadi](https://forums.toadworld.com/u/laxmikant.shrigadi)\
**Post date:** [June 14, 2018, 7:53am UTC](https://forums.toadworld.com/t/toad-data-point-4-3-vs-microsoft-sql-azure/41034/5 "2018-06-14T07:53:18Z")

</div>

Thank you Cindy. Is it possible to predict resolution for this enhancement request QAT-13048?

Thanks,

Laxmikant.

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [June 14, 2018, 6:19pm UTC](https://forums.toadworld.com/t/toad-data-point-4-3-vs-microsoft-sql-azure/41034/6 "2018-06-14T18:19:18Z")

</div>

We are looking at this. it is hard to predict as SQL Azure Data warhouse has many new datatypes and we may have to create a separate custom provider for this.

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [July 11, 2018, 6:35pm UTC](https://forums.toadworld.com/t/toad-data-point-4-3-vs-microsoft-sql-azure/41034/7 "2018-07-11T18:35:10Z")

</div>

FYI. We have started work on this.
