Topic outline

• Projecting Data into InterSystems IRIS with Foreign Tables

  Projecting Data into InterSystems IRIS with Foreign Tables

  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.

  Note:

  Foreign Tables are available in InterSystems IRIS 2023.1 as an experimental feature. You can start using Foreign Tables now through the Early Access Program.
• Code Used in This Video

  Code Used in This Video

  Reference	Timestamp	Code
  Create a Foreign Server	2:55	CREATE FOREIGN SERVER Example.DB FOREIGN DATA WRAPPER JDBC CONNECTION 'JDBCGatewayConnection'
  Create a Foreign Table	2:55	CREATE FOREIGN TABLE Example.Table SERVER Example.DB TABLE 'example.sourcetable'
• What's Next?

  What's Next?

  • Read more about using foreign tables (documentation, 6m).
  • Get an introduction to SQL in InterSystems products (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).