1"use strict";(globalThis.webpackChunkmambu_documentation_site=globalThis.webpackChunkmambu_documentation_site||[]).push([[4166],{721093(e,t,a){a.r(t),a.d(t,{assets:()=>l,contentTitle:()=>o,default:()=>p,frontMatter:()=>s,metadata:()=>n,toc:()=>d});const n=JSON.parse('{"id":"docs/data-adapter","title":"Data Adapter","description":"For Jasper reports to be compatible with Mambu, they must be built considering the structure of Mambu DB.","source":"@site/docs/docs/data-adapter.mdx","sourceDirName":"docs","slug":"/docs/data-adapter","permalink":"/docs/data-adapter","draft":false,"unlisted":false,"tags":[{"inline":true,"label":"data-adapter","permalink":"/tags/data-adapter"},{"inline":true,"label":"integrations","permalink":"/tags/integrations"},{"inline":true,"label":"data-export","permalink":"/tags/data-export"},{"inline":true,"label":"reporting","permalink":"/tags/reporting"},{"inline":true,"label":"analytics","permalink":"/tags/analytics"}],"version":"current","lastUpdatedAt":1776077175000,"frontMatter":{"id":"data-adapter","title":"Data Adapter","tags":["data-adapter","integrations","data-export","reporting","analytics"],"description":"For Jasper reports to be compatible with Mambu, they must be built considering the structure of Mambu DB."},"sidebar":"primarySidebars","previous":{"title":"Database clone","permalink":"/docs/database-clone"},"next":{"title":"Developer Handbook","permalink":"/docs/developer-handbook"}}');var r=a(474848),i=a(28453);const s={id:"data-adapter",title:"Data Adapter",tags:["data-adapter","integrations","data-export","reporting","analytics"],description:"For Jasper reports to be compatible with Mambu, they must be built considering the structure of Mambu DB."},o=void 0,l={},d=[{value:"Create a connection between Jaspersoft Studio and MySql Server",id:"create-a-connection-between-jaspersoft-studio-and-mysql-server",level:2},{value:"Video Tutorial",id:"video-tutorial",level:2}];function c(e){const t={a:"a",code:"code",h2:"h2",hr:"hr",li:"li",ol:"ol",p:"p",ul:"ul",...(0,i.R)(),...e.components};return(0,r.jsxs)(r.Fragment,{children:[(0,r.jsx)(t.h2,{id:"create-a-connection-between-jaspersoft-studio-and-mysql-server",children:"Create a connection between Jaspersoft Studio and MySql Server"}),"\n",(0,r.jsx)(t.p,{children:"For Jasper reports to be compatible with Mambu, they must be built considering the structure of Mambu DB.\nThis is achieved by having the database as a data source during the development process.\nTo create and configure a Data Adapter:"}),"\n",(0,r.jsxs)(t.ol,{children:["\n",(0,r.jsxs)(t.li,{children:["\n",(0,r.jsx)(t.p,{children:"Go to Jaspersoft Studio, Repository Explorer view"}),"\n"]}),"\n",(0,r.jsxs)(t.li,{children:["\n",(0,r.jsx)(t.p,{children:"Right click on the Data Adapters root node and choose Create Data Adapter"}),"\n"]}),"\n",(0,r.jsxs)(t.li,{children:["\n",(0,r.jsx)(t.p,{children:"Go with the Database JDBC Connection wizard"}),"\n"]}),"\n",(0,r.jsxs)(t.li,{children:["\n",(0,r.jsx)(t.p,{children:"Then as part of the Adaptor configuration:"}),"\n",(0,r.jsxs)(t.ul,{children:["\n",(0,r.jsxs)(t.li,{children:["\n",(0,r.jsx)(t.p,{children:"Name: Set a name for the adapter that relates to the database schema"}),"\n"]}),"\n",(0,r.jsxs)(t.li,{children:["\n",(0,r.jsx)(t.p,{children:"Database Location tab:"}),"\n",(0,r.jsxs)(t.ul,{children:["\n",(0,r.jsxs)(t.li,{children:["\n",(0,r.jsx)(t.p,{children:"JDBC Driver: com.mysql.jdbc.Driver"}),"\n"]}),"\n",(0,r.jsxs)(t.li,{children:["\n",(0,r.jsxs)(t.p,{children:["JDBC Url: jdbc:mysql://[your connection string].\nExample: ",(0,r.jsx)(t.code,{children:"jdbc:mysql://localhost:3306/local_mambu_database"})]}),"\n"]}),"\n",(0,r.jsxs)(t.li,{children:["\n",(0,r.jsx)(t.p,{children:"Username: The username set up during the MySql Server installation"}),"\n"]}),"\n",(0,r.jsxs)(t.li,{children:["\n",(0,r.jsx)(t.p,{children:"Password: The password set up during the MySql Server installation"}),"\n"]}),"\n"]}),"\n"]}),"\n",(0,r.jsxs)(t.li,{children:["\n",(0,r.jsx)(t.p,{children:"Driver Classpath tab:"}),"\n",(0,r.jsxs)(t.ul,{children:["\n",(0,r.jsxs)(t.li,{children:["Add a link to the mysql connector jar file (JDBC Driver for MySQL).\nExample: ",(0,r.jsx)(t.code,{children:"[local_path]/mysql-connector-java-8.0.13-bin.jar"})]}),"\n"]}),"\n"]}),"\n"]}),"\n"]}),"\n"]}),"\n",(0,r.jsx)(t.hr,{}),"\n",(0,r.jsx)(t.h2,{id:"video-tutorial",children:"Video Tutorial"}),"\n",(0,r.jsxs)(t.p,{children:["Check out our video tutorial for creating and configuring a Data Adapter ",(0,r.jsx)(t.a,{href:"https://youtu.be/wvCESSDUO1g",children:"here"}),"."]}),"\n",(0,r.jsx)(t.hr,{})]})}function p(e={}){const{wrapper:t}={...(0,i.R)(),...e.components};return t?(0,r.jsx)(t,{...e,children:(0,r.jsx)(c,{...e})}):c(e)}},28453(e,t,a){a.d(t,{R:()=>s,x:()=>o});var n=a(296540);const r={},i=n.createContext(r);function s(e){const t=n.useContext(i);return n.useMemo(function(){return"function"==typeof e?e(t):{...t,...e}},[t,e])}function o(e){let t;return t=e.disableParentContext?"function"==typeof e.components?e.components(r):e.components||r:s(e.components),n.createElement(i.Provider,{value:t},e.children)}}}]);
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.