{"id":144,"date":"2022-06-09T18:24:44","date_gmt":"2022-06-09T18:24:44","guid":{"rendered":"https:\/\/docs.xlreport.com\/?post_type=docs&#038;p=144"},"modified":"2022-06-14T17:59:39","modified_gmt":"2022-06-14T17:59:39","slug":"data-connections","status":"publish","type":"docs","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/data-connections\/","title":{"rendered":"Data Connections"},"content":{"rendered":"<p>XLReport connects to all popular databases like MS Access, MS SQL Server, Oracle, MySQL, Informix, DB2, DBase, Firebird, FoxPro, Excel; text files and almost any other database through ODBC and OLEDB.<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li value=\"1\">To add a new Data Connection, select &gt;<span class=\"DoIt\">New<\/span>&gt;<span class=\"DoIt\">New Data Connection<\/span> on the menu bar.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/11.png\" \/><\/p>\n<ul>\n<li value=\"1\">Select a <span class=\"DoIt\">Connection type<\/span>.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/12.png\" \/><\/p>\n<ul>\n<li value=\"1\">Enter all required Connections settings fields.<\/li>\n<\/ul>\n<p>The new Data Connection is now available in the Project Explorer.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/13.png\" \/><\/p>\n<h2>Edit a Data Connection<\/h2>\n<ul>\n<li value=\"1\">Select the Data Connection in the Project Explorer, right click and select <span class=\"DoIt\">Edit Data Connection<\/span>.<\/li>\n<\/ul>\n<h2>Delete a Data Connection<\/h2>\n<ul>\n<li value=\"1\">Select the Data Connection in the Project Explorer, right click and select <span class=\"DoIt\">Delete Data Connection<\/span>.<\/li>\n<\/ul>\n","protected":false},"featured_media":0,"parent":106,"menu_order":3,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/144"}],"collection":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/comments?post=144"}],"version-history":[{"count":2,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/144\/revisions"}],"predecessor-version":[{"id":146,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/144\/revisions\/146"}],"up":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/106"}],"next":[{"title":"Query Your Data","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/147"}],"prev":[{"title":"XLReport Projects","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/xlreport-projects\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/139"}],"wp:attachment":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/media?parent=144"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/doc_tag?post=144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}