際際滷

際際滷Share a Scribd company logo

Db import&export

sheetal sharma
sheetal sharma

This document provides instructions for importing and exporting data from an IBM Bluemix SQL Database service. It describes: 1. How to fork an existing project on JazzHub that allows exporting data from an SQL database table to a CSV file. 2. How to add the SQL Database service to a Bluemix application and launch the service. 3. The steps to import data into the database from a CSV file, including selecting the file, specifying column formats like dates, and loading the data. 4. How to export data from the database table to a CSV file, apply filters, and view and order columns.

1 of 26
Download to read offline
IBM Bluemix SQL Database Service Sheetal Sharma Intern,IBM Innovation Centre
Import and export data from your Bluemix SQL Database The SQL Database service is an easy and quick way to add a powerful relational database to your web or mobile application. Under the covers, it is powered by IBM DB2.
Get the Code Click on the link OR Copy & Paste this link to the Browser https://hub.jazz.net/project/pvanrun/SQLDBCSVExport/overview Login to the account. Fork the Project.
Fork Project Write the name for project. Make this Private project (Invited team members only) Add features for Scrum development Make this a Bluemix Project Select Region,Organization and Space. Create.
Edit Code To Perform the changes and to deploy
Open the Bluemix Dashboard Click on the App.
Add SQL Database Service Click on Add a Service or API
Catelog- Data & Analytics Select SQL Database Service
Launch the service Click on the Service Icon. Click on the Launch. For more Info.. Learn Discover
Welcome page of SQL Database
Import the data To load data into this table, click Manage in the top-level menu and select Load Data. Click Browse files to select the Telecocustomers.csv data file from your local system.
Upload the file Click Browse files to select the Telcocustomers.csv data file from your local system. Row 1 of this file does not contain the column names; therefore, click No to answer that question. Set the separator character to Comma because this is the character used to distinguish the column values in the file. This load file contains a number of dates; therefore, click Yes to the question Does the file have columns that contain dates or times? and then enter YYYY/MM/DD as the date format. If this pattern is not in the drop-down list, you can add it yourself. Click Load File. The console now loads the file and shows you a preview. The maximum file size is 20MB.
Db import&export
Choose a Target Choose Create a new table and load Click on Next
Select a Table Modify the Table. Can Change the column name and formats. Click on Finish.
Load Complete Here we Can.. Export the csv file. Define Filter. Show or hide and order column.
Filter Can apply one or more filters
Go To Dashboard Click on the App URL. The App will be open at the new browser. Select the file name and submit it. This has submitted in the database.
Work with Tables Go to Manage tab. Select work with table Select the Schema and table name
Quick Filter Add a table to the selected schema Delete the Table
Browse Data Browse the file. Run DDL.
Apply Select the Maximum rows and apply.
Run Query Go to manage. Select Table and Columns.
Select table and columns Apply.
Run Query Write the Query. Click on the Run Query
Thank You!

More Related Content

Db import&export

  • 1. IBM Bluemix SQL Database Service Sheetal Sharma Intern,IBM Innovation Centre
  • 2. Import and export data from your Bluemix SQL Database The SQL Database service is an easy and quick way to add a powerful relational database to your web or mobile application. Under the covers, it is powered by IBM DB2.
  • 3. Get the Code Click on the link OR Copy & Paste this link to the Browser https://hub.jazz.net/project/pvanrun/SQLDBCSVExport/overview Login to the account. Fork the Project.
  • 4. Fork Project Write the name for project. Make this Private project (Invited team members only) Add features for Scrum development Make this a Bluemix Project Select Region,Organization and Space. Create.
  • 5. Edit Code To Perform the changes and to deploy
  • 6. Open the Bluemix Dashboard Click on the App.
  • 7. Add SQL Database Service Click on Add a Service or API
  • 8. Catelog- Data & Analytics Select SQL Database Service
  • 9. Launch the service Click on the Service Icon. Click on the Launch. For more Info.. Learn Discover
  • 10. Welcome page of SQL Database
  • 11. Import the data To load data into this table, click Manage in the top-level menu and select Load Data. Click Browse files to select the Telecocustomers.csv data file from your local system.
  • 12. Upload the file Click Browse files to select the Telcocustomers.csv data file from your local system. Row 1 of this file does not contain the column names; therefore, click No to answer that question. Set the separator character to Comma because this is the character used to distinguish the column values in the file. This load file contains a number of dates; therefore, click Yes to the question Does the file have columns that contain dates or times? and then enter YYYY/MM/DD as the date format. If this pattern is not in the drop-down list, you can add it yourself. Click Load File. The console now loads the file and shows you a preview. The maximum file size is 20MB.
  • 14. Choose a Target Choose Create a new table and load Click on Next
  • 15. Select a Table Modify the Table. Can Change the column name and formats. Click on Finish.
  • 16. Load Complete Here we Can.. Export the csv file. Define Filter. Show or hide and order column.
  • 17. Filter Can apply one or more filters
  • 18. Go To Dashboard Click on the App URL. The App will be open at the new browser. Select the file name and submit it. This has submitted in the database.
  • 19. Work with Tables Go to Manage tab. Select work with table Select the Schema and table name
  • 20. Quick Filter Add a table to the selected schema Delete the Table
  • 21. Browse Data Browse the file. Run DDL.
  • 22. Apply Select the Maximum rows and apply.
  • 23. Run Query Go to manage. Select Table and Columns.
  • 24. Select table and columns Apply.
  • 25. Run Query Write the Query. Click on the Run Query