1"use strict";(self.webpackChunkdataedo=self.webpackChunkdataedo||[]).push([["16945"],{15717:function(e,s,n){n.r(s),n.d(s,{frontMatter:()=>d,default:()=>h,toc:()=>o,metadata:()=>a,assets:()=>l,contentTitle:()=>r});var a=JSON.parse('{"id":"data-sources/databases/sap-databases/sap-ase-sybase/sap-ase-sybase-odbc","title":"SAP ASE (Sybase) support (ODBC)","description":"","source":"@site/docs/data-sources/databases/sap-databases/sap-ase-sybase/sap-ase-sybase-odbc.md","sourceDirName":"data-sources/databases/sap-databases/sap-ase-sybase","slug":"/docs/documenting-technology/supported-databases/sap-ase-sybase-odbc","permalink":"/docs/documenting-technology/supported-databases/sap-ase-sybase-odbc","draft":false,"unlisted":false,"tags":[],"version":"current","lastUpdatedAt":1783588744000,"frontMatter":{"title":"SAP ASE (Sybase) support (ODBC)","description":"","slug":"/docs/documenting-technology/supported-databases/sap-ase-sybase-odbc"},"sidebar":"tutorialSidebar","previous":{"title":"SAP ASE (native)","permalink":"/docs/documenting-technology/supported-databases/sap-ase-sybase-native"},"next":{"title":"SAP HANA","permalink":"/data-sources/databases/sap-databases/sap-hana/"}}'),i=n(85893),t=n(50065);n(88046);let d={title:"SAP ASE (Sybase) support (ODBC)",description:"",slug:"/docs/documenting-technology/supported-databases/sap-ase-sybase-odbc"},r=void 0,l={},o=[{value:"Tested ODBC Driver: Devart ODBC for ASE [Paid]",id:"tested-odbc-driver-devart-odbc-for-ase-paid",level:2},{value:"Supported schema elements and metadata",id:"supported-schema-elements-and-metadata",level:3},{value:"Data Profiling",id:"data-profiling",level:3},{value:"Data Lineage",id:"data-lineage",level:3},{value:"Limitations",id:"limitations",level:3},{value:"ODBC Driver",id:"odbc-driver",level:3},{value:"Learn more",id:"learn-more",level:2}];function c(e){let s={a:"a",admonition:"admonition",h2:"h2",h3:"h3",li:"li",p:"p",strong:"strong",ul:"ul",...(0,t.a)(),...e.components};return(0,i.jsxs)(i.Fragment,{children:[(0,i.jsx)(s.admonition,{type:"infotoast",children:(0,i.jsxs)(s.p,{children:["SAP ASE (Sybase) is currently ",(0,i.jsx)("strong",{children:"not officially supported"}),". Connection is possible with generic ",(0,i.jsx)("strong",{children:"ODBC"})," driver. Metadata returned depends on driver version and provider."]})}),"\n",(0,i.jsxs)(s.p,{children:["We have tested and successfully connected to and imported metadata from ",(0,i.jsx)(s.strong,{children:"SAP ASE (Sybase)"})," with ODBC drivers listed below. It is highly likely it will work with other drivers as well."]}),"\n",(0,i.jsx)(s.h2,{id:"tested-odbc-driver-devart-odbc-for-ase-paid",children:"Tested ODBC Driver: Devart ODBC for ASE [Paid]"}),"\n",(0,i.jsx)(s.p,{children:"We have tested and successfully connected to and imported metadata in the following environment:"}),"\n",(0,i.jsxs)(s.p,{children:[(0,i.jsx)(s.strong,{children:"ODBC version:"})," 1.4.8 64-bit"]}),"\n",(0,i.jsxs)(s.p,{children:[(0,i.jsx)(s.strong,{children:"SAP ASE (Sybase) version:"})," 16.0"]}),"\n",(0,i.jsx)(s.h3,{id:"supported-schema-elements-and-metadata",children:"Supported schema elements and metadata"}),"\n",(0,i.jsx)(s.p,{children:"Dataedo reads the following metadata from SAP ASE (Sybase) databases."}),"\n",(0,i.jsxs)(s.ul,{children:["\n",(0,i.jsxs)(s.li,{children:["\n",(0,i.jsx)(s.p,{children:"Tables"}),"\n",(0,i.jsxs)(s.ul,{children:["\n",(0,i.jsxs)(s.li,{children:["\n",(0,i.jsx)(s.p,{children:"Columns"}),"\n",(0,i.jsxs)(s.ul,{children:["\n",(0,i.jsxs)(s.li,{children:["\n",(0,i.jsx)(s.p,{children:"Data type with length"}),"\n"]}),"\n",(0,i.jsxs)(s.li,{children:["\n",(0,i.jsx)(s.p,{children:"Nullable"}),"\n"]}),"\n"]}),"\n"]}),"\n"]}),"\n"]}),"\n",(0,i.jsxs)(s.li,{children:["\n",(0,i.jsx)(s.p,{children:"Views"}),"\n",(0,i.jsxs)(s.ul,{children:["\n",(0,i.jsxs)(s.li,{children:["\n",(0,i.jsx)(s.p,{children:"Columns"}),"\n",(0,i.jsxs)(s.ul,{children:["\n",(0,i.jsxs)(s.li,{children:["\n",(0,i.jsx)(s.p,{children:"Data type with length"}),"\n"]}),"\n",(0,i.jsxs)(s.li,{children:["\n",(0,i.jsx)(s.p,{children:"Nullable"}),"\n"]}),"\n"]}),"\n"]}),"\n"]}),"\n"]}),"\n"]}),"\n",(0,i.jsx)(s.h3,{id:"data-profiling",children:"Data Profiling"}),"\n",(0,i.jsx)(s.p,{children:"Dataedo does not support profiling in SAP ASE."}),"\n",(0,i.jsx)(s.h3,{id:"data-lineage",children:"Data Lineage"}),"\n",(0,i.jsx)(s.p,{children:"Dataedo does not support data lineage in SAP ASE."}),"\n",(0,i.jsx)(s.h3,{id:"limitations",children:"Limitations"}),"\n",(0,i.jsxs)(s.p,{children:["The following schema/metadata elements currently are ",(0,i.jsx)(s.strong,{children:"not supported"}),":"]}),"\n",(0,i.jsxs)(s.ul,{children:["\n",(0,i.jsxs)(s.li,{children:["\n",(0,i.jsx)(s.p,{children:"Function/Procedure"}),"\n"]}),"\n",(0,i.jsxs)(s.li,{children:["\n",(0,i.jsx)(s.p,{children:"View script"}),"\n"]}),"\n",(0,i.jsxs)(s.li,{children:["\n",(0,i.jsx)(s.p,{children:"Trigger"}),"\n"]}),"\n",(0,i.jsxs)(s.li,{children:["\n",(0,i.jsx)(s.p,{children:"Foreign keys"}),"\n"]}),"\n",(0,i.jsxs)(s.li,{children:["\n",(0,i.jsx)(s.p,{children:"Primary keys"}),"\n"]}),"\n",(0,i.jsxs)(s.li,{children:["\n",(0,i.jsx)(s.p,{children:"Unique constraints"}),"\n"]}),"\n"]}),"\n",(0,i.jsx)(s.h3,{id:"odbc-driver",children:"ODBC Driver"}),"\n",(0,i.jsx)(s.p,{children:(0,i.jsx)(s.a,{href:"https://www.devart.com/odbc/ase/",children:"Download Devart for ASE ODBC driver"})}),"\n",(0,i.jsx)(s.p,{children:(0,i.jsx)(s.a,{href:"https://www.devart.com/odbc/ase/docs/driver_configuration_and_conne.htm",children:"ODBC configuration"})}),"\n",(0,i.jsx)(s.h2,{id:"learn-more",children:"Learn more"}),"\n",(0,i.jsx)(s.p,{children:(0,i.jsx)(s.a,{href:"/docs/documenting-technology/generic-connectors/connecting-to-database-with-odbc",children:"Connect to SAP ASE (Sybase)"})})]})}function h(e={}){let{wrapper:s}={...(0,t.a)(),...e.components};return s?(0,i.jsx)(s,{...e,children:(0,i.jsx)(c,{...e})}):c(e)}}}]);
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.