November 2019 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5851) teiid rename table in salesforce

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5851: --------------------------------------- Copy and paste error. Corrected in the comment above to use the importer. prefix. > teiid rename table in salesforce > -------------------------------- > > Key: TEIID-5851 > URL: https://issues.jboss.org/browse/TEIID-5851 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > > 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. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5851) teiid rename table in salesforce

by Renat Eskenin (Jira)

[ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin... ] Renat Eskenin reopened TEIID-5851: ---------------------------------- Because i checked IMPORT FROM SERVER salesforce INTO sf OPTIONS("importer.useFullSchemaName" 'false', "NormalizeNames" 'false'); It do not working > teiid rename table in salesforce > -------------------------------- > > Key: TEIID-5851 > URL: https://issues.jboss.org/browse/TEIID-5851 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > > 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. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5851) teiid rename table in salesforce

by Renat Eskenin (Jira)

[ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin... ] Renat Eskenin commented on TEIID-5851: -------------------------------------- {code} CREATE DATABASE db; USE DATABASE db; CREATE FOREIGN DATA WRAPPER salesforce; CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'salesforce'); CREATE SCHEMA sf SERVER salesforce; IMPORT FROM SERVER salesforce INTO sf OPTIONS("importer.useFullSchemaName" 'false', "NormalizeNames" 'false'); {code} Table is still User_ > teiid rename table in salesforce > -------------------------------- > > Key: TEIID-5851 > URL: https://issues.jboss.org/browse/TEIID-5851 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > > 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. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5848) views in vertica not found by teiid

by Renat Eskenin (Jira)

[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin... ] Renat Eskenin commented on TEIID-5848: -------------------------------------- I create connection to jdbc teiid server with properties teiid.jdbc-enable=true teiid.host-name=127.0.0.1 and jdbc url jdbc:teiid:db.1@mm://local-HD3:31000 But with users "anonymous" or "user" i have Bad Credentials. How can i setup security and set password and user for teiid server in spring-boot application? > views in vertica not found by teiid > ----------------------------------- > > Key: TEIID-5848 > URL: https://issues.jboss.org/browse/TEIID-5848 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > > We created view in vertica DB > Example project with vertica translator+odata not found this view > {code} > src 1 Varchar 4 [NULL] true false false [NULL] false [NULL] > src_id 2 Varchar 18 [NULL] true false false [NULL] false [NULL] > src_name 3 Varchar 363 [NULL] true false false [NULL] false [NULL] > account_id 4 Varchar 18 [NULL] true false false [NULL] false [NULL] > name 5 Varchar 765 [NULL] true false false [NULL] false [NULL] > billing_country 6 Varchar 240 [NULL] true false false [NULL] false [NULL] > root_domain 7 Varchar 192 [NULL] true false false [NULL] false [NULL] > sales_team 8 Varchar 240 [NULL] true false false [NULL] false [NULL] > {code} > { > "error": { > "code": null, > "message": "Cannot find EntitySet, Singleton, ActionImport or FunctionImport with name 'funnel_leads'." > } > } > But regular tables works properly -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5851) teiid rename table in salesforce

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5851: --------------------------------------- It's an import property, so it belongs on the import statement: IMPORT FROM SERVER salesforce INTO sf OPTIONS("importer.useFullSchemaName" 'false', NormalizeNames false); > teiid rename table in salesforce > -------------------------------- > > Key: TEIID-5851 > URL: https://issues.jboss.org/browse/TEIID-5851 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > > 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. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5851) teiid rename table in salesforce

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin... ] Steven Hawkins edited comment on TEIID-5851 at 11/18/19 7:55 AM: ----------------------------------------------------------------- See http://teiid.github.io/teiid-documents/master/content/reference/Salesforc... NormalizeNames is a translator import property. Setting it to false will use the raw salesforce name. was (Author: shawkins): See http://teiid.github.io/teiid-documents/master/content/reference/Salesforc... NormalizeNames is a translator property. Setting it to false will use the raw salesforce name. > teiid rename table in salesforce > -------------------------------- > > Key: TEIID-5851 > URL: https://issues.jboss.org/browse/TEIID-5851 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > > 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. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5851) teiid rename table in salesforce

by Renat Eskenin (Jira)

[ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin... ] Renat Eskenin commented on TEIID-5851: -------------------------------------- Used ddl {code} CREATE DATABASE db; USE DATABASE db; CREATE FOREIGN DATA WRAPPER salesforce; CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true, NormalizeNames false); 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'); {code} {code} [2019-11-18 15:48:39,320 MSK] DEBUG [salesforce-failover-facade,,,] org.teiid.spring.autoconfigure.TeiidServer [restartedMain]: XML Form of VDB: <?xml version="1.0" encoding="UTF-8"?> <vdb name="db" version="1"> <connection-type>BY_VERSION</connection-type> <property name="full-ddl" value="CREATE DATABASE db; USE DATABASE db; CREATE FOREIGN DATA WRAPPER salesforce; CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true, NormalizeNames false); 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'); --SET SCHEMA sf; --ALTER TABLE User_ --RENAME TO User_1;"/> <model name="sf" type="PHYSICAL" visible="true"> <source connection-jndi-name="salesforce" name="salesforce" translator-name="mysalesforce"/> <metadata type="DDL"/> </model> <translator name="mysalesforce" type="salesforce"> <property name="NormalizeNames" value="false"/> <property name="supportsOrderBy" value="true"/> </translator> </vdb> {code} Table name is still User_ > teiid rename table in salesforce > -------------------------------- > > Key: TEIID-5851 > URL: https://issues.jboss.org/browse/TEIID-5851 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > > 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. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5851) teiid rename table in salesforce

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5851. ----------------------------------- Resolution: Explained See http://teiid.github.io/teiid-documents/master/content/reference/Salesforc... NormalizeNames is a translator property. Setting it to false will use the raw salesforce name. > teiid rename table in salesforce > -------------------------------- > > Key: TEIID-5851 > URL: https://issues.jboss.org/browse/TEIID-5851 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > > 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. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5851) teiid rename table in salesforce

by Renat Eskenin (Jira)

[ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin... ] Renat Eskenin commented on TEIID-5851: -------------------------------------- We have multiple systems witch same schema name and table names. So if teiid make broken names we need to change all our sql-soql requests :( > teiid rename table in salesforce > -------------------------------- > > Key: TEIID-5851 > URL: https://issues.jboss.org/browse/TEIID-5851 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > > 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. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5851) teiid rename table in salesforce

by Renat Eskenin (Jira)

[ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin... ] Renat Eskenin commented on TEIID-5851: -------------------------------------- I need to use this example SOQL from salesforce SELECT Id, Who.FirstName, Who.LastName FROM Task WHERE Owner.FirstName LIKE 'B%' SELECT Id, Owner.Name FROM Task WHERE Owner.FirstName like 'B%' > teiid rename table in salesforce > -------------------------------- > > Key: TEIID-5851 > URL: https://issues.jboss.org/browse/TEIID-5851 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > > 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. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2019