We have a Vision app that our customer wants to use Hach WIMS (SQL Database with a .NET wrapper).
We are currently using the Sample_SQLite_Database, but need to access it.
Does this "Hach WIMS" software support connecting to SQLite databases?
No, it does connect with MicrosoftSQL, but that brings up more questions, like,
how to set up the new DB.
Will I lose access to the data stored on the SampleSQLite?
Do I need to change the trending tags?
With some amount of effort you should be able to migrate/import your data to a MS SQL Server instance. Support can probably help you out with the details.
Are you needing to just pull data out of their database? You'll probably need some custom queries to pull the data stored in their DB. If you're wanting to use their database for storing your data also, it should be possible and I would just create a new DB inside their instance to keep it separate from their system.
If this is Ignition Edge, you're out of luck. You'll need standard edition to do any of this.
I might have got off track. What I need is really just how to set up the MicrosoftSQL DB , the Hach WIMS will do the rest.
Your going to need the IP/DNS host name, username, password, and database name used by that system to set it up.
On that server, you'll need to use the SQL Server configuration to verify that TCP/IP is enabled for access, but most of that information is in this video (adjust as necessary as your instance name may be different):
1 Like
thanks, got it