Updating database parametrers in 2.5
-
I have about 50 .iok files which extract data from an oracle database. These are refreshed every morning by the scheduler. In their "wisdom", our DBA's have moved the database to a new server, using a different port number. Is there a way to easily update the iok files to reflect the new Database and port number. Our other systems are unaffected as they use the TNS names file to conect to the database, but Visokio uses the native connection string. Otherwise I have to open each file in turn and update it.
-
3 Comments
-
You can use the scheduler to automate the setting of the database source configuration. You can also use an XML file to do this, and edit the XML yourself/automatically. But I'm not sure if this will help.
You can also use the hosts file on a windows or unix system to fake the hostname change, but not the port.
Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.