About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
How To
Summary
This document describes the process of importing data from an SQL view into your iBase database. For a more detailed presentation, view the following video: https://www.ibm.com/support/pages/ibm-i2-ibase-creating-and-importing-sql-view-ibm-i2-ibase
Environment
SQL Server
IBM i2 iBase
Steps
1. In SQL Server Management Studio, you create a view. Switch over to your target database and write a new query.
First, identify which fields you are wanting to create a view for. For example, I am looking to import the first name and last name of a person entity based on the condition that the person's country of birth is Argentina.
Structure of query for creating or updating a view:
CREATE OR ALTER VIEW view_name AS
SELECT column1, column2, column3 ...
FROM table_name
WHERE condition;
SELECT column1, column2, column3 ...
FROM table_name
WHERE condition;
GO
view_name = Test_view
column1 = First_Name
column2 = Last_Name
table_name = dbo.Person
condition = Place_of_birth = 'Argentina'
CREATE OR ALTER VIEW Test_view AS
SELECT First_Name, Last_Name
FROM dbo.Person_
WHERE Place_of_birth = 'Argentina';
GO
This view is saved as a table under the Views tab inside your database. Right click and "Select top 1000 rows" to view the results of the view.
2. Open iBase User. Navigate to the Import tab. Select the correct entity or link type and then choose the "OLE-DB Compliant data Source" as your source.
3. Select the Microsoft OLE DB Provider for SQL Server.
4. Enter your server name, login credentials, and database name. Test the connection.
5. If the connection test succeeds, proceed with the import.
Related Information
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSXW43","label":"i2 iBase"},"ARM Category":[{"code":"a8m50000000Ci92AAC","label":"i2 iBase and i2 Analyst's WorkStation->Import\/Export"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
More support for:
i2 iBase
Component:
i2 iBase and i2 Analyst's WorkStation->Import/Export
Software version:
All Versions
Document number:
6459949
Modified date:
07 June 2021
UID
ibm16459949