- Posts: 4
- Thank you received: 0
External connection strings
9 years 8 months ago #9494
by Ivano
External connection strings was created by Ivano
Hello
Is there a way to utilize something like an App.Config so we can change a simple text file instead of having to cretate maps for each server we are using the mapping on?
I think this would be an incredible addition to the application.
if this is currently possible, could someone t me know? Thanks!
Ivano
Is there a way to utilize something like an App.Config so we can change a simple text file instead of having to cretate maps for each server we are using the mapping on?
I think this would be an incredible addition to the application.
if this is currently possible, could someone t me know? Thanks!
Ivano
Please Log in or Create an account to join the conversation.
9 years 8 months ago - 9 years 8 months ago #9495
by admin
Mike
ETL Architect
Replied by admin on topic External connection strings
I f you really want to use text file to store connection settings you can do it but I think the global variables are better option
The global variables are specific to the computer
For example
We have repository located in server1
Server is runnig the agent and two users are connected to the same repository
On the server the files are located on c:\ drive
John is a developer and his files are located on the network mapped drive.
Maria is a tester and her files are located on
drive
Using global variables allows them to load the data from different locations without any modifications to the mappings
I hope it is usefull for you
Mike
The global variables are specific to the computer
For example
We have repository located in server1
Server is runnig the agent and two users are connected to the same repository
On the server the files are located on c:\ drive
John is a developer and his files are located on the network mapped drive.
Maria is a tester and her files are located on

Using global variables allows them to load the data from different locations without any modifications to the mappings
I hope it is usefull for you
Mike
Mike
ETL Architect
Last edit: 9 years 8 months ago by admin.
Please Log in or Create an account to join the conversation.