External connection strings

More
9 years 8 months ago #9494 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

Please Log in or Create an account to join the conversation.

More
9 years 8 months ago - 9 years 8 months ago #9495 by admin
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 D: 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

Mike
ETL Architect
Last edit: 9 years 8 months ago by admin.

Please Log in or Create an account to join the conversation.