1"use strict";(self.webpackChunkdataedo=self.webpackChunkdataedo||[]).push([["1093"],{88552:function(a,o,s){s.r(o),s.d(o,{frontMatter:()=>c,default:()=>p,toc:()=>m,metadata:()=>e,assets:()=>l,contentTitle:()=>d});var e=JSON.parse('{"id":"data-sources/databases/amazon-rds/amazon-aurora/amazon-aurora-postgresql/connecting-to-amazon-aurora-postgressql","title":"Connecting to Amazon Aurora PostgreSQL","description":"","source":"@site/docs/data-sources/databases/amazon-rds/amazon-aurora/amazon-aurora-postgresql/connecting-to-amazon-aurora-postgressql.mdx","sourceDirName":"data-sources/databases/amazon-rds/amazon-aurora/amazon-aurora-postgresql","slug":"/data-sources/databases/amazon-rds/amazon-aurora/amazon-aurora-postgresql/connecting-to-amazon-aurora-postgressql","permalink":"/data-sources/databases/amazon-rds/amazon-aurora/amazon-aurora-postgresql/connecting-to-amazon-aurora-postgressql","draft":false,"unlisted":false,"tags":[],"version":"current","lastUpdatedAt":1783588744000,"frontMatter":{"title":"Connecting to Amazon Aurora PostgreSQL","description":"","slug":"/data-sources/databases/amazon-rds/amazon-aurora/amazon-aurora-postgresql/connecting-to-amazon-aurora-postgressql"},"sidebar":"tutorialSidebar","previous":{"title":"Amazon Aurora PostgreSQL - Automatic Data Lineage","permalink":"/data-sources/databases/amazon-rds/amazon-aurora/amazon-aurora-postgresql/amazon-aurora-postgresql-automatic-data-lineage"},"next":{"title":"Amazon RDS for MariaDB support","permalink":"/data-sources/databases/amazon-rds/amazon-rds-for-mariadb"}}'),t=s(85893),n=s(50065),r=s(25185),i=s(88046);let c={title:"Connecting to Amazon Aurora PostgreSQL",description:"",slug:"/data-sources/databases/amazon-rds/amazon-aurora/amazon-aurora-postgresql/connecting-to-amazon-aurora-postgressql"},d=void 0,l={},m=[{value:"How to connect",id:"how-to-connect",level:2},{value:"Saving password",id:"saving-password",level:2},{value:"Importing schema",id:"importing-schema",level:2},{value:"Amazon Aurora support",id:"amazon-aurora-support",level:2}];function h(a){let o={a:"a",h2:"h2",li:"li",p:"p",strong:"strong",ul:"ul",...(0,n.a)(),...a.components};return(0,t.jsxs)(t.Fragment,{children:[(0,t.jsx)(r.Z,{src:"https://www.youtube.com/embed/KN8MJok3P6w"}),"\n",(0,t.jsxs)(o.p,{children:["To connect to Amazon Aurora, follow the new documentation by clicking ",(0,t.jsx)(o.strong,{children:"Add documentation"})," and choosing ",(0,t.jsx)(o.strong,{children:"Database connection"}),"."]}),"\n",(0,t.jsx)(i.Z,{src:"https://dataedo.com/asset/img/docs/8_0/add_database_connection.png",width:"60%",alt:"Connection to SQL Server"}),"\n",(0,t.jsxs)(o.p,{children:["On the connection screen choose ",(0,t.jsx)(o.strong,{children:"Amazon Aurora PostgreSQL"})," as ",(0,t.jsx)(o.strong,{children:"DBMS"}),"."]}),"\n",(0,t.jsx)(o.p,{children:"Provide database connection details:"}),"\n",(0,t.jsxs)(o.ul,{children:["\n",(0,t.jsxs)(o.li,{children:["\n",(0,t.jsxs)(o.p,{children:[(0,t.jsx)(o.strong,{children:"Host"})," - provide a host where the database is located. E.g. ",(0,t.jsx)(o.strong,{children:"server17"}),", ",(0,t.jsx)(o.strong,{children:"server17.ourdomain.com"})," or ",(0,t.jsx)(o.strong,{children:"192.168.0.37"}),"."]}),"\n"]}),"\n",(0,t.jsxs)(o.li,{children:["\n",(0,t.jsxs)(o.p,{children:[(0,t.jsx)(o.strong,{children:"Port"})," - change the default PostgreSQL instance if required."]}),"\n"]}),"\n",(0,t.jsxs)(o.li,{children:["\n",(0,t.jsxs)(o.p,{children:[(0,t.jsx)(o.strong,{children:"User"})," and ",(0,t.jsx)(o.strong,{children:"password"})," - provide your username and password."]}),"\n"]}),"\n",(0,t.jsxs)(o.li,{children:["\n",(0,t.jsxs)(o.p,{children:[(0,t.jsx)(o.strong,{children:"Database"})," - type in the database name or click ",(0,t.jsx)(o.strong,{children:"[...]"})," and choose it from the list."]}),"\n"]}),"\n"]}),"\n",(0,t.jsx)(o.h2,{id:"how-to-connect",children:"How to connect"}),"\n",(0,t.jsx)(i.Z,{src:"https://dataedo.com/asset/img/docs/8_0/aurorapostgresql_connection_form.png",width:"60%",alt:"Connection to SQL"}),"\n",(0,t.jsxs)(o.p,{children:["Here is a comparison with connection details in ",(0,t.jsx)(o.strong,{children:"pgAdmin"}),"."]}),"\n",(0,t.jsx)(i.Z,{src:"https://dataedo.com/asset/img/docs/8_0/aurorapostgresql_connection_pgadmin1.png",width:"60%",alt:"Connection to SQL Server"}),"\n",(0,t.jsx)(i.Z,{src:"https://dataedo.com/asset/img/docs/8_0/postgresql_connection_pgadmin2.png",width:"60%",alt:"Connection to SQL Server"}),"\n",(0,t.jsx)(o.h2,{id:"saving-password",children:"Saving password"}),"\n",(0,t.jsxs)(o.p,{children:["You can save the password for later connections by checking the ",(0,t.jsx)(o.strong,{children:"Save password"})," option. Passwords are saved in the repository database."]}),"\n",(0,t.jsx)(o.h2,{id:"importing-schema",children:"Importing schema"}),"\n",(0,t.jsxs)(o.p,{children:["When the connection is successful, Dataedo will read objects and show a list of objects found. You can ",(0,t.jsx)(o.a,{href:"/data-catalog/building-catalog/sources-in-desktop/scope/choosing-objects-to-import",children:"choose which objects to import"}),". You can also use ",(0,t.jsx)(o.a,{href:"/data-catalog/building-catalog/sources-in-desktop/scope/advanced-import-filter",children:"advanced filter"})," to narrow down the list of objects."]}),"\n",(0,t.jsx)(i.Z,{src:"https://dataedo.com/asset/img/docs/8_0/mysql_import_schema_objectlist.png",width:"60%",alt:"Objects to import"}),"\n",(0,t.jsxs)(o.p,{children:["Confirm the list of objects to import by clicking ",(0,t.jsx)(o.strong,{children:"Next"}),"."]}),"\n",(0,t.jsx)(o.p,{children:"The next screen will allow you to change the default name of the documentation under which your schema will be visible in the Dataedo repository."}),"\n",(0,t.jsx)(i.Z,{src:"https://dataedo.com/asset/img/docs/8_0/auroramysql_import_schema_doc_name.png",width:"60%",alt:"Change title"}),"\n",(0,t.jsxs)(o.p,{children:["Click ",(0,t.jsx)(o.strong,{children:"Import"})," to start the import."]}),"\n",(0,t.jsx)(i.Z,{src:"https://dataedo.com/asset/img/docs/8_0/mysql_importing.png",width:"60%",alt:"Importing documentation"}),"\n",(0,t.jsxs)(o.p,{children:["When done, close the import window with the ",(0,t.jsx)(o.strong,{children:"Finish"})," button."]}),"\n",(0,t.jsx)(i.Z,{src:"https://dataedo.com/asset/img/docs/8_0/import_succeeded.png",width:"60%",alt:"Import succeeded"}),"\n",(0,t.jsx)(o.p,{children:"Your database schema has been imported to new documentation in the repository."}),"\n",(0,t.jsx)(i.Z,{src:"https://dataedo.com/asset/img/docs/8_0/aurorapostgresql_new_documentation.png",width:"60%",alt:"Imported database schema"}),"\n",(0,t.jsx)(o.h2,{id:"amazon-aurora-support",children:"Amazon Aurora support"}),"\n",(0,t.jsxs)(o.p,{children:["Learn more about ",(0,t.jsx)(o.a,{href:"/data-sources/databases/amazon-rds/amazon-aurora/amazon-aurora-mysql/amazon-aurora-mysql",children:"Amazon Aurora"})," in Dataedo."]})]})}function p(a={}){let{wrapper:o}={...(0,n.a)(),...a.components};return o?(0,t.jsx)(o,{...a,children:(0,t.jsx)(h,{...a})}):h(a)}},25185:function(a,o,s){s.d(o,{Z:()=>t});var e=s(85893);function t({src:a}){return(0,e.jsx)("div",{style:{display:"flex",justifyContent:"center",alignItems:"center"},children:(0,e.jsx)("iframe",{width:"80%",height:"315",src:a,title:"YouTube video player",allow:"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture",allowFullScreen:!0})})}}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.