Load Raw Data

In this step you load data into the Asset you previously created.

View your Asset

  1. Open the SQL developer application.
  2. Open the Connections tree in the left panel and locate the connection labeled UTILITYCO.
  3. Scroll down to the section labeled Other Users and expand it.
  4. Ensure that you can now find the Asset you created. It is labeled UTILITYCO_CUSTOMER.
  5. Open the Asset which is currently empty. This is your Asset to import your raw data into.

Create a New SQL File

Using the SQL developer connection you created in the last step, open a new SQL file.

  1. Open SQL developer application.
  2. Select File, and then select New.
  3. Select Database Tier, and then select Database Files.
  4. Select SQL file, and then select OK.

Import Data

Start by adding some data to your Asset as if you had a customer system. This example includes adding some data for customer locations.

  1. Run the following SQL script to create the CI_PREM table.

     CREATE TABLE UTILITYCO_CUSTOMER#ASSET.CI_PREM (
     PREM_ID VARCHAR2(254),
     ADDRESS1 VARCHAR2(254),    
     CITY VARCHAR2(254),
     STATE VARCHAR2(254),
     POSTAL VARCHAR2(254),
     PRNT_PREM_ID VARCHAR2(254)
 );

  2. Run the following SQL script to add some records.

     Insert into UTILITYCO_CUSTOMER#ASSET.CI_PREM (PREM_ID,ADDRESS1,CITY,STATE,POSTAL, PRNT_PREM_ID) values ('8555465030','492 Wickson','Oakland','94610','CA','');
 Insert into UTILITYCO_CUSTOMER#ASSET.CI_PREM (PREM_ID,ADDRESS1,CITY,STATE,POSTAL, PRNT_PREM_ID) values ('7591441927','484 Wickson St','Oakland','94610','CA','');
 Insert into UTILITYCO_CUSTOMER#ASSET.CI_PREM (PREM_ID,ADDRESS1,CITY,STATE,POSTAL, PRNT_PREM_ID) values ('6148457052','483 Wickson Ave','Oakland','22152','CA','');
 Insert into UTILITYCO_CUSTOMER#ASSET.CI_PREM (PREM_ID,ADDRESS1,CITY,STATE,POSTAL, PRNT_PREM_ID) values ('3360206503','507 Wicksen Ave','Oakland','94610','CA','');
 Insert into UTILITYCO_CUSTOMER#ASSET.CI_PREM (PREM_ID,ADDRESS1,CITY,STATE,POSTAL, PRNT_PREM_ID) values ('4888176288','811 York St','New York','94610','NY','');
 Insert into UTILITYCO_CUSTOMER#ASSET.CI_PREM (PREM_ID,ADDRESS1,CITY,STATE,POSTAL, PRNT_PREM_ID) values ('2314038674','742 Walker Ave','Oakland','94610','CA','');
 Insert into UTILITYCO_CUSTOMER#ASSET.CI_PREM (PREM_ID,ADDRESS1,CITY,STATE,POSTAL, PRNT_PREM_ID) values ('4064045431','746 Walker Ave','Oakland','94610','CA','');
 Insert into UTILITYCO_CUSTOMER#ASSET.CI_PREM (PREM_ID,ADDRESS1,CITY,STATE,POSTAL, PRNT_PREM_ID) values ('4788563223','763 Walker Ave','Oakland','94610','CA','');
 Insert into UTILITYCO_CUSTOMER#ASSET.CI_PREM (PREM_ID,ADDRESS1,CITY,STATE,POSTAL, PRNT_PREM_ID) values ('9485202767','3354 Grand Ave','Oakland','94610','CA','');
 Insert into UTILITYCO_CUSTOMER#ASSET.CI_PREM (PREM_ID,ADDRESS1,CITY,STATE,POSTAL, PRNT_PREM_ID) values ('2459661863','3316 Grand Ave','Oakland','94610','CA','');
    
 COMMIT;

Success

You have successfully imported data into your asset, and you are ready to move on to the next step. Next, you must create a Collection and map the asset data you just imported to your new Collection.