Pinned topic import database connections from conifguration assistant
I attached the file that I tried to use to import the connections into Data Studio. I created this file using the Configuration Assistant - Configure – Export Profile – Database Connections option. I them tried to import that into Data Studio and received the following error:
the coonections were not imported. verify location and file type.
loicjulien 2700007DEB96 Posts
Re: import database connections from conifguration assistant2013-03-29T17:08:25ZThis is the accepted answer. This is the accepted answer.Hi Thomas,
Connections from the Configuration Assistant are not imported through the Import Wizard in the Data Studio Client (unlike with the Data Studio Web Console where there is a dedicated Import action).
In the Data Studio Client, you need to validate that the preference to automatically import those connections is turned ON. I am attaching below a screencap of the preference (Load DB2 Alias connections on startup.)
In order to read those (automatic on start if the preference is ON), there isn't any file required as we go directly after an API that allows us to retrieve the database connections cataloged by the client.
Let us know if this does not help,
Lee_Hayden_at_CSX 270001UE421 Post
Re: import database connections from conifguration assistant2016-03-31T18:12:11ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
I have this same issue with Data Studio 4.1.2 and DB2 Connect 10.5.
I checked the properties as above and they are on. Data Studion comes up with NO database connections.
If I have to manually create all of the connections I use Data Studio will have no value to me.
vadave 20000030DN1 Post
Re: import database connections from conifguration assistant2017-02-24T14:04:46ZThis is the accepted answer. This is the accepted answer.
- loicjulien 2700007DEB
That option sounds like I have to keep the old DB2 Control Center (CC) around so that DataStudio(DS) can find and reload these connections every time DS starts up.
We were hoping for a more permanent solution, such as some sort of import/migration solution that would permanently import/migrate my old CC connections to DS.
LukeNumrych 060001X9RC75 Posts
Re: import database connections from conifguration assistant2017-02-24T17:31:42ZThis is the accepted answer. This is the accepted answer.
- vadave 20000030DN
Would importing CC connections into DSWC first and then from DSWC into Data Studio work for you? I know the DSWC->DS step works for me just fine, but it does strip credentials.
I am also pretty sure that you can also use DSWC repository database as a connection repository for Data Studio. This way you do not have to have connection profiles defined locally in each Data Studio copy. I believe that doing it this way preserves the credentials, but does not make them plain-text readable to the people using Data Studio. This also limits the potential of disclosure of credentials, since they would be only known to whomever sets up the connections in DSWC.