"use strict";(self.webpackChunknoco_docs=self.webpackChunknoco_docs||[]).push([[5413],{3905:(e,t,a)=>{a.d(t,{Zo:()=>u,kt:()=>g});var n=a(67294);function r(e,t,a){return t in e?Object.defineProperty(e,t,{value:a,enumerable:!0,configurable:!0,writable:!0}):e[t]=a,e}function i(e,t){var a=Object.keys(e);if(Object.getOwnPropertySymbols){var n=Object.getOwnPropertySymbols(e);t&&(n=n.filter((function(t){return Object.getOwnPropertyDescriptor(e,t).enumerable}))),a.push.apply(a,n)}return a}function o(e){for(var t=1;t<arguments.length;t++){var a=null!=arguments[t]?arguments[t]:{};t%2?i(Object(a),!0).forEach((function(t){r(e,t,a[t])})):Object.getOwnPropertyDescriptors?Object.defineProperties(e,Object.getOwnPropertyDescriptors(a)):i(Object(a)).forEach((function(t){Object.defineProperty(e,t,Object.getOwnPropertyDescriptor(a,t))}))}return e}function c(e,t){if(null==e)return{};var a,n,r=function(e,t){if(null==e)return{};var a,n,r={},i=Object.keys(e);for(n=0;n<i.length;n++)a=i[n],t.indexOf(a)>=0||(r[a]=e[a]);return r}(e,t);if(Object.getOwnPropertySymbols){var i=Object.getOwnPropertySymbols(e);for(n=0;n<i.length;n++)a=i[n],t.indexOf(a)>=0||Object.prototype.propertyIsEnumerable.call(e,a)&&(r[a]=e[a])}return r}var s=n.createContext({}),l=function(e){var t=n.useContext(s),a=t;return e&&(a="function"==typeof e?e(t):o(o({},t),e)),a},u=function(e){var t=l(e.components);return n.createElement(s.Provider,{value:t},e.children)},p="mdxType",d={inlineCode:"code",wrapper:function(e){var t=e.children;return n.createElement(n.Fragment,{},t)}},m=n.forwardRef((function(e,t){var a=e.components,r=e.mdxType,i=e.originalType,s=e.parentName,u=c(e,["components","mdxType","originalType","parentName"]),p=l(a),m=r,g=p["".concat(s,".").concat(m)]||p[m]||d[m]||i;return a?n.createElement(g,o(o({ref:t},u),{},{components:a})):n.createElement(g,o({ref:t},u))}));function g(e,t){var a=arguments,r=t&&t.mdxType;if("string"==typeof e||r){var i=a.length,o=new Array(i);o[0]=m;var c={};for(var s in t)hasOwnProperty.call(t,s)&&(c[s]=t[s]);c.originalType=e,c[p]="string"==typeof e?e:r,o[1]=c;for(var l=2;l<i;l++)o[l]=a[l];return n.createElement.apply(null,o)}return n.createElement.apply(null,a)}m.displayName="MDXCreateElement"},6314:(e,t,a)=>{a.r(t),a.d(t,{assets:()=>s,contentTitle:()=>o,default:()=>d,frontMatter:()=>i,metadata:()=>c,toc:()=>l});var n=a(87462),r=(a(67294),a(3905));const i={title:"Data Sources",description:"NocoDB Data-Source sync, access control & re-config"},o=void 0,c={unversionedId:"setup-and-usages/meta-management",id:"version-0.109.7/setup-and-usages/meta-management",title:"Data Sources",description:"NocoDB Data-Source sync, access control & re-config",source:"@site/versioned_docs/version-0.109.7/030.setup-and-usages/240.meta-management.md",sourceDirName:"030.setup-and-usages",slug:"/setup-and-usages/meta-management",permalink:"/0.109.7/setup-and-usages/meta-management",draft:!1,editUrl:"https://github.com/nocodb/nocodb/tree/develop/packages/noco-docs/docs/versioned_docs/version-0.109.7/030.setup-and-usages/240.meta-management.md",tags:[],version:"0.109.7",sidebarPosition:240,frontMatter:{title:"Data Sources",description:"NocoDB Data-Source sync, access control & re-config"},sidebar:"tutorialSidebar",previous:{title:"Team & Auth",permalink:"/0.109.7/setup-and-usages/team-and-auth"},next:{title:"Audit",permalink:"/0.109.7/setup-and-usages/audit"}},s={},l=[{value:"Overview",id:"overview",level:2},{value:"Accessing Data Sources",id:"accessing-data-sources",level:2},{value:"Sync Metadata",id:"sync-metadata",level:2},{value:"UI Access Control",id:"ui-access-control",level:2},{value:"ERD",id:"erd",level:2},{value:"Junction table names within ERD",id:"junction-table-names-within-erd",level:3},{value:"Edit external database configuration parameters",id:"edit-external-database-configuration-parameters",level:2},{value:"Unlink data source",id:"unlink-data-source",level:2},{value:"Data source visibility",id:"data-source-visibility",level:2}],u={toc:l},p="wrapper";function d(e){let{components:t,...a}=e;return(0,r.kt)(p,(0,n.Z)({},u,a,{components:t,mdxType:"MDXLayout"}),(0,r.kt)("h2",{id:"overview"},"Overview"),(0,r.kt)("p",null,(0,r.kt)("inlineCode",{parentName:"p"},"Data Sources")," sub-menu includes "),(0,r.kt)("ul",null,(0,r.kt)("li",{parentName:"ul"},"Database Metadata"),(0,r.kt)("li",{parentName:"ul"},"UI Access Control"),(0,r.kt)("li",{parentName:"ul"},"ERD"),(0,r.kt)("li",{parentName:"ul"},"Add/Remove new data source"),(0,r.kt)("li",{parentName:"ul"},"Edit existing data source configuration"),(0,r.kt)("li",{parentName:"ul"},"Edit data source visibility options  ")),(0,r.kt)("p",null,"Note that, currently only one external data source can be added per project."),(0,r.kt)("h2",{id:"accessing-data-sources"},"Accessing Data Sources"),(0,r.kt)("p",null,"To access it, click the down arrow button next to Project Name on the top left side, then select ",(0,r.kt)("inlineCode",{parentName:"p"},"Team & Settings")," and clicking ",(0,r.kt)("inlineCode",{parentName:"p"},"Data Sources"),"."),(0,r.kt)("img",{width:"322",alt:"image",src:"https://user-images.githubusercontent.com/35857179/194856648-67936db0-ee4d-4060-be3d-af9f86ef8fc6.png"}),(0,r.kt)("p",null,(0,r.kt)("img",{parentName:"p",src:"https://user-images.githubusercontent.com/35857179/219833316-1fb234f0-583f-4ab8-b8d7-a6e249e7cd97.png",alt:"image"})),(0,r.kt)("h2",{id:"sync-metadata"},"Sync Metadata"),(0,r.kt)("p",null,"Go to ",(0,r.kt)("inlineCode",{parentName:"p"},"Data Sources"),", click ",(0,r.kt)("inlineCode",{parentName:"p"},"Sync Metadata"),", you can see your metadata sync status. If it is out of sync, you can sync the schema. See ",(0,r.kt)("a",{parentName:"p",href:"/0.109.7/setup-and-usages/sync-schema"},"Sync Schema")," for more."),(0,r.kt)("p",null,(0,r.kt)("img",{parentName:"p",src:"https://user-images.githubusercontent.com/35857179/219833485-3bcaa6ec-88bc-47cc-b938-5abb4835dc31.png",alt:"image"})),(0,r.kt)("h2",{id:"ui-access-control"},"UI Access Control"),(0,r.kt)("p",null,"Go to ",(0,r.kt)("inlineCode",{parentName:"p"},"Data Sources"),", click ",(0,r.kt)("inlineCode",{parentName:"p"},"UI ACL"),", you can control the access to each table by roles. "),(0,r.kt)("p",null,(0,r.kt)("img",{parentName:"p",src:"https://user-images.githubusercontent.com/35857179/219833072-20e9f4ad-fd1c-4e96-9112-6edda1447ec6.png",alt:"image"})),(0,r.kt)("h2",{id:"erd"},"ERD"),(0,r.kt)("p",null,"Go to ",(0,r.kt)("inlineCode",{parentName:"p"},"Data Sources"),", click ",(0,r.kt)("inlineCode",{parentName:"p"},"ERD"),", you can see the ERD of your database."),(0,r.kt)("p",null,(0,r.kt)("img",{parentName:"p",src:"https://user-images.githubusercontent.com/35857179/219832288-f6266544-a259-4667-95d9-0e5ce7ac5d27.png",alt:"image"})),(0,r.kt)("h3",{id:"junction-table-names-within-erd"},"Junction table names within ERD"),(0,r.kt)("ul",null,(0,r.kt)("li",{parentName:"ul"},"Enable ",(0,r.kt)("inlineCode",{parentName:"li"},"Show M2M Tables")," within ",(0,r.kt)("inlineCode",{parentName:"li"},"Project Settings")," menu"),(0,r.kt)("li",{parentName:"ul"},"Double click on ",(0,r.kt)("inlineCode",{parentName:"li"},"Show Columns")," to see additional checkboxes get enabled.",(0,r.kt)("ul",{parentName:"li"},(0,r.kt)("li",{parentName:"ul"},"Enabling which you should be able to see junction tables and their table names.")))),(0,r.kt)("p",null,(0,r.kt)("img",{parentName:"p",src:"https://user-images.githubusercontent.com/35857179/219832436-9c1311c3-854c-4b31-9c94-8035dfba2a2b.png",alt:"image"})),(0,r.kt)("h2",{id:"edit-external-database-configuration-parameters"},"Edit external database configuration parameters"),(0,r.kt)("p",null,"Go to ",(0,r.kt)("inlineCode",{parentName:"p"},"Data Sources"),", click ",(0,r.kt)("inlineCode",{parentName:"p"},"Edit"),", you can re-configure database credentials.",(0,r.kt)("br",{parentName:"p"}),"\n","Please make sure database configuration parameters are valid. Any incorrect parameters could lead to schema loss!"),(0,r.kt)("p",null,(0,r.kt)("img",{parentName:"p",src:"https://user-images.githubusercontent.com/35857179/219832592-14209cbf-d980-4e14-9a59-bda1b778a74e.png",alt:"image"})),(0,r.kt)("h2",{id:"unlink-data-source"},"Unlink data source"),(0,r.kt)("p",null,"Go to ",(0,r.kt)("inlineCode",{parentName:"p"},"Data Sources"),", click ",(0,r.kt)("inlineCode",{parentName:"p"},"Delete")," against the data source that you wish to un-link."),(0,r.kt)("p",null,(0,r.kt)("img",{parentName:"p",src:"https://user-images.githubusercontent.com/35857179/219832810-a3e9ed88-f732-4f30-9228-ff782be0b9d6.png",alt:"image"})),(0,r.kt)("h2",{id:"data-source-visibility"},"Data source visibility"),(0,r.kt)("p",null,"Go to ",(0,r.kt)("inlineCode",{parentName:"p"},"Data Sources"),", toggle ",(0,r.kt)("inlineCode",{parentName:"p"},"Radio-button")," against the data source that you wish to hide/un-hide."),(0,r.kt)("p",null,(0,r.kt)("img",{parentName:"p",src:"https://user-images.githubusercontent.com/35857179/219832914-f485099c-423f-4df8-bf00-b509288efe6d.png",alt:"image"})))}d.isMDXComponent=!0}}]);