{"id":461,"date":"2025-03-17T07:35:44","date_gmt":"2025-03-17T07:35:44","guid":{"rendered":"https:\/\/documentation.iqonic.design\/graphina\/?p=461"},"modified":"2025-03-17T07:36:24","modified_gmt":"2025-03-17T07:36:24","slug":"external-database-integration-in-graphina-pro","status":"publish","type":"post","link":"https:\/\/documentation.iqonic.design\/graphina\/external-database-integration-in-graphina-pro\/","title":{"rendered":"External Database Integration in Graphina Pro"},"content":{"rendered":"
\n

The External Database Integration feature in Graphina Pro allows users to fetch and display data from external databases directly in their charts. This is a powerful feature<\/strong> for businesses and developers who need real-time, dynamic data visualization<\/strong> from sources outside of WordPress.<\/p>\n\n\n\n

\n\n\n\n

How Does External Database Integration Work?<\/strong><\/h2>\n\n\n\n

With this feature, Graphina Pro can connect to remote MySQL or other databases<\/strong>, retrieve data, and visualize it in charts without needing to manually import CSV files or update data manually.<\/p>\n\n\n\n

Key Benefits:<\/strong><\/h4>\n\n\n\n

\u2705 Real-Time Data Sync<\/strong> \u2013 Graphs update automatically as the external database changes.
\u2705 Direct Database Queries<\/strong> \u2013 Fetch data using SQL queries for precise control.
\u2705 No Manual Updates Needed<\/strong> \u2013 Avoid the hassle of exporting\/importing CSVs.
\u2705 Enhanced Performance<\/strong> \u2013 Streamline data management for large datasets.<\/p>\n\n\n\n

\n\n\n\n

How to Use External Database Integration in Graphina Pro?<\/strong><\/h2>\n\n\n\n

<\/p>\n\n\n\n

\n\n\n\n

Step 1: Open the External Database Settings<\/strong><\/h3>\n\n\n\n
    \n
  • Navigate to Graphina Settings<\/strong> in your WordPress dashboard.<\/li>\n\n\n\n
  • Click on the “External Database”<\/strong> tab.<\/li>\n<\/ul>\n\n\n\n

    Step 2: Enter Database Connection Details<\/strong><\/h3>\n\n\n\n

    Fill in the required fields with your database credentials:<\/p>\n\n\n\n

      \n
    • Connection Name:<\/strong> Give your connection a recognizable name (e.g., graphina_test<\/code>).<\/li>\n\n\n\n
    • Note:- It is requested to use only lowercase for names and underscore for spaces as shown in the e.g<\/li>\n\n\n\n
    • Database Name:<\/strong> Enter the exact name of your database (e.g., graphina<\/code>).<\/li>\n\n\n\n
    • Vendor:<\/strong> Select your database type (e.g., MySQL<\/code>).<\/li>\n\n\n\n
    • Host:<\/strong> Enter the database host (e.g., localhost<\/code> for a local server).<\/li>\n\n\n\n
    • Username:<\/strong> Provide the database username (e.g., root<\/code>).<\/li>\n\n\n\n
    • Password:<\/strong> Enter the password for the database.<\/li>\n<\/ul>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      Step 3: Test the Database Connection<\/strong><\/h3>\n\n\n\n
        \n
      • Click on the “Test DB Setting”<\/strong> button to verify the connection.<\/li>\n\n\n\n
      • If the test is successful, you will receive a confirmation message.<\/li>\n\n\n\n
      • If the test fails, check your credentials and try again.<\/li>\n<\/ul>\n\n\n\n

        Step 4: Save or Reset the Settings<\/strong><\/h3>\n\n\n\n
          \n
        • Once the connection is verified, click “Save Setting”<\/strong> to store the configuration.<\/li>\n\n\n\n
        • If you need to reset the details, click “Reset”<\/strong> to clear the fields.<\/li>\n<\/ul>\n\n\n\n

          Step 5: Use the Database for Graphina Charts<\/strong><\/h3>\n\n\n\n
            \n
          • Now that the connection is established, you can write SQL queries<\/strong> to fetch data.<\/li>\n\n\n\n
          • Use the retrieved data to create live, interactive charts<\/strong> in Graphina.<\/li>\n<\/ul>\n\n\n\n
            \n\n\n\n

            Why Use External Database Integration?<\/strong><\/h2>\n\n\n\n

            \ud83d\udd17 Live Data Streaming<\/strong> \u2013 Ideal for e-commerce, analytics, finance, and business dashboards<\/strong>.
            \ud83d\udcca No Manual Updates<\/strong> \u2013 Your WordPress charts stay automatically updated<\/strong> with fresh data.
            \u26a1 Connect Multiple Data Sources<\/strong> \u2013 Fetch data from multiple databases<\/strong> to create unified reports.
            \ud83d\udd12 Secure & Efficient<\/strong> \u2013 Queries run in a controlled environment<\/strong> to ensure security and performance.<\/p>\n\n\n\n

            \n\n\n\n

            Upgrade to Graphina Pro and Unlock External Database Integration!<\/strong><\/h4>\n\n\n\n

            With Graphina Pro<\/strong>, you can connect, query, and visualize<\/strong> external data effortlessly\u2014without any complex coding.<\/p>\n\n\n\n

            \ud83d\ude80 Start leveraging real-time data today!<\/strong><\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"

            The External Database Integration feature in Graphina Pro allows users to fetch and display data from external databases directly in their charts. This is a powerful feature for businesses and developers who need real-time, dynamic data visualization from sources outside of WordPress. How Does External Database Integration Work? With this feature, Graphina Pro can connect […]<\/p>\n","protected":false},"author":12,"featured_media":0,"parent":436,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-461","post","type-post","status-publish","format-standard","hentry","category-graphina"],"featured_image_src":null,"author_info":{"display_name":"wordpressadminiq","author_link":"https:\/\/documentation.iqonic.design\/graphina\/author\/wordpressadminiq\/"},"children":[],"_links":{"self":[{"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts\/461","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/comments?post=461"}],"version-history":[{"count":2,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts\/461\/revisions"}],"predecessor-version":[{"id":464,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts\/461\/revisions\/464"}],"up":[{"embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts\/436"}],"wp:attachment":[{"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/media?parent=461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/categories?post=461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/tags?post=461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}