{"id":25233,"date":"2025-09-03T15:17:20","date_gmt":"2025-09-03T15:17:20","guid":{"rendered":"https:\/\/www.datafusing.com\/?p=25233"},"modified":"2026-03-29T10:27:39","modified_gmt":"2026-03-29T10:27:39","slug":"running-your-first-sql-with-cloudsql","status":"publish","type":"post","link":"https:\/\/www.datafusing.com\/running-your-first-sql-with-cloudsql\/","title":{"rendered":"Running your First SQL with CloudSQL\u00a0"},"content":{"rendered":"\n

Introduction <\/h2>\n\n\n\n

Running your first SQL in CloudSQL is quick and easy. If you\u2019ve used tools like SQL Developer or Toad, you\u2019ll find the interface very familiar. <\/p>\n\n\n\n

Note:<\/strong> CloudSQL is a Windows executable. You can sign up for a 30-day free trial<\/strong> on the DataFusing website. After registering, download the zip file, unzip it, and launch CloudSQL.exe<\/strong>, no installation is required. <\/mark>Click here to Checkout<\/strong><\/a><\/p>\n\n\n\n

In the next section, we\u2019ll walk through how to set up CloudSQL, connect to your database, and run your first SQL query. Step-by-step screenshots are included to make the process easy to follow. <\/p>\n\n\n\n

Step-by-Step: Running an SQL with CloudSQL <\/h2>\n\n\n\n

Step 1 \u2013 Launch CloudSQL\u202f<\/strong> <\/p>\n\n\n\n

Launch the Cloud SQL Desktop application by clicking CloudSQL.exe. A new worksheet will open up.  From the Connection list from the top right, launch \u201cCreate New Connection\u201d option.\u202f <\/p>\n\n\n\n

\"DataFusing<\/figure>\n\n\n\n

Step 2 \u2013 Configure new Connection<\/strong> <\/p>\n\n\n\n

Enter your Oracle Fusion connection details on the connection pop up. Provide the Connection Name, URL (Oracle Fusion URL), Username (Oracle Fusion Application username), and Password. Then click on , Test and Create Connection button to complete setting up of the connection. <\/p>\n\n\n\n

Note: Please ensure your user account has sufficient roles to create and run BI Publisher reports. Either the BI Author or BI Developer role will be sufficient. If these are not available now, you can request Oracle Fusion administrator for this. <\/p>\n\n\n\n

\"Sign<\/figure>\n\n\n\n

Step 3 \u2013 Select the configured connection<\/strong>\u202f <\/p>\n\n\n\n

Choose the newly configured connection from the Connection list to proceed with establishing the connection to Oracle Fusion database. <\/p>\n\n\n\n

\"Choose<\/figure>\n\n\n\n

Step 4 \u2013 Write and Run your  SQL query<\/strong>\u202f 
Develop your SQL query and click on the run button from the toolbar. Your SQL will be sent to Oracle BI layer for execution and results returned will be  populated on the Result Grid below. <\/p>\n\n\n\n

Pro Tip:<\/strong> Explore the options in the toolbar such as code formatting, background execution, and auto-completion\u2014to make your work faster and easier <\/p>\n\n\n\n

\"Run<\/figure>\n\n\n\n

Step 5 \u2013 Review the results:<\/strong>\u202f <\/p>\n\n\n\n

Review the results in the grid by applying features such as Filter, Sort, Group By, and Single Record View. <\/p>\n\n\n\n

\"Review<\/figure>\n\n\n\n

Step 6 \u2013 Export the data:<\/strong>\u202f <\/p>\n\n\n\n

Click on the Export option to download the data in your preferred format such as CSV or Excel.\u202f <\/p>\n\n\n\n

\"Export<\/figure>\n\n\n\n

\u202f <\/p>\n\n\n\n

Get started today! Register for your Free Trial<\/strong><\/a> now and start writing SQL in just minutes.\u00a0<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction  Running your first SQL in CloudSQL is quick and easy. If you\u2019ve used tools like SQL Developer or Toad, you\u2019ll find the interface very familiar.  Note: CloudSQL is a Windows executable. You can sign up for a 30-day free trial on the DataFusing website. After registering, download the zip file, unzip it, and launch […]<\/p>\n","protected":false},"author":1,"featured_media":25449,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[142],"tags":[],"class_list":["post-25233","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloudsql-sql-editor-for-oracle-fusion"],"_links":{"self":[{"href":"https:\/\/www.datafusing.com\/wp-json\/wp\/v2\/posts\/25233","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.datafusing.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.datafusing.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.datafusing.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.datafusing.com\/wp-json\/wp\/v2\/comments?post=25233"}],"version-history":[{"count":5,"href":"https:\/\/www.datafusing.com\/wp-json\/wp\/v2\/posts\/25233\/revisions"}],"predecessor-version":[{"id":27926,"href":"https:\/\/www.datafusing.com\/wp-json\/wp\/v2\/posts\/25233\/revisions\/27926"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.datafusing.com\/wp-json\/wp\/v2\/media\/25449"}],"wp:attachment":[{"href":"https:\/\/www.datafusing.com\/wp-json\/wp\/v2\/media?parent=25233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.datafusing.com\/wp-json\/wp\/v2\/categories?post=25233"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.datafusing.com\/wp-json\/wp\/v2\/tags?post=25233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}