SQL Server Data Importer

Follow

Mark Ha

February 15, 2017 16:47

Hi Zerion Community,

We are looking into developing a SQL Server Data Importer that would allow Data to be pulled from SQL server and consumed within Zerion Software tools.

I have come up with an example below:

A List of inventory is stored in a SQL Server Table and is updated and maintained there. This table would be synced directly through the Zerion Dataflow and updated a Lookup table used in a form. This eliminates the need to write a custom service that updates the table based upon changes made in the SQL Server table.

Does anyone have any other examples or use cases they can share?

 

8

• 

  Beth August 29, 2017 07:23

  This is a great feature and would help our process. We collect survey data from the same group of users every year. Additionally, demographic/location data is stored in an SQL Server table for all of these users. We use a smart table search which populates the demographic/location data in the survey from our SQL Server table to expedite data collection. Each year there are slight changes to the group of users we collect survey data from as some leave and some join, so the look-up table must be manually updated. If it was possible to note in our SQL Server table whether a user was part of the survey group and then filter based on that, the look-up table could be automatically updated which would be very helpful.

  0

  Comment actions Permalink

Please sign in to leave a comment.