![]() ![]() Note that via the Advanced menu, you get to change the connection timezone, create an SSL configuration, or activate SSH tunneling. Moreover, you get to change the default server port and specify the database you want to work with. To make a certain connection more easily recognizable, SQLPro for Postgres offers you the option to assign an alias. Right off the bat, SQLPro for Postgres prompts you to create a connection by providing details about the server host and account credentials. ![]() Built-in Postgres connection manager designed to streamline the procedure The SQLPro for Postgres utility brings to the table basic capabilities, while also allowing you to select individual cells, and run more than one query at a time. SQLPro for Postgres offers you the possibility to connect to multiple Postgres servers and databases in order to run queries and perform management tasks. Imports ĭim postgreParams As New PostgreSqlConnectionParameters()ĭim sqlDataSource As New DashboardSqlDataSource("Data Source 1", postgreParams)ĭim query As SelectQuery = SelectQueryFluentBuilder _ SelectColumns("CategoryName", "Extended Price")ĭ(sqlDataSource) SelectQuery selectQuery = SelectQueryFluentBuilder PostgreParams.DatabaseName = "Northwind" ĭashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("Data Source 1", postgreParams) PostgreSqlConnectionParameters postgreParams = new PostgreSqlConnectionParameters() ![]() Use the SqlServerConnectionParametersBase.UserName and SqlServerConnectionParametersBase.Password properties to specify the user credentials.Īssign the resulting PostgreSqlConnectionParameters object to the SqlDataSource.ConnectionParameters property.Use the PostgreSqlConnectionParameters.PortNumber property to specify the port used to connect to the PostgreSQL database.The SqlServerConnectionParametersBase.DatabaseName property specifies the name of the database to which the connection should be established.The SqlServerConnectionParametersBase.ServerName property specifies the name of the server to which the connection should be established.Create the PostgreSqlConnectionParameters class object and specify the following properties: Specify connection parameters for the PostgreSQL database. To create a data source that uses a connection to the PostgreSQL database, create an instance of the DashboardSqlDataSource class and follow the steps below: On the last page, you can optionally add query parameters and preview data. Then click Next to specify the parameter settings. Select the Stored Procedure option to select one of the stored procedures from the database. If you apply filtering or use query parameters, click Next to specify the parameter settings. Subsequently, the text of the generated query returns to the Data Source wizard. The Query Builder allows you to choose the tables/columns and passes the resulting SQL query to the SQL String editor. Select the Query option and click Run Query Builder… to invoke the Query Builder. You can choose from the following options: Specifies the name of the database that contains data.Ĭlick Next and specify how to select data from the database. Specifies the password used to authenticate to the PostgreSQL database server. Specifies the user name used to authenticate to the PostgreSQL database server. Specifies the port used to connect to the PostgreSQL database server. Specifies the name of the PostgreSQL database server to which the connection should be established. On the next page, specify connection parameters. On the first page of the invoked Data Source Wizard dialog, select PostgreSQL and click Next. To connect to a PostgreSQL database in the Dashboard Designer, follow the steps below:Ĭlick the New Data Source button in the Data Source ribbon tab. Create a Data Source in the Data Source Wizard For information on data providers, refer to the Data Sources article. The appropriate data provider must be installed on the client machine. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |