Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5851

teiid rename table in salesforce

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not a Bug
    • Major
    • None
    • None
    • Salesforce Connector
    • None
    • Hide

      I used DDL

      CREATE DATABASE db;
      USE DATABASE db;
      CREATE FOREIGN DATA WRAPPER salesforce;
      CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true);
      CREATE SERVER salesforce FOREIGN DATA WRAPPER mysalesforce OPTIONS ("resource-name" 'salesforce');
      CREATE SCHEMA sf SERVER salesforce;
      IMPORT FROM SERVER salesforce INTO sf OPTIONS("importer.useFullSchemaName" 'false');

      Show
      I used DDL CREATE DATABASE db; USE DATABASE db; CREATE FOREIGN DATA WRAPPER salesforce; CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true); CREATE SERVER salesforce FOREIGN DATA WRAPPER mysalesforce OPTIONS ("resource-name" 'salesforce'); CREATE SCHEMA sf SERVER salesforce; IMPORT FROM SERVER salesforce INTO sf OPTIONS("importer.useFullSchemaName" 'false');

    Description

      In example project connected to SF i have a table named "User" in SF but "User_" in teiid metadata.

      And another strange behavior is: system tables from teiid as GEOGRAPHY_COLUMNS
      GEOMETRY_COLUMNS placed in teiid server to same schema as Salesforce tables. May be "User_" named because we have same name in teiid metadata system names?

      So, select "SELECT Id, User.FirstName, User.LastName FROM Task LEFT OUTER JOIN User ON User.Id=Task.OwnerId" do not working.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            3draven Renat Eskenin (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: