How to find connection string for the writeback node in Statistica ?
Article ID: KB0080755
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 13 and later versions |
Description
Write Spreadsheet to Database node has a parameter called "Database Connection" that expects the name of an existing Database connection or a connection string. For non- Enterprise installs, how can connection string be retrieved ?
Issue/Introduction
This article details how the connection string to a relational database can be determined, while using the Write to Database node in Statistica.
Resolution
Statistica users who don't have Enterprise may extract the connection string from within Statistica or outside Statistica. Both are described below:
A. Within Statistica :
2. On the Database Connection dialog that comes up, click on New OLEDB...
3. In the Data Link Properties dialog, choose from the list of OLEDB Providers and enter your connection information. Ensure you select "Allow saving Password". You may optionally check to see if the connection details are correct with the Test connection button.
4. Copy the highlighted portion of the connection string and Password=Password at the end into Database connection parameter to the Write to Database node.
B. Outside Statistica :
1. Open Control Panel >> Appearance and Personalization>> File Explorer Options>> View Tab and uncheck the option to Hide extensions for known file types
2. On a folder of your choice, right click and select New>>Text document. Rename the extension of the file from '.txt' to '.udl'. Click on Yes for the warning that Windows displays for renaming the file extension.
3. Double click and open the file to see Data Link properties dialog. Choose from the list of OLEDB providers and enter the credentials to the database. Ensure you enable "Allow saving password and click OK. Optionally test the connection by choosing Test Connection
4. Click on Yes on the warning to save password to file.
5. Right click on the .udl file and select Open with and select Notepad from the list of Applications. This should display the connection string in a file that you can copy to Database connection in the Write to database node within Statistica.
NOTE : Please remember to delete this file appropriately. It is not safe to have a file with password to databases.
Statistica Enterprise users can simply use the name of the database connection in Enterprise or copy connection string from Database connection in Enterprise and replace **** with the actual password in the database connection parameter of the write to database node.
A. Within Statistica :
- Click on File >>External Data>>Query / Advance Query Builder>> Create.
2. On the Database Connection dialog that comes up, click on New OLEDB...
3. In the Data Link Properties dialog, choose from the list of OLEDB Providers and enter your connection information. Ensure you select "Allow saving Password". You may optionally check to see if the connection details are correct with the Test connection button.
4. Copy the highlighted portion of the connection string and Password=Password at the end into Database connection parameter to the Write to Database node.
B. Outside Statistica :
1. Open Control Panel >> Appearance and Personalization>> File Explorer Options>> View Tab and uncheck the option to Hide extensions for known file types
2. On a folder of your choice, right click and select New>>Text document. Rename the extension of the file from '.txt' to '.udl'. Click on Yes for the warning that Windows displays for renaming the file extension.
3. Double click and open the file to see Data Link properties dialog. Choose from the list of OLEDB providers and enter the credentials to the database. Ensure you enable "Allow saving password and click OK. Optionally test the connection by choosing Test Connection
4. Click on Yes on the warning to save password to file.
5. Right click on the .udl file and select Open with and select Notepad from the list of Applications. This should display the connection string in a file that you can copy to Database connection in the Write to database node within Statistica.
NOTE : Please remember to delete this file appropriately. It is not safe to have a file with password to databases.
Statistica Enterprise users can simply use the name of the database connection in Enterprise or copy connection string from Database connection in Enterprise and replace **** with the actual password in the database connection parameter of the write to database node.
Feedback
Yes
No
Powered by
