トピックアウトライン

• Projecting Data into InterSystems IRIS with Foreign Tables

  Projecting Data into InterSystems IRIS with Foreign Tables

  Content Type
  Video

  Duration
  4m

  Level
  Introductory

  See the benefits of projecting data into InterSystems IRIS® data platform using Foreign Tables. This feature allows you to access external data without loading it into your instance, saving on storage space and guaranteeing your data is up to date.
• Code Used in This Video

  Code Used in This Video

  Reference	Timestamp	Code
  Create a Foreign Server	3:23	Begin code. CREATE FOREIGN SERVER Example.DB FOREIGN DATA WRAPPER JDBC CONNECTION 'JDBCGatewayConnection' End code.
  Run a passthrough query using the THROUGH command	3:29	Begin code. THROUGH SERVER MySource.External SELECT Customers.CustomerID,Customers.FirstName,Order.OrderID,Orders.OrderDate FROM Customers JOIN Orders ON Customers.CustomerID = Order.CustomerID WHERE YEAR(Orders.OrderDate) = 2023 End code.
  Create a Foreign Table	3:34	Begin code. CREATE FOREIGN TABLE Example.Table SERVER Example.DB TABLE 'example.sourcetable' End code.
• What's Next?

  What's Next?
  • Read more about using foreign tables (documentation, 6m).
  • Get an introduction to SQL in InterSystems products (online course, 30m).
  • See how to use DDL to import relational data into your InterSystems IRIS instance (video, 6m).
  • Learn about the analytics tools available in InterSystems IRIS (video, 6m).