SQL Connector. The module includes the following submodules: Data sources historyExport history Learn more about History Data Schema SQL Connector for Jira automatically builds relations between tables and fields in the SQL database. When you upload your Jira data into the SQL database, all tables will be connected in relations based on the logical key field. Thus, users don’t need to relate tables, which is time-consuming manually. View complete data schema Have experience with SQL Connector for Jira? We’d love to hear your thoughts! Please leave us a review on the Marketplace! Leave a review | page | {"name":"page","children":[{"id":"LaKbj75QOBAx01ulqmSIL","params":{"background":{"light":"#ffffff","dark":"#1d2125"},"padding":18,"gap":10},"children":[{"id":"st4YDzTIL2EvYjD3ME-fp","name":"row","children":[{"id":"5LjX8uIX-dxVB6xRbN6FG","name":"column","children":[{"name":"card","templateId":"plain white","params":{"gap":10,"padding":24,"borderRadius":{"all":20,"isIndividualCorners":false,"bbl":0,"bbr":0,"btl":0,"btr":0},"background":"#5C02CF1f","hover":"none","isMediaFullSize":true},"children":[{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"Your Jira Cloud administrator should grant you ","lineHeight":"22px","color":{"type":"solid","light":"#000000","gradient":{"light":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]},"dark":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]}}},"fontSize":15,"fontFamily":"Montserrat, sans-serif"},{"lineHeight":"22px","text":"Administer Jira","fontWeight":700,"color":{"type":"solid","light":"#000000","gradient":{"light":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]},"dark":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]}}},"fontSize":15,"fontFamily":"Montserrat, sans-serif"},{"lineHeight":"22px","text":" permissions to create, edit, view, and export connectors. Users with ","color":{"type":"solid","light":"#000000","gradient":{"light":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]},"dark":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]}}},"fontSize":15,"fontFamily":"Montserrat, sans-serif"},{"lineHeight":"22px","text":"Administer Jira","fontWeight":700,"color":{"type":"solid","light":"#000000","gradient":{"light":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]},"dark":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]}}},"fontSize":15,"fontFamily":"Montserrat, sans-serif"},{"lineHeight":"22px","color":{"type":"solid","light":"#000000","gradient":{"light":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]},"dark":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]}}},"fontSize":15,"text":" permissions always have access to app configurations.","fontFamily":"Montserrat, sans-serif"}],"align":"left"}]},"children":[],"id":"kMDbzXr0ICPnKQ14NTBxy"}],"id":"eUUxZ8XgJ35wRvZwvXbdA"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"uQE5MXVidKi2IpYunFfGA","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"sXVI7pOpu6DbU8VT7_Fd7","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"bxgjSo8L1jmJJ36cQt_o1","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"I0ntxyjZLDY5erDByNi_i","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"ixYi6sLEZ1CQwz1ap5QNL","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1],"gap":10,"minHeight":100,"padding":10,"borderRadius":0}},{"id":"A8C3QZSlkABHkjc_5ErCh","name":"row","children":[{"id":"hRS0QxgGb_bg9ZAW4hNj6","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"1dlz6ChsiIno54n8hQCNZ","name":"column","children":[{"name":"button","params":{"templateId":"regular outline","label":"Try it free","size":"large","shape":"rounded","alignment":"center","states":{"idle":{"colors":{"outline":{"type":"solid","light":"#FFC067"},"label":{"type":"solid","light":"#000000"}}},"hover":{"colors":{"outline":{"type":"solid","light":"#393A3A"}}}},"link":{"value":"https://marketplace.atlassian.com/apps/1230676/sql-connector-for-jira?hosting=cloud&tab=overview","target":"_blank","type":"link"}},"children":[],"id":"TpldURiRiWmE6jPqFU1rZ"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"y14JZxboUWbAM8pvUG1nW","name":"column","children":[{"name":"button","params":{"templateId":"large button","label":"Book Demo","size":"large","shape":"rounded","alignment":"center","states":{"idle":{"colors":{"background":{"type":"solid","light":"#D9EDF8"}}},"hover":{"colors":{"outline":{"type":"solid","light":"#393A3A"}}}}},"children":[],"id":"-I1hwI8hlNwQUsq_Tn61w"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"Vt-1CJVMnfOMVvFpI5jtd","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"YSYBxJJxn7J0Bnx7c4zWd","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"W2Yh4uG9lg2GH7N1mYv9D","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1,1,1,1],"gap":95,"minHeight":100,"padding":10,"borderRadius":0}},{"id":"nXK64fbRBCMtt2H_JGSUB","name":"row","children":[{"id":"ZR6CTmPYwPlZRHqu4DOvx","name":"column","children":[{"name":"card","templateId":"white with icon","params":{"gap":10,"padding":28,"borderRadius":{"all":20,"isIndividualCorners":false,"bbl":0,"bbr":0,"btl":0,"btr":0},"background":"#D9EDF842","boxShadows":[{"y":0,"blur":15,"spread":-3,"color":"#00000019"},{"y":4,"blur":6,"spread":-4,"color":"#00000019"}],"hover":"elevate"},"children":[{"name":"icon","params":{"size":32,"color":{"light":"#ffffff","dark":"#15171A"},"alignment":"start","icon":"database","shape":"circular","background":{"type":"solid","light":"#000000"}},"children":[],"id":"2O2xGUWcOj2sG3qRCF4Wd"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"Create Database","fontFamily":"Montserrat, sans-serif","fontWeight":700,"fontSize":24,"color":{"light":"#202022","dark":"#ffffff"}}],"align":"left"}]},"children":[],"id":"1Db6psQr8CZzJqjbMsvY6"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"Before exporting data, we kindly recommend you to create a ","fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"}},{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"},"text":"separate database","fontWeight":700},{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"},"text":" for Jira data export and add its configurations to SQL Connector. "}]},{"type":"paragraph","children":[{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"},"text":""}]},{"type":"paragraph","children":[{"text":""},{"type":"link","link":{"value":"https://aserve.atlassian.net/wiki/spaces/SQL/pages/2848129100/How+to+Create+Database","target":"_blank","type":"link"},"children":[{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","text":"See how to create database","color":"#0091FF"}]},{"text":""}]}]},"children":[],"id":"T38qX4DQS_KmYH1b1hIHI"}],"id":"TP8rttNGo-00WD_wIwJJZ"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"HwVSH2LJUWokjWPeu4-nR","name":"column","children":[{"name":"card","templateId":"white with icon","params":{"gap":10,"padding":28,"borderRadius":{"all":20,"isIndividualCorners":false,"bbl":0,"bbr":0,"btl":0,"btr":0},"background":{"light":"#ffffff","dark":"#15171A"},"boxShadows":[{"y":0,"blur":15,"spread":-3,"color":"#00000019"},{"y":4,"blur":6,"spread":-4,"color":"#00000019"}],"hover":"elevate"},"children":[{"name":"icon","params":{"size":32,"color":{"light":"#ffffff","dark":"#15171A"},"alignment":"start","icon":"table","shape":"circular","background":{"type":"solid","light":"#000000"}},"children":[],"id":"iBHcQHcRogVGxvv7VdOD5"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"Create Data Source","fontFamily":"Montserrat, sans-serif","fontWeight":700,"fontSize":24,"color":{"light":"#202022","dark":"#ffffff"}}],"align":"left"}]},"children":[],"id":"XFwXEiJGubtd0stBHje0-"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"},"text":"A "},{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"},"text":"data source","fontWeight":700},{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"},"text":" is the primary source of data sets containing tables and fields for further analysis. It represents the data selected by the user for export to |
---|
|