Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need to pull data from a MS SQL database that was exported from MS Dynamics. Using the account example, there is techincally a accountbase table, and an accountExtension table. From SQL Server Management Studio, I can create query for only account and it would return rows from both tables. Is there a way to only query account in Talend Open Studio Data Integration (instead of having to query both accountbase and accountExtension)? Here is the schema from DB connection, showing both accountbase and account extension. Thank you for your suggestions.
It turns out you can also just query for account with the tDBInput component.
It turns out you can also just query for account with the tDBInput component.