PROVIDERSETTINGS

# PROVIDERSETTINGS - Primary Keys: `rowid

Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `PROVIDERSETTINGS` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ABBREVIATION` | `varchar2(30)` | Abbreviation | ☐ | Abbreviation. | | `CLOUD_URL` | `varchar2` | Cloud URL | ☐ | | | `COMMERCIAL_NAME_DD_HMXP` | `varchar2` | | ☐ | | | `COMMERCIAL_NAME` | `varchar2` | Commercial Nalangme | ☑ | | | `COMMUNITY_EDITION` | `char` | Is Community Edition | ☐ | Is application software offered for free? | | `DESCRIPTION_HMXP` | `varchar2` | | ☐ | | | `DESCRIPTION_MD` | `varchar2` | | ☐ | | | `DISPLAY_NAME_HMXP` | `varchar2` | | ☐ | | | `DISPLAY_NAME_MD` | `varchar2` | | ☐ | | | `DOCUMENTATION_URL` | `varchar2(4000)` | Documentation (URL) | ☐ | Documentation URL. | | `DOCUMENTATION` | `varchar2(32767)` | Documentation | ☐ | Documentation. | | `DOWNLOAD_IMPLEMENTATION_URL` | `varchar2(4000)` | Download Implementation URL | ☐ | Download URL for implementation. | | `FORUM_TAG` | `varchar2` | Forum Tag | ☐ | | | `FUNCTIONAL_DOCUMENTATION_URL` | `varchar2(4000)` | Functional Documentation URL | ☐ | Functional documentation URL. | | `FUNCTIONAL_SUPPORT_DISCORD_COMMUNITY` | `varchar2(60)` | Functional Support Discord Community | ☐ | Functional support discourse community. | | `FUNCTIONAL_SUPPORT_EMAIL_ADDRESS` | `varchar2(60)` | Functional Support Email Address | ☐ | Functional support email address. | | `FUNCTIONAL_SUPPORT_PHONE_NUMBER` | `varchar2(60)` | Functional Support Phone Number | ☐ | Functional support phone number. | | `FUNCTIONAL_SUPPORT_URL` | `varchar2(240)` | Functional Support URL | ☐ | Functional support URL. | | `IS_CATALOG_USED_IN_FULL_QUALIFIED_NAME` | `char` | Is Catalog Used in Full Qualified Name | ☐ | Whether the catalog name is used in constructing the full qualified name. | | `IS_SCHEMA_USED_IN_FULL_QUALIFIED_NAME` | `char` | Is Schema Used in Full Qualified Name | ☐ | Whether the schema name is used in constructing the full qualified name. | | `IS_SERVICE_PROVIDER_FLAG` | `char` | Is Service Provider? | ☐ | Is the connector a service connector? | | `LANGUAGE_CODE_HMXP` | `varchar2` | | ☑ | | | `LANGUAGE_CODE_MD` | `varchar2` | | ☑ | | | `MAIN_CATEGORY` | `varchar2(240)` | Main Category | ☐ | Main category. | | `NAME` | `varchar2` | | ☑ | | | `PARTITION_CODE_COLUMN_NAME` | `varchar2(240)` | Partition Code Column Name | ☐ | Name of the partition code column. | | `PARTITION_INFO_SUPPORTS_PARTITIONS` | `char` | Supports Partitions | ☐ | Whether the connector supports partitions. | | `PARTITION_LABEL_SINGULAR` | `varchar2(240)` | Partition Label Singular | ☐ | Partition label in singular form. | | `PRODUCTION_USE_ALLOWED` | `char` | Production Use Allowed | ☐ | Is production use allowed? | | `PROVIDER_FILE_NAME_PREFIX_HMXP` | `varchar2` | | ☑ | | | `PROVIDER_FILE_NAME_PREFIX_MD` | `varchar2` | | ☐ | | | `PUBLIC_DATA` | `char` | Is Public Data? | ☐ | Is the data offered publicly? | | `RUN_ID` | `guid` | | ☑ | | | `SHORT_NAME` | `varchar2(240)` | Short Name | ☐ | Short name. | | `STRING_COMPARISON_IS_CASE_SENSITIVE` | `char` | String Comparison is Case-Sensitive | ☐ | Whether the connector matches text case-sensitive. | | `TECHNICAL_DOCUMENTATION_URL` | `varchar2(4000)` | Technical Documentation (URL) | ☐ | Technical documentation URL. | | `TECHNICAL_SUPPORT_DISCORD_COMMUNITY` | `varchar2(60)` | Technical Support Discord Community | ☐ | Technical support discourse community. | | `TECHNICAL_SUPPORT_EMAIL_ADDRESS` | `varchar2(60)` | Technical Support Email Address | ☐ | Technical support email address. | | `TECHNICAL_SUPPORT_PHONE_NUMBER` | `varchar2(60)` | Technical Support Phone Number | ☐ | Technical support phone number. | | `TECHNICAL_SUPPORT_URL` | `varchar2(240)` | Technical Support URL | ☐ | Technical support URL. | | `rowid