<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Umer Saleem on Medium]]></title>
        <description><![CDATA[Stories by Umer Saleem on Medium]]></description>
        <link>https://medium.com/@umer_saleem?source=rss-e4fd855dd0e6------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*HyYH8V1EcP7D3Uj-bLeCyQ.jpeg</url>
            <title>Stories by Umer Saleem on Medium</title>
            <link>https://medium.com/@umer_saleem?source=rss-e4fd855dd0e6------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 20:36:37 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@umer_saleem/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Importing Data from InfluxDB to Tableau Desktop]]></title>
            <link>https://medium.com/@umer_saleem/importing-data-from-influxdb-to-tableau-desktop-b8a0c6452162?source=rss-e4fd855dd0e6------2</link>
            <guid isPermaLink="false">https://medium.com/p/b8a0c6452162</guid>
            <category><![CDATA[tableau]]></category>
            <category><![CDATA[time-series-data]]></category>
            <category><![CDATA[visualization]]></category>
            <category><![CDATA[influxdb]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <dc:creator><![CDATA[Umer Saleem]]></dc:creator>
            <pubDate>Sat, 06 Jun 2020 20:38:32 GMT</pubDate>
            <atom:updated>2020-06-06T20:38:32.598Z</atom:updated>
            <content:encoded><![CDATA[<p>Understanding the connectivity and data protocols for InfluxDB database</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/898/1*n0HGrrHfu1S6OF1hVQxQWQ.jpeg" /><figcaption>Photo by <a href="https://www.nitrd.gov/news/data-visualization-data-wrangling.aspx">NITRD</a></figcaption></figure><p>The objective of this article is to provide a brief introduction regarding InfluxDB database and its applications. We will also see how can the database be effectively linked to visualisation tools like Tableau in making data insights much more presentable and understandable!!</p><h3>What is InfluxDB?</h3><blockquote>InfluxDB is an open-source database built specifically for storing time-series data. It is optimised for high-availability storage and retrieval of data in areas like Internet Of Things (IOT) sensor data, mobile and web application metrics and real-time analytics.</blockquote><h4>1. InfluxDB Installation on Windows</h4><p>Go to this link: <a href="https://portal.influxdata.com/downloads/"><strong><em>https://portal.influxdata.com/downloads/</em></strong></a><em> </em>and click on the latest version (e.g. v1.8.0) of the influxdb database. On the next screen, click to download the zip file on local system based on the specifications(32 bit or 64 bit).</p><h4>2. Verifying the Installation</h4><p>Unzipping the folder, you’ll notice that there are a number of executable files meaning the influxdb package comes with all the required dependencies. Next, execute the influx source server (<em>influxd.exe</em>) file followed by influx client (<em>influx.exe</em>) file. The server by default is running on port <em>8086</em>. If you don’t face any errors, it means the installation is successful.</p><h4>3. Querying InfluxDB using Client</h4><p>The most effective way of querying influxDB is by sending HTTP request (GET,POST) to the “<strong>InfluxDB API</strong>”. Alternatively, you can also search for client libraries to query the database using the link: <strong><em>“</em></strong><a href="https://github.com/influxdata/influxdb-client-python"><strong><em>https://github.com/influxdata/influxdb-client-python</em></strong></a><strong><em>”. </em></strong>More details on querying the influxdb database can be found on this link: <strong><em>“</em></strong><a href="https://docs.influxdata.com/influxdb/v1.8/guides/query_data/#query-data-with-flux"><strong><em>https://docs.influxdata.com/influxdb/v1.8/guides/query_data/#query-data-with-flux</em></strong></a><strong><em>”</em></strong>.</p><p>So now once the influxdb is successfully established and we are able to insert and query the data in it, the next step are</p><p><strong>a. What is a Web Data Connector?</strong></p><p><strong>b. How the Web Data Connector links the InfluxDB with Tableau for visualisation?</strong></p><h3>Web Data Connector</h3><blockquote>Web Data Connector (WDC) is the bridge that connects the influxDB data with Tableau. The main purpose of WDC is to connect to the data that is accessible over the HTTP but lacks a connector. The WDC must be hosted on a web server running locally on your system, on a web server in your domain or on a third-party web server.</blockquote><h4>1. Setting up Web Data Connector for InfluxDB</h4><p>You can visit the link below regarding step by step guidance for setup and connection of WDC with Tableau: <a href="https://tableau.github.io/webdataconnector/docs/index.html#get-the-wdc-sdk">https://tableau.github.io/webdataconnector/docs/index.html#get-the-wdc-sdk</a>.</p><h4><strong>2. Editing the WDC for custom data in InfluxDB</strong></h4><p>After downloading the wdc sdk from the above mentioned link, in the “<strong><em>webconnector/Examples/js/earthquakeUSGS.js”</em></strong> file under the “<em>getData</em>” function , replace the existing url with the influxdb api URL (<strong><em>http://localhost:8086/query?pretty=true&amp;db=fourthdb&amp;q=SELECT%20*%20from%20measure_1</em></strong>) to query the influxdb database. In the above URL, “db” is the existing database in influxdb, “q” allows you to query the measurement within the database as per your requirement.</p><h4>3. Designing Schema of Data</h4><p>Before downloading and passing the data to Tableau, we have to specify the variables required to be mapped on to one or more tables in Tableau. This mapping is performed in the “<em>getSchema</em>” function in the “<strong><em>webconnector/Examples/js/earthquakeUSGS.js” </em></strong>file.</p><h4><strong>4. Linking WDC with Tableau</strong></h4><p>After saving the required changes, enter the WDC URL in the space below and press <em>Enter.</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/785/1*NDzXYFJORwsyaj0KJzMBKw.png" /><figcaption>Tableau Web Data Connector display</figcaption></figure><p>Tableau loads the WDC page where the user can provide any input. After that, tableau calls the WDC code, downloads the data from the web page containing the influxdb api response and displays it in the <strong>Data Source</strong> pane.</p><h3>About the Author</h3><p>Umer Saleem is a Data Scientist. He is passionate about research and advancements in Data Science, Machine and Deep Learning and Artificial Intelligence. Get in touch with him on <a href="https://www.linkedin.com/in/umersaleem1/">LinkedIn</a> and <a href="https://medium.com/@umer_saleem">Medium</a>.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b8a0c6452162" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>