SSIS Components for Azure Data Catalog

Build 23.0.8839


Get list of databases.

Table Specific Information


The 本製品 will use the Azure Data Catalog API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.

  • Name supports the '=, !=, <>, CONTAINS' operators.
  • Timestamp supports the '=, <, <=, >, >=, CONTAINS' operators.
  • LastRegisteredTime supports the '=, CONTAINS' operators.
  • ObjectType supports the '=' operator.
  • SourceType supports the '=' operator.
  • FriendlyName supports the '=, CONTAINS' operators.
  • Experts supports the '=, CONTAINS' operators.
  • Description supports the '=, CONTAINS' operators.
  • Tags supports the '=, !=, <>, CONTAINS' operators.
  • HasTags supports the '=' operator.
  • HasPreviews supports the '=' operator.
  • HasDocumentation supports the '=' operator.
  • HasTableDataProfiles supports the '=' operator.
  • HasColumnsDataProfiles supports the '=' operator.
  • HasDescription supports the '=' operator.
  • View supports the '=' operator.
  • Facets supports the '=' operator.
For example:
    SELECT * FROM Databases WHERE HasDocumentation = false AND HasDescription = false AND HasTags = true;

    SELECT * FROM Databases WHERE Timestamp > '2019-09-19T04:39:54.0083651Z'

    SELECT * FROM Databases WHERE Tags = 'sales' OR Name = 'FactProductInventory'


Name Type Description
Id String Id of a database.
Type String Type of database.
EffectiveRights String Rights a particular annotation has.
Roles String Roles of a database.
RoleMembers String Members whom roles was assigned.
Timestamp Datetime Created time of database.
Name String Name of a property.
ObjectType String Type of object. Eg. table, etc.
SourceType String Source type. Eg. Jdbc, Odbc, etc.
DslAddressDatabase String DSL address of a database.
DslAuthentication String Type of authentication used.
DslProtocol String Describes a protocol used to communicate with the data source.
FromSourceSystem Boolean Indicates whether data of an item is derived from a source system or authored by a user.
LastRegisteredByObjectId String Object Id of a last registered user.
LastRegisteredByUpn String Upn of last registered user.
AccessInstructionsId String Id of an access instructions.
AccessInstructionsType String Type of an access instructions.
AccessInstructionsEffectiveRights String Effective rights of a particular access instructions.
AccessInstructionsMimeType String Mime type of access instructions.
AccessInstructionsContent String Content of an access instructions.
AccessInstructionsFromSourceSystem Boolean Indicates whether data of an item is derived from a source system or authored by a user.
AccessInstructionsRoles String Roles of Database.
AccessInstructionsRoleMembers String Members whom roles was assigned.
AccessInstructionsTimestamp Datetime Created time of access instructions.
DocumentationType String Type of documentation.
DocumentationId String Id of a documentation.
DocumentationEffectiveRights String Rights a particular documentation has.
DocumentationMimeType String Mime type a documentation.
DocumentationContent String Content of a documentation.
DocumentationFromSourceSystem Boolean Indicates whether data of an item is derived from a source system or authored by a user.
DocumentationRoles String Roles of a documentation.
DocumentationRoleMembers String Members whom roles was assigned.
DocumentationTimestamp Datetime Created time of documentation.
FriendlyName String Name of a friendly name.
FriendlyNameId String Id of a friendly name.
FriendlyNameType String Type of friendly name.
FriendlyNameEffectiveRights String Rights a particular friendly name has.
FriendlyNameFromSourceSystem Boolean Indicates whether data of an item is derived from a source system or authored by a user.
FriendlyNameRoles String Roles of friendly name.
FriendlyNameRoleMembers String Members whom roles was assigned.
FriendlyNameTimestamp Datetime Created time of friendly name.
Experts String Check items where the data source expert matches the search term.
Description String Description of databases.
Tags String Tags available in databases.
Facets String A comma separated field names to facet the results on.
View String Name of the view the client wants to see.
HasTags Boolean Check items that have a tag.
HasPreviews Boolean Check items that contain a preview.
HasDocumentation Boolean Check items that contain documentation.
HasTableDataProfiles Boolean Check items that have a table profile.
HasColumnsDataProfiles Boolean Check items that have a columns data profile.
HasDescription Boolean Check items that have a description.


SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
LastRegisteredTime Date Date and time when the metadata was registered.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839