"use strict";(self.webpackChunknewoaks_help=self.webpackChunknewoaks_help||[]).push([[993],{3049:(e,t,s)=>{s.r(t),s.d(t,{assets:()=>c,contentTitle:()=>d,default:()=>h,frontMatter:()=>i,metadata:()=>r,toc:()=>l});const r=JSON.parse('{"id":"getting-started/set-up-custom-db","title":"Set Up Custom Database","description":"1. In the , enter your project and click the Settings button in the top right corner.","source":"@site/userGuide/getting-started/009.set-up-custom-db.md","sourceDirName":"getting-started","slug":"/getting-started/set-up-custom-db","permalink":"/guides/user/getting-started/set-up-custom-db","draft":false,"unlisted":false,"tags":[],"version":"current","sidebarPosition":9,"frontMatter":{"sidebar_position":9},"sidebar":"sidebar","previous":{"title":"CRM import data","permalink":"/guides/user/getting-started/crm-import-data"},"next":{"title":"Set Up Text to report Database","permalink":"/guides/user/getting-started/report-db"}}');var n=s(4848),a=s(8453),o=s(8175);const i={sidebar_position:9},d="Set Up Custom Database",c={},l=[{value:"Use Custom Database",id:"use-custom-database",level:2}];function u(e){const t={a:"a",code:"code",h1:"h1",h2:"h2",header:"header",img:"img",li:"li",ol:"ol",p:"p",pre:"pre",strong:"strong",ul:"ul",...(0,a.R)(),...e.components};return(0,n.jsxs)(n.Fragment,{children:[(0,n.jsx)(t.header,{children:(0,n.jsx)(t.h1,{id:"set-up-custom-database",children:"Set Up Custom Database"})}),"\n",(0,n.jsxs)(t.ol,{children:["\n",(0,n.jsxs)(t.li,{children:["In the ",(0,n.jsx)(o.A,{}),", enter your project and click the ",(0,n.jsx)(t.strong,{children:"Settings"})," button in the top right corner."]}),"\n",(0,n.jsxs)(t.li,{children:["Click the ",(0,n.jsx)(t.strong,{children:"Database"})," tab."]}),"\n",(0,n.jsx)(t.li,{children:"In the Database Type section, you can select Custom DB, and then select the database type from the dropdown menu. Support MySQL, PostgreSQL, SQL Server and Oracle."}),"\n"]}),"\n",(0,n.jsx)(t.p,{children:(0,n.jsx)(t.img,{alt:"set custom db",src:s(5964).A+"",width:"1011",height:"635"})}),"\n",(0,n.jsxs)(t.ol,{start:"4",children:["\n",(0,n.jsx)(t.li,{children:"You can configure the custom database connection string."}),"\n"]}),"\n",(0,n.jsxs)(t.ul,{children:["\n",(0,n.jsx)(t.li,{children:"Here's an PostgreSQL example:"}),"\n"]}),"\n",(0,n.jsx)(t.pre,{children:(0,n.jsx)(t.code,{children:"Server=yourPGDBServer;Port=5432;Database=yourDBName;User Id=yourUserName;Password=yourPassword;MaxPoolSize=100;\n"})}),"\n",(0,n.jsxs)(t.ul,{children:["\n",(0,n.jsx)(t.li,{children:"Here's an MySQL example:"}),"\n"]}),"\n",(0,n.jsx)(t.pre,{children:(0,n.jsx)(t.code,{children:"Server=yourMySQLDBServer;Port=3306;Database=yourDBName;User Id=yourUserName;Password=yourPassword;MaxPoolSize=100;\n"})}),"\n",(0,n.jsxs)(t.ul,{children:["\n",(0,n.jsx)(t.li,{children:"Here's an SQL Server example:"}),"\n"]}),"\n",(0,n.jsx)(t.pre,{children:(0,n.jsx)(t.code,{children:"Server=yourSQLServerDBServer,1433;Database=yourDBName;User Id=yourUserName;Password=yourPassword;TrustServerCertificate=true\n"})}),"\n",(0,n.jsxs)(t.ul,{children:["\n",(0,n.jsx)(t.li,{children:"Here's an Oracle example:"}),"\n"]}),"\n",(0,n.jsx)(t.pre,{children:(0,n.jsx)(t.code,{children:"Server=yourOracleDBServer;Port=1521;Database=yourDBName;User Id=yourUserName;Password=yourPassword;MaxPoolSize=100;\n"})}),"\n",(0,n.jsx)(t.h2,{id:"use-custom-database",children:"Use Custom Database"}),"\n",(0,n.jsx)(t.p,{children:"After setting up the custom database, you can use it in the project.\nSuppose you have a game project and you want to save the game results to a database, you can use the following prompt:"}),"\n",(0,n.jsx)(t.pre,{children:(0,n.jsx)(t.code,{children:"Save game results to the database\n"})}),"\n",(0,n.jsx)(t.h1,{id:"ip-whitelist",children:"IP Whitelist"}),"\n",(0,n.jsxs)(t.p,{children:["For the complete list of IP addresses that can access your custom database, please refer to our ",(0,n.jsx)(t.a,{href:"/developer/webhook/trigger-ip",children:"IP Whitelist documentation"}),"."]})]})}function h(e={}){const{wrapper:t}={...(0,a.R)(),...e.components};return t?(0,n.jsx)(t,{...e,children:(0,n.jsx)(u,{...e})}):u(e)}},5964:(e,t,s)=>{s.d(t,{A:()=>r});const r=s.p+"assets/images/database-set-custom-db-7bf69fbf96e4d338a2f48b5420bcab6c.png"},8175:(e,t,s)=>{s.d(t,{A:()=>n});s(6540);var r=s(4848);function n(){return(0,r.jsx)("code",{children:"EZsite"})}},8453:(e,t,s)=>{s.d(t,{R:()=>o,x:()=>i});var r=s(6540);const n={},a=r.createContext(n);function o(e){const t=r.useContext(a);return r.useMemo((function(){return"function"==typeof e?e(t):{...t,...e}}),[t,e])}function i(e){let t;return t=e.disableParentContext?"function"==typeof e.components?e.components(n):e.components||n:o(e.components),r.createElement(a.Provider,{value:t},e.children)}}}]);