![inductive automation ignition read csv to sql database inductive automation ignition read csv to sql database](https://docs.inductiveautomation.com/download/attachments/26019482/image2018-2-16_14-7-6.png)
(The moderator, Don Pearson, briefly introduces the topic, Inductive Automation and Ignition software, and then introduces the presenter, Travis Cox.) Blog post: 12 Powerful Ways to Use PLCs with SQL Databases - Part 2.Blog post: 12 Powerful Ways to Use PLCs with SQL Databases - Part 1.Map PLC values to stored procedures in a database.Synchronize PLCs through a SQL database.You’ll not only learn a dozen ways to use this versatile tool, you’ll also be able to think up other exciting ways to apply it in your enterprise. Inductive Automation Co-Director of Sales Engineering Travis Cox discusses 12 of the many powerful uses of the SQL Bridge Module. For years, companies have used it as a “Swiss Army knife” for a variety of industrial data management needs. As its name suggests, the SQL Bridge Module acts as a conduit between PLCs and any SQL database. The Ignition SQL Bridge Module is made for this exact purpose. What if there was an easier way to move data between the plant floor and the rest of your enterprise, specifically between PLCs and SQL databases? It would open up many opportunities to improve efficiency, data storage, synchronization, uptime, data insights - and the list goes on. Ignition Exchange Community-made Ignition resources.Ignition Maker Edition Made for hobbyist and educational use.Ignition Edge Made for field and OEM devices at the edge.You can then use that test data that you've put together in a static CSV to test out your report until it's finished, and then swap it out for the real database data once you have access to that. You can instead build a static CSV data source, and model it to look like your database tables would. In addition, they also work great when testing out a report, and you don't quite have access to a database yet. Static CSV data sources are really useful, and that they allow you to quickly bring data into your report. In addition, the total calculations worked for column one and column two, but not for column three, because these are string values. Now if I go over to my preview tab, you can see I have all of my data listed here, including the two strings without quotation marks. You can see I'm listing the data for column one, column two, and column three, as well as the totals for each of the three columns. In the report, I've placed a table that contains our static data. Now if we go into the design tab of our report, we can go over to the data sources folder in the key browser, and we can see our static data listed here with columns one, two, and three.
![inductive automation ignition read csv to sql database inductive automation ignition read csv to sql database](https://inductiveautomation.com/blog/sites/default/files/2018-11/2012-05May-SQL-TheNextBigThing-thumb_0.jpg)
You will be able to see in just a minute, that even though these two strings don't have quotation marks around them, they'll still work just fine. Let me demonstrate by adding some additional rows of data. Now while these string values have quotation marks around them, I don't actually need the quotation marks. You can see in column one, I have a couple of integers, in column two, I have a couple of floats, and in column three, I have some strings. The first row is where you can assign names to each of your columns. You'll notice that it comes pre-loaded with some data to demonstrate how it works. Here in the data tab from my report, I'm going to add a new data source. The static CSV data source allows you to quickly bring data into your report.