New user, struggling to understand how to connect to database
Forum rules
DO NOT POST LICENSE NUMBERS, ACTIVATION KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.
Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
DO NOT POST LICENSE NUMBERS, ACTIVATION KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.
Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
-
- Posts: 3
- Last visit: Mon Jan 22, 2024 11:09 pm
New user, struggling to understand how to connect to database
Please forgive me if this has been covered elsewhere (or here for that matter) I have tried to search for an answer but have not found anything directly related. I am new to PowerShell Studio for which I have purchased a license because it's a fantastic product. I am however struggling to understand how to connect to a database (I want to use either MSSQL or MYSQL) and while I know how to do this "programmatically" in PS I'm stumped as to how to do it graphically via PowerShell Studio. I guess I expected native tools out of the box that would make this a simple point and click exercise. Please let me know if this is available otherwise I'll continue with manual scripted connections. Very much appreciated.
Re: New user, struggling to understand how to connect to database
You can create a database connection from two locations: Database tab on ribbon or Database pane on the Object Browser panel:
When you create a connection from the Database tab, it will then be listed on the Database pane. If you are trying to run SQL files, you can then open a SQL file and set the documents connection from the ribbon: Once the connection is present and accessible on the Database pane, you can generate forms or scripts for that connection: For more information on the Database pane, you can find it under the Object Browser section of PowerShell Studio's manual:
https://info.sapien.com/manuals/powersh ... owser.html
When you create a connection from the Database tab, it will then be listed on the Database pane. If you are trying to run SQL files, you can then open a SQL file and set the documents connection from the ribbon: Once the connection is present and accessible on the Database pane, you can generate forms or scripts for that connection: For more information on the Database pane, you can find it under the Object Browser section of PowerShell Studio's manual:
https://info.sapien.com/manuals/powersh ... owser.html
Brittney
SAPIEN Technologies, Inc.
SAPIEN Technologies, Inc.